|
 |
access_asp thread: problem while inserting data into MS Acces
Message #1 by "tulasi" <lakshmi.jonnadula@w...> on Fri, 29 Mar 2002 09:31:07
|
|
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 Abdul Sami <abdul_sami_20@y...> on Sat, 30 Mar 2002 05:25:07 -0800 (PST)
|
|
check out with this coding
---
<% folder=Request.form("T1")
if rs("foldername")= "" then %> - 'no space b/w inverted
commas
%> no data entered
<% else
while not rs.EOF 'while loop shuold start here
if rs("foldername")=folder then %>
folder already exists..try another name
<% ' response.redirect("test.asp") -no response.redirect until u
get any proper message
else
conn.execute("insert into folder values('" & folder & "')")
'response.redirect("test.asp")
response.write "value is inserted "> %><br><center>
<a onclick="history.back()"> Back </a></center>
<% end if
end if
wend
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
------
--- tulasi <lakshmi.jonnadula@w...> wrote:
> 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.
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
|
|
|
View Cart
