CF Express ... Syntax error - CFQUERY -> UPDATE Options

Can anyone tell me exactly what is causing this error ? UPDATE GuestBook SET (GuestName = '#Form.GuestName#', Email = '#Form.Email#', FirstVisit = #Form.FirstVisit#, GotHere = '#Form.GotHere#', Rat

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

>Comments = '#trim(Form.Comments)#') Should be Comments = Comments = '#trim(Form.Comments)#' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.n

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

>>Comments = '#trim(Form.Comments)#') > >Should be Comments = Comments = '#trim(Form.Comments)#' Sorry that should be Comments = '#trim(Form.Comments)#)' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramati

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu wrote: > >Comments = '#trim(Form.Comments)#') > > Should be Comments = Comments = '#trim(Form.Comments)#' > > Remove the opening bracket as well UPDATE GuestBook SET GuestName = '#Form.GuestName#', Email = '#Form

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

Thanks, but that is supposed to be the right bracket of the SET - Original Message - From: "Jide Aliu" To: "cf-talk" Sent: Sunday, December 28, 2008 4:33 PM Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options > >Comments = '#tr

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

>> >Comments = '#trim(Form.Comments)#') >> >> Should be Comments = Comments = '#trim(Form.Comments)#' >> >> >Remove the opening bracket as well > > > UPDATE GuestBook > SET >GuestName = '#Form.GuestName#', > Email = '#Form.Email#', > FirstVisit = #F

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

Woo !Thanks for that. works ok now. - Original Message - From: "Casey Dougall" To: "cf-talk" Sent: Sunday, December 28, 2008 4:37 PM Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options > On Sun, Dec 28, 2008 at 11:33 AM, Jide A

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

Woo ! Thanks for thatworks ok now. - Original Message - From: "Jide Aliu" To: "cf-talk" Sent: Sunday, December 28, 2008 4:35 PM Subject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options >>>Comments = '#trim(Form.Comments)#'

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

>Thanks, but that is supposed to be the right bracket of the SET > > >> >Comments = '#trim(Form.Comments)#') >> >> Should be Comments = Comments = '#trim(Form.Comments)#' >> Yep, but syntactically (sqlwise) you can't have the construct (opening and closing bracket) the way it's laid out un

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

I just want to point out that you should be using cfqueryparam around all of those form elements. The way you have it will last about 2 hours before someone hacks into your database. see:

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CDSQLTYPE list - Original Message - From: "Al Musella, DPM" To: "cf-talk" Sent: Monday, December 29, 2008 5:40 PM Subject: Re: CF Express ... Syntax error - CFQUERY -> U

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CFSQLTYPE list - Original Message - From: "Al Musella, DPM" To: "cf-talk" Sent: Monday, December 29, 2008 5:40 PM Subject: Re: CF Express ... Syntax error - CFQUERY -> U

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

> How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? > > I cannot find it in the CFSQLTYPE list Use "BIT". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC

RE: CF Express ... Syntax error - CFQUERY -> UPDATE Options

ject: Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options How can CFQUERYPARAM be applied to a boolean (Yes/No) field ? I cannot find it in the CDSQLTYPE list - Original Message - From: "Al Musella, DPM" To: "cf-talk" Sent: Monday, December 29, 2008

Re: CF Express ... Syntax error - CFQUERY -> UPDATE Options

> After a bit (!) of research, I am still a little confused about using > CFQUERYPARAM. > It is not in my SAMs Teach Yourself Coldfusion Express in 24 Hrs. Probably not. I'm not sure CFQUERYPARAM exists in CF Express. CFQUERYPARAM was introduced around the same time that CF Express came out, but