So you're saying that using the native driver doesn't escape single quotes?
Darryl Lyons [EMAIL PROTECTED] wrote on 17/02/2005 08:48:38 AM: > 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/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group. A principal member of the Financial Planning Association. --- 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/
