When I do an update or insert using the following code: <cfset program = "Pete's String"> <cfqueryparam cfsqltype="CF_SQL_CHAR" value="#trim(program)#">
The string in the SQL server database looks like "Pete''s String". There are 2 single quotes in the name Pete. Any ideas why it is adding the extra single quote? Many Thanks, Pete --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
