What specifically is CF reporting? Which line is it saying the error is
occurring on? Is there any other code on the page other than the insert?
Also, why are you naming your insert query?... Are you performing more than
one query within your cfquery? I cleaned up the formatting to make it a
little easier to read, but I'm stumped too. Let me know the solution when
you find it. - Karl
<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>
> 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)
