|
 |
access_asp thread: Syntax error in INSERT INTO
Message #1 by "Donald Harris" <gamezonline@g...> on Wed, 18 Dec 2002 23:50:40
|
|
i dont know what im doing wrong i get the message Syntax error in INSERT
INTO
<%@ LANGUAGE = JScript %>
<%
var dbfile=Server.MapPath("pkonline.mdb");
var dbconn;
var username=Request.Form("username");
var password=Request.Form("pass1");
var email=Request.Form("email");
var firstname=Request.Form("firstname");
dbconn.Execute("INSERT INTO userinfo (Username, Password, Email,
Firstname) VALUES
('"+username+"','"+password+"','"+email+"','"+firstname+"')");
%>
look over it so many time i just dont know what's wrong
Message #2 by "Donald Harris" <gamezonline@g...> on Thu, 19 Dec 2002 00:17:41
|
|
oh i for got this part of the code
dbconn=Server.CreateObject("ADODB.Connection");
dbconn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +dbfile);
> i dont know what im doing wrong i get the message Syntax error in
INSERT
I> NTO
> <%@ LANGUAGE = JScript %>
<> %
v> ar dbfile=Server.MapPath("pkonline.mdb");
v> ar dbconn;
v> ar username=Request.Form("username");
v> ar password=Request.Form("pass1");
v> ar email=Request.Form("email");
v> ar firstname=Request.Form("firstname");
> dbconn.Execute("INSERT INTO userinfo (Username, Password, Email,
F> irstname) VALUES
(> '"+username+"','"+password+"','"+email+"','"+firstname+"')");
%> >
> look over it so many time i just dont know what's wrong
Message #3 by "Ken Schaefer" <ken@a...> on Thu, 19 Dec 2002 11:24:14 +1100
|
|
www.adopenstatic.com/faq/80040e14.asp
Change "Password" to "UserPassword" or similar.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Donald Harris" <gamezonline@g...>
Subject: [access_asp] Re: Syntax error in INSERT INTO
: oh i for got this part of the code
:
: dbconn=Server.CreateObject("ADODB.Connection");
: dbconn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +dbfile);
:
: > i dont know what im doing wrong i get the message Syntax error in
: INSERT
: I> NTO
:
: > <%@ LANGUAGE = JScript %>
: <> %
: v> ar dbfile=Server.MapPath("pkonline.mdb");
: v> ar dbconn;
: v> ar username=Request.Form("username");
: v> ar password=Request.Form("pass1");
: v> ar email=Request.Form("email");
: v> ar firstname=Request.Form("firstname");
:
: > dbconn.Execute("INSERT INTO userinfo (Username, Password, Email,
: F> irstname) VALUES
: (> '"+username+"','"+password+"','"+email+"','"+firstname+"')");
: %> >
:
: > look over it so many time i just dont know what's wrong
Message #4 by "Donald Harris" <gamezonline@g...> on Thu, 19 Dec 2002 01:13:50
|
|
thx ken it worked :)
> www.adopenstatic.com/faq/80040e14.asp
Change "Password" to "UserPassword" or similar.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Donald Harris" <gamezonline@g...>
Subject: [access_asp] Re: Syntax error in INSERT INTO
: oh i for got this part of the code
:
: dbconn=Server.CreateObject("ADODB.Connection");
: dbconn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +dbfile);
:
: > i dont know what im doing wrong i get the message Syntax error in
: INSERT
: I> NTO
:
: > <%@ LANGUAGE = JScript %>
: <> %
: v> ar dbfile=Server.MapPath("pkonline.mdb");
: v> ar dbconn;
: v> ar username=Request.Form("username");
: v> ar password=Request.Form("pass1");
: v> ar email=Request.Form("email");
: v> ar firstname=Request.Form("firstname");
:
: > dbconn.Execute("INSERT INTO userinfo (Username, Password, Email,
: F> irstname) VALUES
: (> '"+username+"','"+password+"','"+email+"','"+firstname+"')");
: %> >
:
: > look over it so many time i just dont know what's wrong
|
|
|
View Cart
