Hi Steve, Yup thats exactly what I want to do. See the description may have special characters within it. We have discovered that when you make an SQL connection to the database in the CF Admin using the Native MSSQL, it will throw errors when you try inserting data. But Apparently if you use an ODBC connection (I have yet to try this as its still early in the morning and I'm about to test this) it will not give you the error.
Long story short. UPDATE tbl_JobOrder SET JobTitle = 'JobTitle', JobOrderDesc = 'jeremy need's a new job' WHERE Jeremy = 'I am cheap' AND Scott = 'my crack hoe' <---- hahahaha I crack me up... No seriously thats it. Where Jeremy need's a new job it read the ' mark as a closing mark. Thats it. > 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/
