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: 03 9699 7988 - Fax: 03 9699 7976
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: 03 9699 7988 - Fax: 03 9699 7976
>
>
> 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:
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/