Single Quote Preservation

[Andrew Scott-2]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Anyone able to answer this one.

 

I am currently running this version of CF MX 6,1,0,hf56580_611

 

The problem is that the query no longer preserves single quotes anymore, yet the documentation says that it does.

 

Now I though I would try to save the query into a string, and Try #PreserveSingleQuote(SQL)# and it still will not work, anyone know of a known issue here?

 

 

Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
We shall not flag or fail. We shall go on to the end. We shall fight in France, we shall fight on the seas and the oceans, we shall fight with growing confidence and growing strength in the air, we shall defend our island, whatever the cost may be. We shall fight on the beaches, we shall fight on the landing grounds, we shall fight in the fields and in the streets, we shall fight in the hills; we shall never surrender. - Sir Winston Leonard Spencer Churchill
------------------------------------------------------------------------------------------------------

---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@... Aussie Macromedia Developers: http://lists.daemon.com.au/

[rod.higgins]

Hey Andrew,

Code snippet?

Cheers
Rod

> Anyone able to answer this one.
>
>
>
> I am currently running this version of CF MX 6,1,0,hf56580_611
>
>
>
> The problem is that the query no longer preserves single quotes anymore,
> yet
> the documentation says that it does.
>
>
>
> Now I though I would try to save the query into a string, and Try
> #PreserveSingleQuote(SQL)# and it still will not work, anyone know of a
> known issue here?
>
>
>
>
>
> Regards
> Andrew Scott
> Analyst Programmer
>
> CMS Transport Systems
> Level 2/33 Bank Street
> South Melbourne, Victoria, 3205
>
> Phone: [phone]  -  Fax: [phone]
>
>
> Quote:
> We shall not flag or fail. We shall go on to the end. We shall fight in
> France, we shall fight on the seas and the oceans, we shall fight with
> growing confidence and growing strength in the air, we shall defend our
> island, whatever the cost may be. We shall fight on the beaches, we shall
> fight on the landing grounds, we shall fight in the fields and in the
> streets, we shall fight in the hills; we shall never surrender. - Sir
> Winston Leonard Spencer Churchill
> ----------------------------------------------------------------------------
> --------------------------
>
>
>
> ---
> You are currently subscribed to cfaussie as: rod.higgins@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
>
>
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

Well its simple

<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'God's Kitchen 05' )
</cfquery>

Can't get any simpler than that.


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
Blind people don't bungee jump. It scares the dog too much.
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of
rod.higgins@...
Sent: Thursday, 10 November 2005 10:15 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Hey Andrew,

Code snippet?

Cheers
Rod

> Anyone able to answer this one.
>
>
>
> I am currently running this version of CF MX 6,1,0,hf56580_611
>
>
>
> The problem is that the query no longer preserves single quotes anymore,
> yet
> the documentation says that it does.
>
>
>
> Now I though I would try to save the query into a string, and Try
> #PreserveSingleQuote(SQL)# and it still will not work, anyone know of a
> known issue here?
>
>
>
>
>
> Regards
> Andrew Scott
> Analyst Programmer
>
> CMS Transport Systems
> Level 2/33 Bank Street
> South Melbourne, Victoria, 3205
>
> Phone: [phone]  -  Fax: [phone]
>
>
> Quote:
> We shall not flag or fail. We shall go on to the end. We shall fight in
> France, we shall fight on the seas and the oceans, we shall fight with
> growing confidence and growing strength in the air, we shall defend our
> island, whatever the cost may be. We shall fight on the beaches, we shall
> fight on the landing grounds, we shall fight in the fields and in the
> streets, we shall fight in the hills; we shall never surrender. - Sir
> Winston Leonard Spencer Churchill
>

----------------------------------------------------------------------------

> --------------------------
>
>
>
> ---
> You are currently subscribed to cfaussie as: rod.higgins@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
>
>
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as: andrews@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/




---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[David Harris-4]

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'Gods Kitchen 05' )
</cfquery>

-----Original Message-----
From: bounce-cfaussie-11680@...
[mailto:bounce-cfaussie-11680@...] On Behalf Of Andrew
Scott
Sent: Thursday, 10 November 2005 12:16 p.m.
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation




Well its simple

<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'God's Kitchen 05' )
</cfquery>

Can't get any simpler than that.


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
Blind people don't bungee jump. It scares the dog too much.
------------------------------------------------------------------------
----
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of
rod.higgins@...
Sent: Thursday, 10 November 2005 10:15 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Hey Andrew,

Code snippet?

Cheers
Rod

> Anyone able to answer this one.
>
>
>
> I am currently running this version of CF MX 6,1,0,hf56580_611
>
>
>
> The problem is that the query no longer preserves single quotes
> anymore, yet the documentation says that it does.
>
>
>
> Now I though I would try to save the query into a string, and Try
> #PreserveSingleQuote(SQL)# and it still will not work, anyone know of
> a known issue here?
>
>
>
>
>
> Regards
> Andrew Scott
> Analyst Programmer
>
> CMS Transport Systems
> Level 2/33 Bank Street
> South Melbourne, Victoria, 3205
>
> Phone: [phone]  -  Fax: [phone]
>
>
> Quote:
> We shall not flag or fail. We shall go on to the end. We shall fight
> in France, we shall fight on the seas and the oceans, we shall fight
> with growing confidence and growing strength in the air, we shall
> defend our island, whatever the cost may be. We shall fight on the
> beaches, we shall fight on the landing grounds, we shall fight in the
> fields and in the streets, we shall fight in the hills; we shall never

> surrender. - Sir Winston Leonard Spencer Churchill
>
------------------------------------------------------------------------
----

> --------------------------
>
>
>
> ---
> You are currently subscribed to cfaussie as:
> rod.higgins@... To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
>
>
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as: andrews@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/




---
You are currently subscribed to cfaussie as: davidh@... To
unsubscribe send a blank email to
leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

This email contains confidential information. If you are not the intended recipient of this email, please notify Straker Interactive and delete the email. You are not entitled to use it in any way.


---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

David,

I did say that under CFMX the preserve single quotes according to the
documentation preserves single quotes!!

And I did also say that I have tried PreserveSingleQuotes I believe I did, I
think yes I did actually!!


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
"Space...is big. Really big. You just won't believe how vastly hugely
mindbogglingly big it is. I mean you may think it's a long way down the road
to the chemist, but that's just peanuts to space. "  Douglas Adams
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of David Harris
Sent: Thursday, 10 November 2005 10:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'Gods Kitchen 05' )
</cfquery>



---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[rod.higgins]

 <cfquery name="insert" database="Database">
  Insert into Tablename
  ( Fieldname ) values ( 'God''s Kitchen 05' )
 </cfquery>

OR

<cfset valText="God's Kitchen 05">
<cfquery name="insert" database="Database">
  Insert into Tablename
  ( Fieldname ) values ( #PreserveSingleQuotes(valText)#)
 </cfquery>

Do either of these options work?

hth
Rod

>
> Well its simple
>
> <cfquery name="insert" database="Database">
>  Insert into Tablename
>  ( Fieldname ) values ( 'God's Kitchen 05' )
> </cfquery>
>
> Can't get any simpler than that.
>
>
> Regards
> Andrew Scott
> Analyst Programmer
>
> CMS Transport Systems
> Level 2/33 Bank Street
> South Melbourne, Victoria, 3205
>
> Phone: [phone]  -  Fax: [phone]
>
> Quote:
> Blind people don't bungee jump. It scares the dog too much.
> ----------------------------------------------------------------------------
> --------------------------
> -----Original Message-----
> From: bounce-cfaussie-12196@...
> [mailto:bounce-cfaussie-12196@...] On Behalf Of
> rod.higgins@...
> Sent: Thursday, 10 November 2005 10:15 AM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: Single Quote Preservation
>
> Hey Andrew,
>
> Code snippet?
>
> Cheers
> Rod
>
>> Anyone able to answer this one.
>>
>>
>>
>> I am currently running this version of CF MX 6,1,0,hf56580_611
>>
>>
>>
>> The problem is that the query no longer preserves single quotes anymore,
>> yet
>> the documentation says that it does.
>>
>>
>>
>> Now I though I would try to save the query into a string, and Try
>> #PreserveSingleQuote(SQL)# and it still will not work, anyone know of a
>> known issue here?
>>
>>
>>
>>
>>
>> Regards
>> Andrew Scott
>> Analyst Programmer
>>
>> CMS Transport Systems
>> Level 2/33 Bank Street
>> South Melbourne, Victoria, 3205
>>
>> Phone: [phone]  -  Fax: [phone]
>>
>>
>> Quote:
>> We shall not flag or fail. We shall go on to the end. We shall fight in
>> France, we shall fight on the seas and the oceans, we shall fight with
>> growing confidence and growing strength in the air, we shall defend our
>> island, whatever the cost may be. We shall fight on the beaches, we
>> shall
>> fight on the landing grounds, we shall fight in the fields and in the
>> streets, we shall fight in the hills; we shall never surrender. - Sir
>> Winston Leonard Spencer Churchill
>>
> ----------------------------------------------------------------------------
>> --------------------------
>>
>>
>>
>> ---
>> You are currently subscribed to cfaussie as: rod.higgins@...
>> To unsubscribe send a blank email to
>> leave-cfaussie-23165F@...
>>
>>
>> Aussie Macromedia Developers: http://lists.daemon.com.au/
>>
>
>
>
> ---
> You are currently subscribed to cfaussie as: andrews@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>
>
>
>
> ---
> You are currently subscribed to cfaussie as: rod.higgins@...
> To unsubscribe send a blank email to
> leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

If anyone is interested the problem lied in the Macromedia JDBC Drivers V3.4

Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
The essence of all jokes, of all comedy, seems to be an honest or well
intended halfness; a non performance of that which is pretended to be
performed, at the same time that one is giving loud pledges of performance.
The balking of the intellect, is comedy and it announces itself in the
pleasant spasms we call laughter. - Ralph Waldo Emerson
----------------------------------------------------------------------------
--------------------------

-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of Andrew Scott
Sent: Thursday, 10 November 2005 10:23 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

David,

I did say that under CFMX the preserve single quotes according to the
documentation preserves single quotes!!

And I did also say that I have tried PreserveSingleQuotes I believe I did, I
think yes I did actually!!


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
"Space...is big. Really big. You just won't believe how vastly hugely
mindbogglingly big it is. I mean you may think it's a long way down the road
to the chemist, but that's just peanuts to space. "  Douglas Adams
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of David Harris
Sent: Thursday, 10 November 2005 10:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'Gods Kitchen 05' )
</cfquery>



---
You are currently subscribed to cfaussie as: andrews@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/




---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Daniel Crowther]

Andrew

Have you tried using <cfqueryparam>

<cfquery name="insert" database="Database">  Insert into Tablename  (
Fieldname ) values ( <cfqueryparam value="God's Kitchen 05"> ) </cfquery>

Regards
Daniel Crowther

 

Chief Information Officer
M: 0412 931 398
E: daniel@...
W: www.sitehand.com


-----Original Message-----
From: bounce-cfaussie-21282@...
[mailto:bounce-cfaussie-21282@...] On Behalf Of Andrew Scott
Sent: Thursday, 10 November 2005 9:23 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

David,

I did say that under CFMX the preserve single quotes according to the
documentation preserves single quotes!!

And I did also say that I have tried PreserveSingleQuotes I believe I did, I
think yes I did actually!!


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
"Space...is big. Really big. You just won't believe how vastly hugely
mindbogglingly big it is. I mean you may think it's a long way down the road
to the chemist, but that's just peanuts to space. "  Douglas Adams
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of David Harris
Sent: Thursday, 10 November 2005 10:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">  Insert into Tablename  (
Fieldname ) values ( 'Gods Kitchen 05' ) </cfquery>



---
You are currently subscribed to cfaussie as: daniel.crowther@... To
unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/



---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Ryan Sabir]

All the 'PreserveSingleQuotes(SQL)' function will do it pass your string to the database server unadulterated. If you don’t use it then CF will automatically double up on all the single quotes in your string. For example

<CFSET name = "O'Brien">
<CFQUERY>
        INSERT
      INTO names (thename)
        VALUES ('#name#')
</CFQUERY>

This gets sent to the DB server looking like this:
INSERT
INTO names (thename)
VALUES ('O''Brien')

Automagically! Its one of the things CF does for us behind the scenes.

If you want to write the string directly you would need to double the qutoes yourself:

<CFQUERY>
        INSERT
      INTO names (thename)
        VALUES ('O''Brien')
