please help me! i'm having sytax error!

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0;Data 
Source=C:\Inetpub\wwwroot\023291A-web\db7.mdb;Persist Security Info=False"
strDB = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="
conn.Open(Server.MapPath("db7.mdb"))

strInsertSQL = "INSERT INTO Customer (firstname, lastname, myemail, 
passwrd, confirmpasswrd, gender, number, dateofbirth) VALUES
('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"', '"&confirmpa
sswrd&"','"&gender&"', '"&number&"', '"&dateofbirth&"')"


conn.execute strInsertSQL
conn.close
%>    

theres a sytax error in the conn.execute strInsertSQL

please help!

In your first post you did not have quotation marks around the variable
number. Now you have quotation marks. If the datatype of the field
number is an integer, you have to leave out the quatation marks.
If the datatype of "dateofbirth" is a datetime, you have to surround it
with #.

Regards,

Gerhard Wentink

>-----Original Message-----
>From: blueatmosphere@y... [mailto:blueatmosphere@y...] 
>Sent: Monday, October 07, 2002 6:56 AM
>To: ASP Databases
>Subject: [asp_databases] sytax error....
>
>
>please help me! i'm having sytax error!
>
><%
>set conn=Server.CreateObject("ADODB.Connection")
>conn.Provider="Microsoft.Jet.OLEDB.4.0;Data 
>Source=C:\Inetpub\wwwroot\023291A-web\db7.mdb;Persist Security 
>Info=False"
>strDB = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="
>conn.Open(Server.MapPath("db7.mdb"))
>
>strInsertSQL = "INSERT INTO Customer (firstname, lastname, myemail, 
>passwrd, confirmpasswrd, gender, number, dateofbirth) VALUES
>('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"', 
>'"&confirmpa
>sswrd&"','"&gender&"', '"&number&"', '"&dateofbirth&"')"
>
>
>conn.execute strInsertSQL
>conn.close
>%>    
>
>theres a sytax error in the conn.execute strInsertSQL
>
>please help!
>

strInsertSQL = "INSERT INTO" & Customer &"(firstname, lastname, myemail, 
passwrd, confirmpasswrd, gender, number, dateofbirth) VALUES
('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"', '"&confirmpa
sswrd&"','"&gender&"', "&number&", #"&dateofbirth&"#)"

sorry. but there seems to be sytax error even though i have change the # 
and the numbers...

please help!!!!!!!!!!

and do i have to add the database file to the ODBC? wat is is used for? 


THANKS!!!!!!!!!!!!!!!!!!!

Now you changed the name of the tabel into a variable.
I think the right syntax is:
strInsertSQL = "INSERT INTO Customer (firstname, lastname,
myemail,passwrd, confirmpasswrd, gender, number, dateofbirth)
VALUES('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"',
'"&confirmpasswrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"

Assuming that number is a column with datatype integer and dateofbirth
is a datetime.

I saw in one of your former posts that the syntax for the connection is
also not right.
Try this:

Dim conn
Dim strConnection
strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\023291A-web\db7.mdb;Persist Security
Info=False"
set conn=Server.CreateObject("ADODB.Connection")
conn.Open strConnection

And no you don't have to  add the database to ODBC, since you are using
a connection string

Regards,

Gerhard Wentink

>-----Original Message-----
>From: blueatmosphere@y... [mailto:blueatmosphere@y...] 
>Sent: Monday, October 07, 2002 8:28 AM
>To: ASP Databases
>Subject: [asp_databases] RE: sytax error....
>
>
>strInsertSQL = "INSERT INTO" & Customer &"(firstname, 
>lastname, myemail, 
>passwrd, confirmpasswrd, gender, number, dateofbirth) VALUES
>('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"', 
>'"&confirmpa
>sswrd&"','"&gender&"', "&number&", #"&dateofbirth&"#)"
>
>sorry. but there seems to be sytax error even though i have 
>change the # 
>and the numbers...
>
>please help!!!!!!!!!!
>
>and do i have to add the database file to the ODBC? wat is is 
>used for? 
>
>
>THANKS!!!!!!!!!!!!!!!!!!!
>

<%
Dim conn
Dim strConnection
Dim strInsertSQL
strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=C:\db7.mdb;Persist Security Info=False"
set conn=Server.CreateObject("ADODB.Connection")
conn.Open strConnection


strInsertSQL = "INSERT INTO Customer (firstname, lastname, email, 
password, conpassword, gender, number, dateofbirth) VALUES
('"&firstname&"','"&lastname&"', '"&myemail&"', '"&passwrd&"','"&confirmpas
swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"

conn.execute (strInsertSQL)
conn.close
%>    


there is still the same sytax error!!! on the execute part...

the number is declare as long int and dateofbirth as date/time

pls help!

i have change according to wat u have given me~

Are you getting any errornumbers, messages?

Regards,

Gerhard Wentink 

>-----Original Message-----
>From: blueatmosphere@y... [mailto:blueatmosphere@y...] 
>Sent: Monday, October 07, 2002 9:45 AM
>To: ASP Databases
>Subject: [asp_databases] RE: sytax error....
>
>
><%
>Dim conn
>Dim strConnection
>Dim strInsertSQL
>strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data 
>Source=C:\db7.mdb;Persist Security Info=False"
>set conn=Server.CreateObject("ADODB.Connection")
>conn.Open strConnection
>
>
>strInsertSQL = "INSERT INTO Customer (firstname, lastname, email, 
>password, conpassword, gender, number, dateofbirth) VALUES
>('"&firstname&"','"&lastname&"', '"&myemail&"', 
>'"&passwrd&"','"&confirmpas
>swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"
>
>conn.execute (strInsertSQL)
>conn.close
>%>    
>
>
>there is still the same sytax error!!! on the execute part...
>
>the number is declare as long int and dateofbirth as date/time
>
>pls help!
>
>i have change according to wat u have given me~
>

blueatmosphere,
If you give the exact error being raised in the page,
we may help better. Also , i advise, let the code
write the output in buffer and then display it to the
screen by using 
response.write strInsertSQL 
response.end

Take the code to the access sql query view and execute
there. it seems you may have had a typo or a missed
code artifact.
Presumably "INSERT INTO" & Customer & "....
this part may be the reason of the error.

Berkay


--- blueatmosphere@y... wrote:
> strInsertSQL = "INSERT INTO" & Customer
> &"(firstname, lastname, myemail, 
> passwrd, confirmpasswrd, gender, number,
> dateofbirth) VALUES
> ('"&firstname&"','"&lastname&"', '"&myemail&"',
> '"&passwrd&"', '"&confirmpa
> sswrd&"','"&gender&"', "&number&",
> #"&dateofbirth&"#)"
> 
> sorry. but there seems to be sytax error even though
> i have change the # 
> and the numbers...
> 
> please help!!!!!!!!!!
> 
> and do i have to add the database file to the ODBC?
> wat is is used for? 
> 
> 
> THANKS!!!!!!!!!!!!!!!!!!!


__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

Use # instead of " around the dateofbirth and also check to mark sure
you do not have a space in the confirmpasswrd.  It showed as a space in
my email...I let it in below.  Last but not least, comment the execute
line and replace it will a response.write to see what strInsertSQL looks
like before execution.

strInsertSQL =3D "INSERT INTO Customer " &_
                        "(firstname, lastname, myemail, " &_
                        "passwrd, confirmpasswrd, gender, number,
dateofbirth)"  &_
                          "VALUES ('" & firstname & "','" & lastname &
