Is price a number datatype? If so try removing the single quotes from
'#price#'
Tim P.
- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 05, 2001 6:57 PM
Subject: anyone see what is causing a Syntax Error is this update
This might be because desc is a reserved word in MS SQL.
Check the docs for the platform you're on and see if this might be
the problem.
Regards,
Stephen
HTH,
Stephen
Hello cf-talk,
This simple update is generating a syntax error i can't seem to
resolve. What am I missing??
Hello cf-talk,
This simple update is generating a syntax error i can't seem to
resolve. What am I missing??
cfquery DATASOURCE=#Application.dsn#
UPDATE #form.table#
SET name='#name#',
desc='#desc#',
price='#price#'
WHERE id=#form.id#
/cfquery
Best regards,
Jeff
WHat is the syntax error? I would guess that one of your fields is not a
TEXT field - maybe Price ? If any of those fields are numeric it will get
messed up - or if your Price field is a money type and you are putting in a
entry with a $ dollar sign?
-Original Message-
From: Jeff
desc is reserved word. Either change the name of the field or put square braces
around it.
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
- Original Message -
5 matches
Mail list logo