hi there.
could anyone please tell me how in the heck i can
do a dbquery to get all instances of a match of these
’
in that exact string from within a text (Datatype) field full of other
data?
they are supposed to be 's and for some odd reason, in my cut and
paste from word to a text file, then into a textarea formfield, ended up
in the db like "driver’s" where that should be "driver's" like
"driver's license"
anyway, its making life hell right now, and i gotta get em out!
thanks.
this isnt working...
<cfquery name="get1" datasource="acts">
select count(Id) as thisCount from seatBeltLaws where line like
'%�tm%'
</cfquery>
<cfoutput>#get1.thisCount#</cfoutput>
wow its getting late.
...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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