</CFQUERY>

Or the SQL Server will not parse your query.

Where you would use PreserveSingleQuotes would be when you are building the entire query text yourself outside the CFQUERY tag, e.g.:

<CFSET myQuery = "INSERT INTO names (thename) VALUES ('O''Brien')">
<CFQUERY>
        #PreserveSingleQuotes(myQuery)#
</CFQUERY>

If you didn’t do that, then CF would still double all your quotes, creating a badly formatted string of SQL and possibly destroying the universe.

Make sense?


---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

You should be using cfqueryparam





"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 [phone].  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: bounce-cfaussie-21631@...
<bounce-cfaussie-21631@...>
To: CFAussie Mailing List <cfaussie@...>
Sent: Wed Nov 09 23:22:38 2005
Subject: [cfaussie] Re: Single Quote Preservation

David,

I did say that under CFMX the preserve single quotes according to the
documentation preserves single quotes!!

And I did also say that I have tried PreserveSingleQuotes I believe I did, I
think yes I did actually!!


Regards
Andrew Scott
Analyst Programmer

CMS Transport Systems
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: [phone]  -  Fax: [phone]

Quote:
"Space...is big. Really big. You just won't believe how vastly hugely
mindbogglingly big it is. I mean you may think it's a long way down the road
to the chemist, but that's just peanuts to space. "  Douglas Adams
----------------------------------------------------------------------------
--------------------------
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of David Harris
Sent: Thursday, 10 November 2005 10:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

Won't it get confused with the quote in God's?

Try
<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( 'Gods Kitchen 05' )
</cfquery>



---
You are currently subscribed to cfaussie as:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

Whether I have to or not it doesn't fix the problem.

Regards,
Andrew Scott
 
Quote of the Day:
The years teach much which the days never knew. - Ralph Waldo Emerson
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of
Robertson-Ravo, Neil (RX)
Sent: Thursday, 10 November 2005 6:40 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

You should be using cfqueryparam





---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

Let me test when I am in the office.




"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 [phone].  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: bounce-cfaussie-21631@...
<bounce-cfaussie-21631@...>
To: CFAussie Mailing List <cfaussie@...>
Sent: Thu Nov 10 08:04:27 2005
Subject: [cfaussie] Re: Single Quote Preservation

Whether I have to or not it doesn't fix the problem.

Regards,
Andrew Scott
 
Quote of the Day:
The years teach much which the days never knew. - Ralph Waldo Emerson
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of
Robertson-Ravo, Neil (RX)
Sent: Thursday, 10 November 2005 6:40 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

You should be using cfqueryparam





---
You are currently subscribed to cfaussie as:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Gavin Cooney]

it should do.

<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( <cfqueryparam cfsqltype="cf_sql_varchar"
value="God's Kitchen 05">)
</cfquery>

this should solve your problem.



On 10/11/05, Andrew Scott <andrews@...> wrote:

> Whether I have to or not it doesn't fix the problem.
>
> Regards,
> Andrew Scott
>
> Quote of the Day:
> The years teach much which the days never knew. - Ralph Waldo Emerson
> -----Original Message-----
> From: bounce-cfaussie-12196@...
> [mailto:bounce-cfaussie-12196@...] On Behalf Of
> Robertson-Ravo, Neil (RX)
> Sent: Thursday, 10 November 2005 6:40 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: Single Quote Preservation
>
> You should be using cfqueryparam
>
>
>
>
>
> ---
> You are currently subscribed to cfaussie as: gavin.cooney@...
> To unsubscribe send a blank email to leave-cfaussie-7918P@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

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).






"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 [phone].  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: bounce-cfaussie-21631@...
<bounce-cfaussie-21631@...>
To: CFAussie Mailing List <cfaussie@...>
Sent: Thu Nov 10 08:07:25 2005
Subject: [cfaussie] Re: Single Quote Preservation

it should do.

<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( <cfqueryparam cfsqltype="cf_sql_varchar"
value="God's Kitchen 05">)
</cfquery>

this should solve your problem.



On 10/11/05, Andrew Scott <andrews@...> wrote:

