|
Home > Archive > IIS Index Server > May 2004 > Searching Index based on date modified...help.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Searching Index based on date modified...help.
|
|
|
| I created a C# web application as outlined in
http://support.microsoft.com/?id=820983
I am attemping to get all files modifed in the past 24 hours. I am using the
query
"SELECT DocTitle,Filename,Size,PATH,URL FROM Scope() WHERE @write > -1d"
This gives me the error message "Incorrect syntax near '@'. Expected '(',
NOT, CAST, CONTAINS, CREATE, FREETEXT, MATCHES, PASSTHROUGH, ID.
SQLSTATE=42000"
I am new to Index Server programming...so I am not quite sure what to do. I
searched google and msdn extensivly before this post and could not find a
solution. Thanks for any help!
| |
| Hilary Cotter 2004-05-01, 7:33 am |
| SELECT DocTitle,Filename,Size,PATH,URL FROM Scope() WHERE write >
dateadd(dd,-1,getgmtdate())
"Paul" <guitarpl@yahoo.com> wrote in message
news:eiwSQmsLEHA.1388@TK2MSFTNGP09.phx.gbl...
> I created a C# web application as outlined in
> http://support.microsoft.com/?id=820983
>
> I am attemping to get all files modifed in the past 24 hours. I am using
the
> query
>
> "SELECT DocTitle,Filename,Size,PATH,URL FROM Scope() WHERE @write > -1d"
>
> This gives me the error message "Incorrect syntax near '@'. Expected '(',
> NOT, CAST, CONTAINS, CREATE, FREETEXT, MATCHES, PASSTHROUGH, ID.
> SQLSTATE=42000"
>
> I am new to Index Server programming...so I am not quite sure what to do.
I
> searched google and msdn extensivly before this post and could not find a
> solution. Thanks for any help!
>
>
|
|
|
|
|