THanx, works :))
Gennadi
----- Original Message -----
From: "Jaime Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 11, 2000 10:21 AM
Subject: RE: string into <cfoutput>
> 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.
>
------------------------------------------------------------------------------
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.