Problem with Dynamic Update Query

[safrican1]

I am having a problem with a dynamic query I create a string which will be
inserted into the Query tag

<cfQuery>
Update Table
Set #MyVar#
</cfQuery>

the value of myvar is
field1 = 'some text'

but when the system errors it shows the value of myvar to be
field1 = "some text"

I am trying to update a SQL Server 7 database which seems to only accept
string in ' (single Quotes).

If you have an idea please lte me know

[Dan Bracuk]

One, if you want this to work at all, you will have to use the
preservesinglequotes function in your query.

Two, if you dump myvar right before your query, how many quotes are there?

Originally posted by: safrican1
I am having a problem with a dynamic query I create a string which will be
inserted into the Query tag

<cfQuery>
Update Table
Set #MyVar#
</cfQuery>

the value of myvar is
field1 = 'some text'

but when the system errors it shows the value of myvar to be
field1 = "some text"

I am trying to update a SQL Server 7 database which seems to only accept
string in ' (single Quotes).

If you have an idea please lte me know

[safrican1]

many thanks, preservesinglequotes did work.

There are a number of fields, I have a dynamic custom tag that will update all
fields from a form. So each field is wrapped in a set of quotes and some of
them may have quotes in them, eg <textarea> fields.