Whats problem with this query?

[vkunirs]

Hi

i dynamically generating an insert query.

<cfquery name="s" datasource="dsnname">
#query#
</cfquery>

the query contains this query:
insert into
CONFIG_OS(l_os,l_servicepack,l_type_os,l_langue,l_ licence,l_proprietaire)
values ('windows','2.4.29','Microsoft Windows 2000
Professionnel','Fran?ais','FERZ9-FD4476-9Z46-5656-F','Linkbynet')

when i execute this i am getting this error:
Incorrect syntax near 'windows'.)

but if i execute in the SQL server it is executing successfully.
and even if execute this in cfm file then also it executing fine.
but if i given the variable which contains this query, then its giving that
error.

here the table name, fld names and fld values are generating dynamically.

what will be the problem.

[PaulH]

if you're going to handle your SQL that way , you'll need to use the preserveSingleQuotes function.