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/
