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.
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
