quotes on the first field:
you have :
> values('#form.name#,'
it should be
> values('#form.name#',
quote's in the wrong place.
crc
----- Original Message -----
From: Andrew Green <[EMAIL PROTECTED]>
Sent: Tuesday, March 19, 2002 5:27:51 PM
To: <[EMAIL PROTECTED]>
Subject: [CFTALKTor] Insert Statement
> Can anyone see what I'm doing wrong here?
>
> <cfquery datasource="forums" name="addmember">
> insert into
> members(Name,Email,Handle,login,password,allow,level,memberid)
> values('#form.name#,'#form.email#','#form.handle#','#form.login#','#form
> .password#',#allow#,'#level#',#nextid#)
> </cfquery>
>
> All but ALLOW and NEXTID are text. ALLOW and NEXTID are numbers. ( 1 and
> 2 respectively )
> Cold fusion is saying there is a syntax error
>
> <http://www.buildingwealth.ca/>
>
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
