Just a WAG: It maybe that the odbc driver is not passing those characters through to the database correctly.
> ><cfquery name="get1" datasource="acts"> > select line, id from seatBeltLaws where line like '%’%' ></cfquery> > >why can i put that same query in query analyzer, get 24 records that >have some >of those freakin characters contained within, however when i run it in a >the above >cf code, i get nothing? > >WTF!!!!!!!!!!!!!!!!!! > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
