Its working now!
-----Original Message-----
From: Nando [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 14, 2004 12:30 PM
To: CF-Talk
Subject: RE: MySQL Update help
Are you missing some quotes there? non numeric values need to be in
quotes.
UPDATE products
SET prodPicture = 'ABCs-of-Sus-&-Hap-reduced50.jpg' ,
prodTypeFK = 1
WHERE products.prodPK = 53;
-----Original Message-----
From: David Berry [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 14, 2004 6:16 PM
To: CF-Talk
Subject: MySQL Update help
Hello,
I am looking for some assistance with this syntax error that I am
getting.
Code:
UPDATE products
SET prodPicture = <cfif IsDefined("form.picture") AND #form.picture#
NEQ "">
#form.picture#
<cfelse>
#cffile.serverFile#
</cfif>,
prodTypeFK = #session.prodTypeFK# WHERE products.prodPK =
#SESSION.prodPK#;
CF Error:
Syntax error or access violation: You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '&-Hap-reduced50.jpg , prodTypeFK = 1 WHERE
products.pr
SQL UPDATE products SET prodPicture =
ABCs-of-Sus-&-Hap-reduced50.jpg , prodTypeFK = 1 WHERE products.prodPK =
53;
Everything looks right to me? Could this be a table schema setting that
is wrong?
Thanks in advance for your help!
~dB
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
