TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Advanced Query
From:
"Christian, Jessie" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 26 Feb 2013 17:28:41 -0500
Content-Type:
multipart/related
Parts/Attachments:
text/plain (43 kB) , text/html (43 kB) , image003.jpg (43 kB) 
I am trying to perform an advanced query to find all photographs in our collection. The following query indicates the three departments I don't want to include as well as the two object number strings I don't want included. However, even when I play with AND/OR operators and parenthesis, I still get the error: Incorrect syntax near the keyword 'ORDER'. Any ideas?

Thanks!
jessie

[cid:image003.jpg@01CE1446.B81B0D90]

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2