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/