"', '" & myemail & "', '" &_
                          passwrd & "', '" & confirmpa sswrd & "','" &
gender & "', '" &_
                          number & "', #" & dateofbirth & #)"

-----Original Message-----
From: blueatmosphere@y... [mailto:blueatmosphere@y...]
Sent: Monday, October 07, 2002 2:56 AM
To: ASP Databases
Subject: [asp_databases] sytax error....

please help me! i'm having sytax error!

<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.Provider=3D"Microsoft.Jet.OLEDB.4.0;Data
Source=3DC:\Inetpub\wwwroot\023291A-web\db7.mdb;Persist Security
Info=3DFalse" strDB =3D "DRIVER=3D{Microsoft Access Driver 
(*.mdb)};DBQ=3D"
conn.Open(Server.MapPath("db7.mdb"))

strInsertSQL =3D "INSERT INTO Customer (firstname, lastname, myemail,
passwrd, confirmpasswrd, gender, number, dateofbirth)" &_
                          "VALUES ('" & firstname & "','" & lastname &
"', '" & myemail & "', '" &_
                          passwrd & "', '" & confirmpa sswrd & "','" &
gender & "', '" & number & "', '" & dateofbirth & "')"


conn.execute strInsertSQL
conn.close
%>   

theres a sytax error in the conn.execute strInsertSQL

