Re: anyone see what is causing a Syntax Error is this update statement??

2001-05-06 Thread Stephen Hait
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?? > > >

Re: anyone see what is causing a Syntax Error is this update statement??

2001-05-06 Thread Tim Painter
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 wha

Re: anyone see what is causing a Syntax Error is this update statement??

2001-05-05 Thread Howie Hamlin
al 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 statement?? > Hello cf-talk, > > This simple update is generating

RE: anyone see what is causing a Syntax Error is this update statement??

2001-05-05 Thread Jason
Fongemie [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 05, 2001 3:58 PM To: CF-Talk Subject: anyone see what is causing a Syntax Error is this update statement?? Hello cf-talk, This simple update is generating a syntax error i can't seem to resolve. What am I missing?? UPDATE #form.table# SET

anyone see what is causing a Syntax Error is this update statement??

2001-05-05 Thread Jeff Fongemie
Hello cf-talk, This simple update is generating a syntax error i can't seem to resolve. What am I missing?? UPDATE #form.table# SET name='#name#', desc='#desc#', price='#price#' WHERE id=#form.id# Best regards, Jeff Fongemie mailto:[EMAIL