I just tried the reformatted code that I sent you and no errors kicked back.
I'm thinking it's something else on your page. The following is exactly what
I used.
<cfquery datasource="forums">
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>
Cheers,
Karl
> From: "Andrew Green" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 19 Mar 2002 14:52:31 -0800
> To: <[EMAIL PROTECTED]>
> Subject: RE: [CFTALKTor] Insert Statement
>
> Nope...added it in and still getting a syntax error
>
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> Behalf Of Karl Zarudny
> Sent: March 19, 2002 11:31 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [CFTALKTor] Insert Statement
>
> Yep, I think I see it. You're missing a single quote (') after
> '#form.name#
>
> It's usually the little things that drive ya insane :-)
>
>> From: "Andrew Green" <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> Date: Tue, 19 Mar 2002 14:27:51 -0800
>> 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: Karl Zarudny
> <[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)
>
> -
> You are subscribed to the CFUGToronto CFTALK ListSRV.
> This message has been posted by: "Andrew Green" <[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)
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: Karl Zarudny <[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)
