|
 |
access_asp thread: insert statement
Message #1 by "asif hameed" <asifqua@h...> on Mon, 22 Jul 2002 10:49:08 +0000
|
|
i want to insert a record in the table by using the insert query
but it is not working.
it gives error.
<%
option explicit
dim strid,strname, strpass, strsq, strans,con, rs,found,com , no
<!-- metadata type="typelib" file="c:\program Files\common
Files\System\ado\MSADO15.DLL" -->
strname = request.form ("uname")
strid = request.form ("id")
strpass = request.form ("pass")
strsq = request.form ("squ")
strans = request.form ("ans")
set com=server.createobject("adodb.command")
set con = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("adodb.recordset")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=d:/abc/user.mdb"
com.commandtext = "insert into
login(Userid,Name,Password,SecQuestion,Answer)
values(strid,strname,strpass,strsqa,strans)"
com.CommandType = adCmdText
com.ActiveConnection = con
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/anas/add.asp, line 22
my second question is that what is the purpose of msado15.dll. and where
would it place when using it.
Asif
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
Message #2 by "asif hameed" <asifqua@h...> on Mon, 22 Jul 2002 10:52:59 +0000
|
|
<html><div style='background-color:'><DIV>
<DIV>
<DIV>i want to insert a record in the table by using the insert query<BR>but it is not working.<BR>it gives
error.</DIV>
<DIV><% <BR>option explicit<BR>dim strid,strname, strpass, strsq, strans,con,
rs,found,com , no<BR><!-- metadata type="typelib" file="c:\program Files\common Files\System\ado\MSADO15.DLL"
--></DIV>
<DIV>strname = request.form ("uname")<BR>strid = request.form ("id")<BR>strpass = request.form
("pass")<BR>strsq = request.form ("squ")<BR>strans = request.form ("ans")</DIV>
<DIV>set com=server.createobject("adodb.command")<BR>set con = Server.CreateObject("ADODB.Connection")<BR>set
rs = Server.CreateObject("adodb.recordset")</DIV>
<DIV>con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=d:/abc/user.mdb"<BR>com.commandtext = "insert
into login(Userid,Name,Password,SecQuestion,Answer) values(strid,strname,strpass,strsqa,strans)"<BR>com.CommandType =
adCmdText<BR>com.ActiveConnection = con</DIV>
<DIV><BR>Error Type:<BR>Microsoft JET Database Engine (0x80040E14)<BR>Syntax error in INSERT INTO
statement.<BR>/anas/add.asp, line 22</DIV>
<DIV>my second question is that what is the purpose of msado15.dll. and where would it place when using it.</DIV>
<DIV>Asif<BR></DIV></DIV></DIV></div><br clear=all><hr>MSN Photos is the easiest way
to share and print your photos: <a href='http://g.msn.com/1HM1ENXX/c156??PI=31901'>Click Here</a><br></html>
Message #3 by "Ken Schaefer" <ken@a...> on Tue, 23 Jul 2002 12:33:18 +1000
|
|
www.adopenstatic.com/faq/80040e14.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "asif hameed" <asifqua@h...>
Subject: [access_asp] insert statement
: i want to insert a record in the table by using the insert query
: but it is not working.
: it gives error.
: <%
: option explicit
: dim strid,strname, strpass, strsq, strans,con, rs,found,com , no
: <!-- metadata type="typelib" file="c:\program Files\common
Files\System\ado\MSADO15.DLL" -->
: strname = request.form ("uname")
: strid = request.form ("id")
: strpass = request.form ("pass")
: strsq = request.form ("squ")
: strans = request.form ("ans")
: set com=server.createobject("adodb.command")
: set con = Server.CreateObject("ADODB.Connection")
: set rs = Server.CreateObject("adodb.recordset")
: con.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=d:/abc/user.mdb"
: com.commandtext = "insert into
login(Userid,Name,Password,SecQuestion,Answer)
values(strid,strname,strpass,strsqa,strans)"
: com.CommandType = adCmdText
: com.ActiveConnection = con
:
: Error Type:
: Microsoft JET Database Engine (0x80040E14)
: Syntax error in INSERT INTO statement.
: /anas/add.asp, line 22
: my second question is that what is the purpose of msado15.dll. and where
would it place when using it.
: Asif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