please help!

strInsertSQL = INSERT INTO Customer(firstname, lastname, myemail, passwrd,
confirmpasswrd, gender, number,dateofbirth)
VALUES('"&firstname&"','"&lastname&"', '"&myemail&"','"&passwrd&"',
'"&confirmpasswrd&"','"&gender&"', '"&number&"','"&dateofbirth&"')"

cheers,
Mohammed.
-----Original Message-----
From: Berkay Mese [mailto:berkaymese@y...]
Sent: Monday, October 07, 2002 11:31 PM
To: ASP Databases
Subject: [asp_databases] RE: sytax error....


blueatmosphere,
If you give the exact error being raised in the page,
we may help better. Also , i advise, let the code
write the output in buffer and then display it to the
screen by using 
response.write strInsertSQL 
response.end

Take the code to the access sql query view and execute
there. it seems you may have had a typo or a missed
code artifact.
Presumably "INSERT INTO" & Customer & "....
this part may be the reason of the error.

Berkay


--- blueatmosphere@y... wrote:
> strInsertSQL = "INSERT INTO" & Customer
> &"(firstname, lastname, myemail, 
> passwrd, confirmpasswrd, gender, number,
> dateofbirth) VALUES
> ('"&firstname&"','"&lastname&"', '"&myemail&"',
> '"&passwrd&"', '"&confirmpa
> sswrd&"','"&gender&"', "&number&",
> #"&dateofbirth&"#)"
> 
> sorry. but there seems to be sytax error even though
> i have change the # 
> and the numbers...
> 
> please help!!!!!!!!!!
> 
> and do i have to add the database file to the ODBC?
> wat is is used for? 
> 
> 
> THANKS!!!!!!!!!!!!!!!!!!!


__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

<%
Dim conn
Dim strConnection
Dim strInsertSQL
strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source=C:\Inetpub\wwwroot\023291A-web-\db7.mdb;Persist Security Info=False"
set conn=Server.CreateObject("ADODB.Connection")
conn.Open strConnection

strInsertSQL = "INSERT INTO Customer (firstname, lastname, email, 
password, conpassword, gender, number, dateofbirth) VALUES
('"&firstname&"','"&lastname&"', '"&mYemail&"', '"&passwrd&"','"&confirmpas
swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"

conn.execute (strInsertSQL)
conn.close
%>    

Microsoft JET Database Engine error '80040e14' 

Syntax error in INSERT INTO statement. 
error on the line conn.execute (strInsertSQL)

when i try to write:
......................................................................
strInsertSQL = " INSERT INTO Customer (firstname, lastname, email, 
password, conpassword, gender, number, dateofbirth) VALUES
('"&strName&"','"&strLName&"', '"&strEmail&"', '"&strPass&"','"&strConfirm&
"','"&strGender&"',"&strNum&", #"&strDate&strMonth&strYear&"#)"

response.write strInsertSQL 

conn.execute (strInsertSQL)
.......................................................................
it says:
......................................................................
INSERT INTO Customer (firstname, lastname, email, password, conpassword, 
gender, number, dateofbirth) VALUES
('Susan','Pipper', 'susan@y...', '123456','123456','female',61234567, 
#01July1985#) 
Microsoft JET Database Engine error '80040e14' 

Syntax error in INSERT INTO statement. 
....................................................................

so i think there is problem with the insert into statement but i dun know 
how...

There are a few possible causes for this error. Ken Schaefer's website
http://www.adopenstatic.com/faq/80040e14.asp mentions them. I suggest
that you have a look overthere especially scenario 3a.
Also do as Ron Drew suggests and see what the strInsertSQL looks like
before execution.

Regards,

Gerhard Wentink


>-----Original Message-----
>From: blueatmosphere@y... [mailto:blueatmosphere@y...] 
>Sent: Tuesday, October 08, 2002 4:24 AM
>To: ASP Databases
>Subject: [asp_databases] RE: sytax error....
>
>
><%
>Dim conn
>Dim strConnection
>Dim strInsertSQL
>strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data 
>Source=C:\Inetpub\wwwroot\023291A-web-\db7.mdb;Persist 
>Security Info=False"
>set conn=Server.CreateObject("ADODB.Connection")
>conn.Open strConnection
>
>strInsertSQL = "INSERT INTO Customer (firstname, lastname, email, 
>password, conpassword, gender, number, dateofbirth) VALUES
>('"&firstname&"','"&lastname&"', '"&mYemail&"', 
>'"&passwrd&"','"&confirmpas
>swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"
>
>conn.execute (strInsertSQL)
>conn.close
>%>    
>
>Microsoft JET Database Engine error '80040e14' 
>
>Syntax error in INSERT INTO statement. 
>error on the line conn.execute (strInsertSQL)
>
>

Sorry,
Received this post after I send my last answer.
You have to format the date of birth as:#07-01-1985#.
(Assuming that your version af Access is English)
Look in the Access helpfile for possible datetime formats.

Regards,

Gerhard Wentink


>-----Original Message-----
>From: blueatmosphere@y... [mailto:blueatmosphere@y...] 
>Sent: Tuesday, October 08, 2002 5:36 AM
>To: ASP Databases
>Subject: [asp_databases] RE: sytax error....
>
>
>when i try to write:
>......................................................................
>strInsertSQL = " INSERT INTO Customer (firstname, lastname, email, 
>password, conpassword, gender, number, dateofbirth) VALUES
>('"&strName&"','"&strLName&"', '"&strEmail&"', 
>'"&strPass&"','"&strConfirm&
>"','"&strGender&"',"&strNum&", #"&strDate&strMonth&strYear&"#)"
>
>response.write strInsertSQL 
>
>conn.execute (strInsertSQL)
>.......................................................................
>it says:
>......................................................................
>INSERT INTO Customer (firstname, lastname, email, password, 
>conpassword, 
>gender, number, dateofbirth) VALUES
>('Susan','Pipper', 'susan@y...', 
>'123456','123456','female',61234567, 
>#01July1985#) 
>Microsoft JET Database Engine error '80040e14' 
>
>Syntax error in INSERT INTO statement. 
>....................................................................
>
>so i think there is problem with the insert into statement but 
>i dun know 
>how...
>

Go here:
http://www.adopenstatic.com/faq/80040e14.asp
and look at Scenario 2a - Syntax Error in INSERT INTO statement

You should not call your fields "Number", or "Password", use something more
descriptive, eg CustomerNumber, or UserPassword or whatever.

Also, be aware of date problems when dealing with Access:
www.adopenstatic.com/faq/dateswithaccess.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <blueatmosphere@y...>
Subject: [asp_databases] RE: sytax error....


: when i try to write:
: ......................................................................
: strInsertSQL = " INSERT INTO Customer (firstname, lastname, email,
: password, conpassword, gender, number, dateofbirth) VALUES
: ('"&strName&"','"&strLName&"', '"&strEmail&"',
'"&strPass&"','"&strConfirm&
: "','"&strGender&"',"&strNum&", #"&strDate&strMonth&strYear&"#)"
:
: response.write strInsertSQL
:
: conn.execute (strInsertSQL)
: .......................................................................
: it says:
: ......................................................................
: INSERT INTO Customer (firstname, lastname, email, password, conpassword,
: gender, number, dateofbirth) VALUES
: ('Susan','Pipper', 'susan@y...', '123456','123456','female',61234567,
: #01July1985#)
: Microsoft JET Database Engine error '80040e14'
:
: Syntax error in INSERT INTO statement.
: ....................................................................
:
: so i think there is problem with the insert into statement but i dun know
: how...
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.

Hi
I di what you told me it did not work .I am new to ASP and this is my code.
<%
 Set oRS=Server.CreateObject("ADODB.recordset")
oRS.open "SELECT * FROM Customers","DSN=msproject"
Recordset.Move 0
Response.Write "<B>" & oRS("CustomerName") & "</B>"
%>
and the error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'

Operation was canceled.

/MyWeb/testsailor.asp, line 19
I really appreciate it.this is my master's project
thank you


 ----- Original Message -----
From: "Gerhard Wentink" <gerhard@d...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, October 07, 2002 11:27 PM
Subject: [asp_databases] RE: sytax error....


> There are a few possible causes for this error. Ken Schaefer's website
> http://www.adopenstatic.com/faq/80040e14.asp mentions them. I suggest
> that you have a look overthere especially scenario 3a.
> Also do as Ron Drew suggests and see what the strInsertSQL looks like
> before execution.
>
> Regards,
>
> Gerhard Wentink
>
>
> >-----Original Message-----
> >From: blueatmosphere@y... [mailto:blueatmosphere@y...]
> >Sent: Tuesday, October 08, 2002 4:24 AM
> >To: ASP Databases
> >Subject: [asp_databases] RE: sytax error....
> >
> >
> ><%
> >Dim conn
> >Dim strConnection
> >Dim strInsertSQL
> >strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
> >Source=C:\Inetpub\wwwroot\023291A-web-\db7.mdb;Persist
> >Security Info=False"
> >set conn=Server.CreateObject("ADODB.Connection")
> >conn.Open strConnection
> >
> >strInsertSQL = "INSERT INTO Customer (firstname, lastname, email,
> >password, conpassword, gender, number, dateofbirth) VALUES
> >('"&firstname&"','"&lastname&"', '"&mYemail&"',
> >'"&passwrd&"','"&confirmpas
> >swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"
> >
> >conn.execute (strInsertSQL)
> >conn.close
> >%>
> >
> >Microsoft JET Database Engine error '80040e14'
> >
> >Syntax error in INSERT INTO statement.
> >error on the line conn.execute (strInsertSQL)
> >
> >
>
>
>

On lines 1 and 2 you open a recordset called oRS.
On line 3 you are referencing an object called "Recordset"

Also, when you open an ADO recordset, you are always at the first record, so
you don't need to move to the first record (using .Movefirst). If you call
.Move 0 you are not doing anything at all, since you are not moving
anywhere. .Move expects a positive or negative integer which tells ADO to
move forwards or backwards in the recordset.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "bassam wassouf" <bassam@i...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, October 10, 2002 12:15 PM
Subject: [asp_databases] RE: sytax error....


: Hi
: I di what you told me it did not work .I am new to ASP and this is my
code.
: <%
:  Set oRS=Server.CreateObject("ADODB.recordset")
: oRS.open "SELECT * FROM Customers","DSN=msproject"
: Recordset.Move 0
: Response.Write "<B>" & oRS("CustomerName") & "</B>"
: %>
: and the error is :
: Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'
:
: Operation was canceled.
:
: /MyWeb/testsailor.asp, line 19
: I really appreciate it.this is my master's project
: thank you
:
:
:  ----- Original Message -----
: From: "Gerhard Wentink" <gerhard@d...>
: To: "ASP Databases" <asp_databases@p...>
: Sent: Monday, October 07, 2002 11:27 PM
: Subject: [asp_databases] RE: sytax error....
:
:
: > There are a few possible causes for this error. Ken Schaefer's website
: > http://www.adopenstatic.com/faq/80040e14.asp mentions them. I suggest
: > that you have a look overthere especially scenario 3a.
: > Also do as Ron Drew suggests and see what the strInsertSQL looks like
: > before execution.
: >
: > Regards,
: >
: > Gerhard Wentink
: >
: >
: > >-----Original Message-----
: > >From: blueatmosphere@y... [mailto:blueatmosphere@y...]
: > >Sent: Tuesday, October 08, 2002 4:24 AM
: > >To: ASP Databases
: > >Subject: [asp_databases] RE: sytax error....
: > >
: > >
: > ><%
: > >Dim conn
: > >Dim strConnection
: > >Dim strInsertSQL
: > >strConnection="Provider=Microsoft.Jet.OLEDB.4.0;Data
: > >Source=C:\Inetpub\wwwroot\023291A-web-\db7.mdb;Persist
: > >Security Info=False"
: > >set conn=Server.CreateObject("ADODB.Connection")
: > >conn.Open strConnection
: > >
: > >strInsertSQL = "INSERT INTO Customer (firstname, lastname, email,
: > >password, conpassword, gender, number, dateofbirth) VALUES
: > >('"&firstname&"','"&lastname&"', '"&mYemail&"',
: > >'"&passwrd&"','"&confirmpas
: > >swrd&"','"&gender&"',"&number&", #"&dateofbirth&"#)"
: > >
: > >conn.execute (strInsertSQL)
: > >conn.close
: > >%>
: > >
: > >Microsoft JET Database Engine error '80040e14'
: > >
: > >Syntax error in INSERT INTO statement.
: > >error on the line conn.execute (strInsertSQL)
: > >
: > >
: >
: >
: >
:
: