Question about Updating a record

[Jeremy F]

Ok, here's what we can assume:
<cfset update = "ALIAS = 'Gruu'">
<cfset id = '999'>

Here's the simplified query:
<cfquery name="angryquery" datasource="ds">
UPDATE TableName
SET #update#
WHERE (key = '#id#')
</cfquery>

And here's what CF has to say about that:
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near
'Gruu'.


Any ideas? The field 'alias' is capable of holding 'Gruu' as its value, and
the field 'key' is a unique identifier. Any input is appreciated.

[The ScareCrow]

I would say the problem is that the id is an integer and you have it inclosed
in single quotes, should be

<cfquery name="angryquery" datasource="ds">
UPDATE TableName
SET #update#
WHERE (key = #id#)
</cfquery>

Ken

[Jeremy F]

Fair enough answer, but not the problem. The query executes just fine if I do

UPDATE TableName
SET ALIAS = 'Gruu'
WHERE (key = '#id#')

But fails if I do:

UPDATE TableName
SET #update#
WHERE (key = 999)

Strange, eh?

[The ScareCrow]

Does it fail if you do

UPDATE TableName
SET #update#
WHERE (key = '999')

Give this a try

<cfset update = "[ALIAS] = 'Gruu'">

Ken

[Jeremy F]

I've found the solution. Thanks again for your help.

PreserveSingleQuotes()

Who knew...