Error in row

**al_3asel** · 05-11-2004 02:22 AM

hi all,

I have an error when I was creating a web to add data to microsoft access database
the error is "Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver]Error in row
/Add.asp, line 54 "

detail of my database:
the name of the database is wardailer
the name of the table is table1
the primary key is ID

the code here :
_______________________________
<HTML><HEAD>

<%
Function ChkString(str)

str = replace(str, "<", "<", 1, -1, 1)
str = replace(str, ">", ">", 1, -1, 1)

ChkString = str
End Function

name = trim(ChkString(Request.form("name")))
email = trim(ChkString(Request.form("email")))
address = trim(ChkString(Request.form("address")))
City = trim(ChkString(Request.form("city")))
State = trim(ChkString(Request.form("state")))
Country = trim(ChkString(Request.form("country")))
Zipcode = trim(ChkString(Request.form("zip")))
Password = trim(ChkString(Request.form("password")))

ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("member.mdb")

set my_conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open ConnString
set rscheck = my_conn.Execute ("Select email from member where email='" & email & "'")

if rscheck.eof then
been_here_before="No"
end if

RScheck.close
set rs = server.CreateObject("adodb.recordset")
if been_here_before="No" then
sql ="select * from member"

RS.open Sql,my_conn,1,3
RS.AddNew
RS("Name")=name
RS("email")=email
RS("address")=address
RS("city")=city
RS("state")=state
RS("country")=country
RS("zipcode")=zipcode
RS("password")= password
RS("memberdate")= now()

RS.update ' the error is here in this line
%>
</HEAD>
<body bgcolor="#99ccff">

<center>Your Account Has Been Processed!! 
Your User ID is : <%=email%>  , and your password is : <%=password%>

<a href="login2.asp">Go to Login Page </a>

</center>

<%
else
%>
<center>Your have signup already with this email 
Please signup with another your email address.

<a href="signup.asp">Sign up Again! </a></center>

<%
end if

rs.close
my_conn.Close
set my_conn = nothing
set rs = nothing
%></BODY></HTML>
_________________________________
help me plz
thanks alot

**buntine** · 05-11-2004 03:40 AM

Try using SQL to insert data into the table. Employ the INSERT INTO statement.

Regards.

**al_3asel** · 05-11-2004 04:12 AM

how to implement sql statements here ???

**buntine** · 05-11-2004 05:40 AM

Here you go.

Code:

sql = "INSERT INTO member (Name, email, address, city, state, country, zipcode, password, memberdate)" & _
      " VALUES (" & _
      "'" & name & "', " & _
      "'" & email & "', " & _
      "'" & address & "', " & _
      "'" & city & "', " & _
      "'" & state & "', " & _
      "'" & country & "', " & _
      "'" & zipcode & "', " & _
      "'" & password & "', " & _
      "#" & now() & "#"

Regards,
Andrew Buntine.

**al_3asel** · 05-11-2004 05:51 AM

hi my friend buntine

the problem was fixed

without using sql statement really the problem I found it in database itself

thanks buntine

**buntine** · 05-11-2004 05:52 AM

Ok, good stuff

**ethen55** · 10-31-2012 01:31 AM

hi al_3asel,

I have the same problem you have mentioned here.

would you tell me how you fixed that?

thx alot

**gk53** · 11-01-2012 07:28 AM

Just make sure all values you assigned is valid (check for missing value in not null fields, numeric fields must have numeric values - empty is not a numeric, length of value must be less them field size for character values)

Thread: Error in row

Thread Tools

Display

Error in row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions