|
 |
asptoday_discuss thread: problem while inserting data into MS acess using asp
Message #1 by "tulasi" <lakshmi.jonnadula@w...> on Fri, 29 Mar 2002 08:56:06
|
|
hai,
i m a beginnar in asp.i was trying to insert a value into data base
by using request.form.i m checking 2 cases
1.if null form is submit, i want to display error message(in the same form)
2.if the data i m trying to insert into database is already exiting
i want to display error message (in the same page)
if neither of these not true i want to exectute insert statment.
i m getting the fellowing error message:
_______________________________________________
Error Type:
Microsoft JET Database Engine (0x80004005)
Field 'folder.foldername' cannot be a zero-length string
code:
________________
<%
dim conn
dim rs
dim sql
sql="select * from folder"
set conn=server.createObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.open "d:\tulasi\tulasi.mdb"
set rs=server.createObject("ADODB.recordset")
rs.open sql,conn
%>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<form method="POST" action="test.asp" name="form1">
<p>Enter folder name:<input type="text" name="T1" size="20"></p>
<p>
&nb
sp;
<input type="submit" value="Submit" name="B1"></p>
</form>
<%
folder=Request.form("T1")
while not rs.EOF
if rs("foldername")= " " then %>
no data entered
<%else
if rs("foldername")=folder then %>
folder already exits..try another name
<% response.redirect("test.asp")
else
conn.execute("insert into folder values('"&folder&"')")
response.redirect("test.asp")
end if
end if
rs.MoveNext
wend
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</body>
</html>
plz help me in solving this problem.
Thanks
Tulasi.
Message #2 by "marcpointer@m... on Fri, 29 Mar 2002 07:59:06 -0500
|
|
Check the field data properties inside the table...
Original Message:
-----------------
From: tulasi lakshmi.jonnadula@w...
Date: Fri, 29 Mar 2002 08:56:06
To: asptoday_discuss@p...
Subject: [asptoday_discuss] problem while inserting data into MS acess using asp
hai,
i m a beginnar in asp.i was trying to insert a value into data base
by using request.form.i m checking 2 cases
1.if null form is submit, i want to display error message(in the same form)
2.if the data i m trying to insert into database is already exiting
i want to display error message (in the same page)
if neither of these not true i want to exectute insert statment.
i m getting the fellowing error message:
_______________________________________________
Error Type:
Microsoft JET Database Engine (0x80004005)
Field 'folder.foldername' cannot be a zero-length string
code:
________________
<%
dim conn
dim rs
dim sql
sql=3D"select * from folder"
set conn=3Dserver.createObject("ADODB.Connection")
conn.Provider=3D"Microsoft.Jet.OLEDB.4.0"
conn.open "d:\tulasi\tulasi.mdb"
set rs=3Dserver.createObject("ADODB.recordset")
rs.open sql,conn
%>
<html>
<head>
<meta name=3D"GENERATOR" content=3D"Microsoft FrontPage 4.0">
<meta name=3D"ProgId" content=3D"FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
<form method=3D"POST" action=3D"test.asp" name=3D"form1">
<p>Enter folder name:<input type=3D"text" name=3D"T1" size=3D"20"></p>
<p>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0&nb
sp;
<input type=3D"submit" value=3D"Submit" name=3D"B1"></p>
</form>
<%
folder=3DRequest.form("T1")
while not rs.EOF
if rs("foldername")=3D " " then %>
no data entered
<%else
if rs("foldername")=3Dfolder then %>
folder already exits..try another name
<% response.redirect("test.asp")
else
conn.execute("insert into folder values('"&folder&"')")
response.redirect("test.asp")
end if
end if
rs.MoveNext
wend
rs.close
set rs=3Dnothing
conn.close
set conn=3Dnothing
%>
</body>
</html>
plz help me in solving this problem.
Thanks
Tulasi.
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
Message #3 by Lawrence Yap <assoc_con@y...> on Fri, 29 Mar 2002 13:33:13 -0800 (PST)
|
|
Check your properties for the table called Folder.
Also, in MS SQL Server, File and Folder are reserved
words. You can't use this as table names. That can
also be a problem. Check your properties first
though.
Lawrence
--- tulasi <lakshmi.jonnadula@w...> wrote:
> hai,
> i m a beginnar in asp.i was trying to insert a
> value into data base
> by using request.form.i m checking 2 cases
> 1.if null form is submit, i want to display error
> message(in the same form)
> 2.if the data i m trying to insert into database is
> already exiting
> i want to display error message (in the same page)
> if neither of these not true i want to exectute
> insert statment.
>
> i m getting the fellowing error message:
> _______________________________________________
> Error Type:
>
> Microsoft JET Database Engine (0x80004005)
>
> Field 'folder.foldername' cannot be a zero-length
> string
>
> code:
> ________________
>
> <%
> dim conn
> dim rs
> dim sql
> sql="select * from folder"
> set conn=server.createObject("ADODB.Connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.open "d:\tulasi\tulasi.mdb"
> set rs=server.createObject("ADODB.recordset")
> rs.open sql,conn
>
> %>
>
> <html>
>
> <head>
> <meta name="GENERATOR" content="Microsoft FrontPage
> 4.0">
> <meta name="ProgId"
> content="FrontPage.Editor.Document">
> <title>New Page 1</title>
> </head>
>
> <body>
>
> <form method="POST" action="test.asp" name="form1">
> <p>Enter folder name:<input type="text" name="T1"
> size="20"></p>
>
>
<p>
>
&nb
> sp;
> <input type="submit" value="Submit" name="B1"></p>
> </form>
>
>
> <%
> folder=Request.form("T1")
> while not rs.EOF
> if rs("foldername")= " " then %>
> no data entered
>
> <%else
> if rs("foldername")=folder then %>
> folder already exits..try another name
> <% response.redirect("test.asp")
> else
> conn.execute("insert into folder
> values('"&folder&"')")
> response.redirect("test.asp")
> end if
> end if
> rs.MoveNext
> wend
> rs.close
> set rs=nothing
> conn.close
> set conn=nothing
> %>
>
> </body>
>
> </html>
> plz help me in solving this problem.
>
> Thanks
> Tulasi.
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
|
|
|
View Cart
