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

2008-12-30 Thread Dave Watts
> 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

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

2008-12-29 Thread Mark Kruger
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

2008-12-29 Thread Dave Watts
> 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

2008-12-29 Thread BobSharp
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

2008-12-29 Thread BobSharp
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

2008-12-29 Thread Al Musella, DPM
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

2008-12-28 Thread Jide Aliu
>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

2008-12-28 Thread BobSharp
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

2008-12-28 Thread BobSharp
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

2008-12-28 Thread Jide Aliu
>> >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

2008-12-28 Thread BobSharp
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

2008-12-28 Thread Casey Dougall
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

2008-12-28 Thread Jide Aliu
>>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

2008-12-28 Thread Jide Aliu
>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