What is the DB? As I noted, my example used the exact same ColdFusion version as you, same DataDirect drivers.
What error did you get - and I mean an exact error - what datatype did you try to insert into? I tested this on 5 different ColdFusion servers and all worked - first time (this was on J2EE and Server Config) If you have been developing for a good time you should know that cfqueryparam preserves quotes by default - or you could use an SP. Also, if you think it is an error/bug then log sn issue with MM. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: CFAussie Mailing List <cfaussie@lists.daemon.com.au> Sent: Thu Nov 10 21:53:58 2005 Subject: [cfaussie] Re: Single Quote Preservation Neil, I don't care what you say.... I have had the 3.4 drivers installed and the code did not work, I installed the 3.5 drivers and the code did work. The code in question did in fact have the cfqueryparam and to test my theory I decide to go to vanilla query to see if it was something else. It also had a problem, and then I update the drivers and it was fixed on the vanilla, and then when run against the proper code with the cfqueryparam it worked. Which is also why I posted the version number to see if there were other influences in this as well. I have been developing coldfusion long enough to try all options before posting here. Regards, Andrew Scott Quote of the Day: Teachers open the door, but you must enter by yourself. - Chinese Proverb -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: Thursday, 10 November 2005 9:09 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Single Quote Preservation Well, no, it shows how little you know!; see below - this is using 3.4 drivers (same version of CF) accessing a SQL DB (Northwind sample);if you have the DB setup as a DSN in CF this will work out of the box. It works fine; There is no way that this would not be known in the 3.4 drivers for this duration of time and no one spotted it. I think there was an issue with Oracle but not SQL server. <cfset drivernames = "macromedia.jdbc.oracle.OracleDriver, macromedia.jdbc.db2.DB2Driver, macromedia.jdbc.informix.InformixDriver, macromedia.jdbc.sequelink.SequeLinkDriver, macromedia.jdbc.sqlserver.SQLServerDriver, macromedia.jdbc.sybase.SybaseDriver"> <cfset drivernames=Replace(drivernames," ","","ALL")><!--- replace all spaces ---> <cfloop index="drivername" list="#drivernames#"> <cfobject action="CREATE" class="#drivername#" name="driver" type="JAVA"> <cfset args= ArrayNew(1)> <cfset driver.main(args)> <cfoutput>#drivername# is #driver.getMajorVersion()#.#driver.getMinorVersion()#<br></cfoutput> </cfloop> <cfquery name="insert" datasource="northwind"> UPDATE Orders SET ShipName = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="God's Kitchen 05"> WHERE orderid = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="10251"> </cfquery> <cfquery name="qselect" datasource="northwind"> SELECT ShipName FROM ORDERS WHERE orderid = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="10251"> </cfquery> <CFDUMP VAR="#qselect#"> <!--- this will return "God's Kitchen 05"---> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: 10 November 2005 09:57 To: CFAussie Mailing List Subject: [cfaussie] Re: Single Quote Preservation How little you actually know then!! Regards, Andrew Scott Quote of the Day: Homer Simpson: When I first heard that Marge was joining the police academy, I thought it would be fun and zany, like that movie Spaceballs. But instead it was dark and disturbing. Like that movie -- Police Academy. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: Thursday, 10 November 2005 7:52 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Single Quote Preservation Indeed, it should. I would doubt that this would have went unoticed to MM/DataDirect if it were an issue with the new drivers (I think 3.4 are the new editions). --- 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/ This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com --- 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/ This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
