Why would you be doing that anyway. from what ic an see your query is going to look like this
UPDATE tbl_JobOrder SET JobTitle = 'JobTitle', JobOrderDesc = '1 ' 2' ' 3', which is going to error big time what are you trying to do exactly? Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeremy Sent: Wednesday, February 16, 2005 1:44 PM To: CFAussie Mailing List Subject: [cfaussie] Single Quotes Hi Guys, IF anyone is left. See everyone I know is going to MXDU...*sigh* my company won't let me go to the toliet without a hall monitor pass. So my question is this. Can you use PreserveSingleQuote() in a SQL statement. Because it seems to be ignoring it and I'm not sure. Example <cfset JobDesc = "1 ' 2' ' 3"> <cfquery name="QNAME" datasource="MyDSN"> UPDATE tbl_JobOrder SET JobTitle = '#JobTitle#', JobOrderDesc = '#PreserveSingleQuotes(JobDesc)#', I also tried setting it outside of the query but get the same results. I'm on the verge of removing the quotes all together. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
