> Unless you also use a trim or other function at the same > time. > I seem to remember that it then doen't do the escaping for > you then, either.
I've not had any problems with using trim() ... Older version maybe? > Jerry Johnson >>>> [EMAIL PROTECTED] 08/29/02 01:49PM >>> >> Does anyone know how to escape charachters in SQL server >> - to be more >> specific I am buiding a string where I need to escape a >> double quote so >> the string isn't prematurely completed. > Unless you're using #preservesinglequotes()# around your > variable, you > shouldn't have to worry about escaping the single quotes > -- ColdFusion's > cfquery tag will do that for you... > Isaac Dealey > Certified Advanced ColdFusion 5 Developer > www.turnkey.to > 954-776-0046 > __________________________________________________________ > ____________ > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: > http://www.mail-archive.com/[email protected]/ > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
