Microsoft AQS - Advanced Query Syntax

		** Source: http://msdn.microsoft.com/en-us/library/aa965711%28v=vs.85%29.aspx
Query Syntax:	store:<data store>
Restrict Search by Data Store	Use	Example
Desktop	desktop	store:desktop
Files	files	store:files
Outlook	outlook	store:outlook
Outlook Express	oe	store:oe
Specific Folder	foldername or in	foldername:MyDocuments or in:MyDocuments
Query Syntax:	<value> <operator> <value>
Keyword/Symbol	Examples	Function
NOT	social NOT security	Finds items that contain social, but not security.
–	social –security	Finds items that contain social, but not security.
OR	social OR security	Finds items that contain social or security.
Quotation marks	"social security"	Finds items that contain the exact phrase social security.
Parentheses	(social security)	Finds items that contain social and security in any order.
>	date:>11/05/04	Finds items with a date after 11/05/04.
	size:>500	Finds items with a size greater than 500 bytes.
<	date:<11/05/04	Finds items with a date before 11/05/04.
	size:<500	Finds items with a size less than 500 bytes.
..	date:11/05/04..11/10/04	Finds items with a date beginning on 11/05/04 and ending on 11/10/04.
Query Syntax:	<value> <property>
Boolean Property	Example	Function
is:attachment	report is:attachment	Finds items that have attachments that contain report. Same as isattachment:true.
isonline:	report isonline:true	Finds items that are online and which contain report.
isrecurring:	report isrecurring:true	Finds items that are recurring and which containreport.
isflagged:	report isflagged:true	Finds items that are flagged (Review, Follow up, for example) and which contain report.
isdeleted:	report isdeleted:true	Finds items that are flagged as deleted (Recycle Bin or Deleted Items, for example) and which contain report.
iscompleted:	report iscompleted:false	Finds items that are not flagged as complete and which contain report.
hasattachment:	report hasattachment:true	Finds items containing report and having attachments
hasflag:	report hasflag:true	inds items containing report and having flags.
Query Syntax:	kind:everything <property>:<value>
To Restrict by File Type:	Use	Example
All file types	everything	kind:everything
Communications	communications	kind:communications
Contacts	contacts	kind:contacts
E-mail	email	kind:email
Instant Messenger conversations	im	kind:im
Meetings	meetings	kind:meetings
Tasks	tasks	kind:tasks
Notes	notes	kind:notes
Documents	docs	kind:docs
Text documents	text	kind:text
Spreadsheets	spreadsheets	kind:spreadsheets
Presentations	presentations	kind:presentations
Music	music	kind:music
Pictures	pics	kind:pics
Videos	videos	kind:videos
Folders	folders	kind:folders
Folder name	foldername or in	foldername:mydocs or in:mydocs
Favorites	favorites	kind:favorites
Programs	programs	kind:programs
Query Syntax:	see below
Dates Relative to:	Syntax Example	Result
Day	date:today	Finds items with today's date.
	date:tomorrow	Finds items with tomorrow's date.
	date:yesterday	Finds items with yesterday's date.
Week/Month/year	date:this week	Finds items with a date falling within the current week.
	date:last week	Finds items with a date falling within the previous week.
	date:next month	Finds items with a date falling within the upcoming week.
	date:past month	Finds items with a date falling within the previous month.
	date:coming year	Finds items with a date falling within the upcoming year.
