THE MOST SIMPLE INSERT statement ever, NOT WORKIN!

ive never seen this, ive been using coldfusion long time, dont know if im missing simple, thought maybe insight on here. tried using dreamweaver insert form insert statement , still bombing out.... check out...

so inserting new row database, simple sql insert statement. have pretty decent sized form, when wasnt working, cut down 2 fields make simpler. , still not working. if cut down 1 field, works. anyway, error im getting...

-----
error executing database query.
syntax error in insert statement.

the error occurred in c:\inetpub\wwwroot\seprevived\testform2.cfm: line 2

1 : <cfquery datasource="sepr">
2 : insert users (uemail, password) values ('#form.uemail#', '#form.password#')
3 : </cfquery>
4 :



--------------------------------------------------------------------------------

sql insert users (uemail, password) values ('sadasdf@daadf.com', 'adffd')
datasource sepr
vendorerrorcode 3092
sqlstate  


--------------

as can see, pulling correct information form form there syntax error? help? doing wrong?



---------------------->>>>>>

heres code dreamweaver spit out me attempted use see if work....... didnt work either... @ appreciated ive never seen garbage this...
thanks!

try this:

<cfquery datasource="sepr">
insert users
(uemail, [password])
values ('#form.uemail#', '#form.password#')
</cfquery>

password reserved word in many databases.


--
ken ford
adobe community expert


"johnegbert" <webforumsuser@macromedia.com> wrote in message
news:e9bfah$gml$1@forums.macromedia.com...
> ive never seen this, ive been using coldfusion long
> time,
> dont know if im missing simple, thought maybe
> insight on here. tried using dreamweaver insert form
> insert statement , still bombing out.... check out...
>
> inserting new row database, simple sql insert
> statement.
> have pretty decent sized form, when wasnt working, cut down
>
> 2 fields make simpler. , still not working. if cut down
> 1
> field, works. anyway, error im getting...
>
> -----
> error executing database query.
> syntax error in insert statement.
>
> error occurred in c:\inetpub\wwwroot\seprevived\testform2.cfm: line 2
>
> 1 : <cfquery datasource="sepr">
> 2 : insert users (uemail, password) values ('#form.uemail#',
> '#form.password#')
> 3 : </cfquery>
> 4 :
>
>
>
>
> --------------------------------------------------------------------------------
>
> sql insert users (uemail, password) values ('sadasdf@daadf.com',
> 'adffd')
> datasource sepr
> vendorerrorcode 3092
> sqlstate  
>
>
> --------------
>
> can see, pulling correct information form form
> there
> syntax error? help? doing wrong?
>
>
>
> ---------------------->>>>>>
>
> heres code dreamweaver spit out me attempted use
>
> see if work....... didnt work either... @
>
> appreciated ive never seen garbage this...
> thanks!
>
>
> <cfif isdefined("form.mm_insertrecord") , form.mm_insertrecord eq
> "form2">
> <cfquery datasource="sepr">
> insert users (uemail, fname, lname, currentloc, about, password,
> favsepmemory, sepexperience, zip) values (
> <cfif isdefined("form.email") , #form.email# neq "">
> '#form.email#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.fname") , #form.fname# neq "">
> '#form.fname#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.lname") , #form.lname# neq "">
> '#form.lname#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.currentloc") , #form.currentloc# neq "">
> '#form.currentloc#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.about") , #form.about# neq "">
> '#form.about#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.password") , #form.password# neq "">
> '#form.password#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.favsepmemory") , #form.favsepmemory# neq "">
> '#form.favsepmemory#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.sepexperience") , #form.sepexperience# neq "">
> '#form.sepexperience#'
> <cfelse>
> null
> </cfif>
> ,
> <cfif isdefined("form.zip") , #form.zip# neq "">
> #form.zip#
> <cfelse>
> </cfif>
> )
> </cfquery>
> <cflocation url="signup.cfm?action=done">
> <!--- write email script here --->
> </cfif>
>

More discussions in ColdFusion

adobe