Paul, > i am having a bit of a problem with this > >i have this search i am working on >every thing works fine, except the column that stores numbers like >1994-5668-273749-2 >it is a varchar field in the db
First, is that an actual example of a phrase? For example, the LIKE operator can filter on a range of characters, like: AND ReferAgencyNo LIKE '[B-D]an' This would match Ban, Can, Dan. It's possible that CF is interpreting the dash as processing instruction. You might try escaping the dash and see if that helps: SELECT * FROM SomeTable WHERE ReferAgencyNo LIKE '%1994\-%' ESCAPE '\' Also, try some hardcode values first, before using dynamic values. Just to make sure the exact code you want to run is working correctly. Lastly, almost every time I've gone to use QoQ on anything more than some simple re-ordering or filtering by ints, I seem to find some bug. For example, I ran into a bug in CFMX 6.1 that preventing me from using apostrophes while using an IN clause on a list of varchars. It would not allow me to escape the apostrophe. I ended up having to write a UDF to solve me issue. I've found other weird bugs that exist in QoQ in that past. Things that are completely valid TSQL, that would just not work correctly. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