Query Syntax:	kind:everything <property>:<value>
Property	Use	Example
Title	title, subject or about	title:"Quarterly Financial"
Status	status	status:complete
Date	date	date:last week
Date modified	datemodified or modified	modified:last week
Importance	importance or priority	importance:high
Size	size	size:> 50
Deleted	deleted or isdeleted	isdeleted:true
Is attachment	isattachment	isattachment:true
To	to or toname	to:bob
Cc	cc or ccname	cc:john
Company	company	company:Microsoft
Location	location	location:"Conference Room 102"
Category	category	category:Business
Keywords	keywords	keywords:"sales projections"
Album	album	album:"Fly by Night"
File name	filename or file	filename:MyResume
Genre	genre	genre:rock
Author	author or by	author:"Stephen King"
People	people or with	with:(sonja or david)
Folder	folder, under or path	folder:downloads
File extension	ext or fileext	ext:.txt
Query Syntax:	kind:attachment <property>:<value>
Property	Use	Example
People	people or with	people:john or with:john
Query Syntax:	kind:contacts <property>:<value>
Property	Use	Example
Job title	jobtitle	jobtitle:CFO
IM address	imaddress	imaddress:john_doe@msn.com
Assistant's phone	assistantsphone	assistantsphone:555-3323
Assistant name	assistantname	assistantname:Paul
Profession	profession	profession:plumber
Nickname	nickname	nickname:Tex
Spouse	spouse	spouse:Debbie
Business city	businesscity	businesscity:Seattle
Business postal code	businesspostalcode	businesspostalcode:98006
Business home page	businesshomepage	businesshomepage:www.microsoft.com
Callback phone number	callbackphonenumber	callbackphonenumber:555-555-2121
Car phone	carphone	carphone:555-555-2121
Children	children	children:Timmy
First name	firstname	firstname:John
Last name	lastname	lastname:Doe
Home fax	homefax	homefax:555-555-2121
Manager's name	managersname	managersname:John
Pager	pager	pager:555-555-2121
Business phone	businessphone	businessphone:555-555-2121
Home phone	homephone	homephone:555-555-2121
Mobile phone	mobilephone	mobilephone:555-555-2121
Office	office	office:sample
Anniversary	anniversary	anniversary:1/1/06
Birthday	birthday	birthday:1/1/06
Web page	webpage	webpage:www.microsoft.com
Query Syntax:	kind:communications <property>:<value>
Property	Use	Example
From	from or organizer	from:john
Received	received or sent	sent:yesterday
Subject	subject or title	subject:"Quarterly Financial"
Has attachment	hasattachments, hasattachment	hasattachment:true
Attachments	attachments or attachment	attachment:presentation.ppt
Bcc	bcc, bccname or bccaddress	bcc:dave
Cc address	ccaddress or cc	ccaddress:john_doe@hotmail.com
Follow-up flag	followupflag	followupflag:2
Due date	duedate or due	due:last week
Read	read or isread	is:read
Is completed	iscompleted	is:completed
Incomplete	incomplete or isincomplete	is:incomplete
Has flag	hasflag or isflagged	has:flag
Duration	duration	duration:> 50
Query Syntax:	kind:calendar <property>:<value>
Property	Use	Example
Recurring	recurring or isrecurring	is:recurring
Organizer	organizer, by or from	organizer:debbie
Query Syntax:	kind:documents <property>:<value>
Property	Use	Example
Comments	comments	comments:"needs final review"
Last saved by	lastsavedby	lastsavedby:john
Document manager	documentmanager	documentmanager:john
Revision number	revisionnumber	revisionnumber:1.0.3
Document format	documentformat	documentformat:MIMETYPE
Date last printed	datelastprinted	datelastprinted:last week
Query Syntax:	kind:presentation <property>:<value>
Property	Use	Example
Slide count	slidecount	slidecount:>20
Query Syntax:	kind:music <property>:<value>
Property	Use	Example
Bit rate	bitrate, rate	bitrate:192
Artist	artist, by or from	artist:John Singer
Duration	duration	duration:3
Album	album	album:"greatest hits"
Genre	genre	genre:rock
Track	track	track:12
Year	year	year:> 1980 < 1990
Query Syntax:	kind:picture <property>:<value>
Property	Use	Example
Camera make	cameramake	cameramake:sample
Camera model	cameramodel	cameramodel:sample
Dimensions	dimensions	dimensions:8X10
Orientation	orientation	orientation:landscape
Date taken	datetaken	datetaken:yesterday
Width	width	width:1600
Height	height	height:1200
Query Syntax:	kind:video <property>:<value>
Property	Use	Example
Name	name, subject	name:"Family Vacation to the Beach 05"
Ext	ext, fileext	ext:.avi

Compiling Ruby on Rails on PowerPC

