webstore SQL Where clause

[heinbreedt]

Hey there guys. Im having problems with my WHERE clause in a fairly simple webstore sql query. I can open the recordset so theres nothing syntactically wrong, but it doesnt return any records. When I remove the where clause, the recordset opens and contains records with properties and values which I specify in my WHERE clause.

Heres my SQL:
select "http://broad/str/InvNo" From scope(shallow traversal of "http://broadtech-serv/year2002/SearchFolders/Invoices") where "http://broad/str/Invno" = "45897"

The Invoices searchfolder contains a folder "45897" with the property "http://broad/str/InvNo" and its value is "45897"
Please note the datatype for this property is string

One more thing: If I change my where clause so that it reads WHERE "DAV:displayname" = 45897 it returns the record.

I have tried changing the property value to "kk" (only alphabtecial) but it still doesnt return anything when I search on it.

Any ideas?

 

[stustarz]

Try changing the where clause to this:

where "http://broad/str/Invno" = 45897

Remove the " around the string and just leave the