> Whether I have to or not it doesn't fix the problem.
>
> Regards,
> Andrew Scott
>
> Quote of the Day:
> The years teach much which the days never knew. - Ralph Waldo Emerson
> -----Original Message-----
> From: bounce-cfaussie-12196@...
> [mailto:bounce-cfaussie-12196@...] On Behalf Of
> Robertson-Ravo, Neil (RX)
> Sent: Thursday, 10 November 2005 6:40 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: Single Quote Preservation
>
> You should be using cfqueryparam
>
>
>
>
>
> ---
> You are currently subscribed to cfaussie as: gavin.cooney@...
> To unsubscribe send a blank email to

leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

In fact 3.5 are the latest versions.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=42dcb10a



-----Original Message-----
From: bounce-cfaussie-21631@...
[mailto:bounce-cfaussie-21631@...] On Behalf Of
Robertson-Ravo, Neil (RX)
Sent: 10 November 2005 08:52
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).






"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 [phone].  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: bounce-cfaussie-21631@...
<bounce-cfaussie-21631@...>
To: CFAussie Mailing List <cfaussie@...>
Sent: Thu Nov 10 08:07:25 2005
Subject: [cfaussie] Re: Single Quote Preservation

it should do.

<cfquery name="insert" database="Database">
 Insert into Tablename
 ( Fieldname ) values ( <cfqueryparam cfsqltype="cf_sql_varchar"
value="God's Kitchen 05">)
</cfquery>

this should solve your problem.



On 10/11/05, Andrew Scott <andrews@...> wrote:

> Whether I have to or not it doesn't fix the problem.
>
> Regards,
> Andrew Scott
>
> Quote of the Day:
> The years teach much which the days never knew. - Ralph Waldo Emerson
> -----Original Message-----
> From: bounce-cfaussie-12196@...
> [mailto:bounce-cfaussie-12196@...] On Behalf Of
> Robertson-Ravo, Neil (RX)
> Sent: Thursday, 10 November 2005 6:40 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: Single Quote Preservation
>
> You should be using cfqueryparam
>
>
>
>
>
> ---
> You are currently subscribed to cfaussie as: gavin.cooney@...
> To unsubscribe send a blank email to

leave-cfaussie-23165F@...
> Aussie Macromedia Developers: http://lists.daemon.com.au/
>

---
You are currently subscribed to cfaussie as:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

Which is WHY I posted that it was a problem with 3.4 Drivers!!


Regards,
Andrew Scott
 
Quote of the Day:
Abe: Welcome home, son. I broke two lamps and lost all your mail. What's
wrong with your wife?    Homer: Never mind, you wouldn't understand.    Abe:
Flu?    Homer: No.    Abe: Protein deficiency?    Homer: No.    Abe:
Pneumonoultramicroscopicsilicovolcanoconiosis?    Homer: No.    Abe:
Unsatisfying sex life?    Homer: N -- yes. But please, don't you say that
word!    Abe: What, seeex? What's so unappealing about hearing your elderly
father talk about sex? I had seeeeex.
-----Original Message-----
From: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] On Behalf Of
Robertson-Ravo, Neil (RX)
Sent: Thursday, 10 November 2005 8:43 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: Single Quote Preservation

In fact 3.5 are the latest versions.

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=42dcb10a





---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

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: bounce-cfaussie-21631@...
[mailto:bounce-cfaussie-21631@...] 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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Andrew Scott-2]

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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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: bounce-cfaussie-21631@...
[mailto:bounce-cfaussie-21631@...] 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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: andrews@... To
unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/






---
You are currently subscribed to cfaussie as: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/

[Robertson-Ravo, Neil (RX)]

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 [phone].  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: bounce-cfaussie-21631@...
<bounce-cfaussie-21631@...>
To: CFAussie Mailing List <cfaussie@...>
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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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: bounce-cfaussie-21631@...
[mailto:bounce-cfaussie-21631@...] 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: bounce-cfaussie-12196@...
[mailto:bounce-cfaussie-12196@...] 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:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: andrews@... To
unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/






---
You are currently subscribed to cfaussie as:
Neil.Robertson-Ravo@...
To unsubscribe send a blank email to
leave-cfaussie-23165F@...
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 [phone].  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: lists@...
To unsubscribe send a blank email to leave-cfaussie-23165F@...
Aussie Macromedia Developers: http://lists.daemon.com.au/