You could try
<cfquery name="PutTable" datasource="#DB2_DSN#">
#PreserveSingleQuotes(InsertSQL)#
</cfquery>
<Jaime/>
> -----Original Message-----
> From: Gena [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 5:21 PM
> To: CF-Talk
> Subject: string into <cfoutput>
>
>
> I try to generate sql string like:
>
> INSERT INTO TABLE2 (text) VALUES ('111')
>
> and put it in variable like:
>
> <cfset InsertSQL="INSERT INTO TABLE2 (text) VALUES ('111')">
>
> <cfquery name="PutTable" datasource="#DB2_DSN#">
> #InsertSQL#
> </cfquery>
>
> and I've got error message
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
> syntax near
> '111'.
>
> Where is a problem?
>
> Gennadi
>
>
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