I had need of a Rails development environment but was low on options. So I pulled out an old Mac Mini running OS X 10.5.8. I downloaded Xcode 3.1.4 from the Apple Developer site.  I think 3.1.4 is the last version of Xcode Apple released for 10.5

RubyonRails.org does not offer a pre-compiled version for PowerPC so I had to download the source for Ruby and compile it. Compiling Ruby 1.8.6 went without incident. I then installed Gem 1.8.24.

When I ran "/usr/local/bin/ruby setup.rb" I received the following message:
     "It seems your ruby installation is missing psych (for VAML output). To eliminate this warning, please install libyaml and reinstall your ruby."

Since it is just a warning, I decided to proceed rather than track down the libyaml library. But when I ran "gem install rails" I received the following message:
     "ERROR: While executing gem ... (Gem::RemoteSourceException) HTTP Response 302 fetching http://gems.rubyforge.org/yaml"

SupportSages had the fix to my issue.  Following their article I did the following:
     1) "gem install rubygems-update --source http://production.s3.rubygems.org/"
     2) "gem update --system --source http://production.s3.rubygems.org/"
     3) "gem sources -a http://production.s3.rubygems.org/"

My next stumbling block was when I tried to install rails a second time. When I ran "gem install rails" again I recieved the following error:
     "ERROR: Error installing rails: activesupport requires Ruby version >= 1.8.7"

[UPDATE 1]

abaird had a solution that worked for me. His solution is meant for Windows, not for PowerPC but it gave me a clue.  So I did a little research and it looks like activesupport 2.3.14 should meet my needs. So I ran:
     1) "gem install activesupport -v 2.3.14"

So, we'll see if I have what I need.  At the moment i have the following installed on a PowerPC instance of OS X 10.5.8:
     - "ruby -v" returns "ruby1.8.6 (2009-06-08 patchlevel 369) [universal-darwin9.0]"
     - "rails -v" returns "rails 1.2.6"

[UPDATE 2]

The normal "rails server" command did not start my default rails app.  After creating the initial app, I had to run "./scripts/server" to load it. I will need to remember to add that command to the server startup scripts.

pinboard

As you may have read, Yahoo has decided to can del.icio.us.  Having been a long time user of delicious, that news has caused some anxiety.  I have looked around at the options and settled on pinboard.

Pinboard is basically delicious but with a few variations.  I can now post links via email.  It has an "unread" feature - not sure why but it is there and may be of use to someone.  beyond that, it is delicious for all intents and purposes from a user perspective.

It does cost, but it is a one time fee and at the moment is less than $10.  I think the cost is justifiable, you may not - but take a look at it.

Lingon

At some point Apple made the decision to deprecate cron.  They replaced that functionality with launchd & launchctl.  I recently found a gui app that simplifies the process of interacting with launchd & it is called Lingon.

It has a clean interface and straight forward options.  For individuals that need a little extra help there is a wizard you can use via the "Assist" button.  The wizard will ask a few questions, ask for some input based on the way you answered the questions and generate the plist file you need and launch it, if you configured it to launch.

Take a look at it over at Sourceforge.

SetACL notes

To take ownership: SetACL -on "[path]" -ot file -actn setowner -ownr "n:Administrators;s:n" -rec cont_obj

To enable inheritance: SetACL -on "[path]" -ot file -actn setprot -op "dacl:np;sacl:nc" -rec cont_obj




- Posted using BlogPress from my iPhone

Run an interactive EXE with system

This works for XP, W2K, W23:

sc create testsvc binpath= "cmd /K start" type= own type= interact

If this command succeeds, just start the service.

From:blogs.madness.com/b/adioltean/archive/2004/11/27/271063.aspx

- Posted using BlogPress from my iPhone

Excel mod

For me, in Excel 2007, spreadsheets always open in the same "master" Excel window.  If I want to view two spreadsheets concurrently I have to use the internal Excel windows manager and my view is limited to the size of the "master/Primary" window.

Jarrah of "Jarrah's Blog Pile" has a great solution/mod for this issue.  Follow his instructions and you can launch multiple instances of excel, each with only one spreadsheet.


Here is a link to his instructions: How to make Excel open each file in a separate window