|
watle -> My ASP doesnt work. help!!!! (6/29/2009 22:28:17)
|
I was trying to connect my asp with a database.
is there a limit to how many characters a post method or access 2000 database can handle? i know that i am not going over 255 characters in any field.
the script works when i enter smaller amounts of data but when i try to type more stuff i get that same error.
Provider error '8002000a'
Out of present range.
asp.asp, line 142
need help . thanks
My Code:
<!-- #include file = "sample_db.inc" -->
<!-- #included file = "adovbs.inc" -->
<% //SAVING DATA %>
<% dim praye
dim worship_tog
dim downloa
dim donatio
dim othe
if request.form("praye")="prayer" then
praye=True
else
praye=False
end if
if request.form("worship_tog")="Worship with us" then
worship_tog=True
else
worship_tog=False
end if
if request.form("downloa")="download" then
downloa=True
else
downloa=False
end if
if request.form("donatio")="donation" then
donatio=True
else
donatio=False
end if
if request.form("othe")="other" then
othe=True
else
othe=False
end if
set database = server.createObject("adodb.recordset")
database.open "registration", strDSN, adOpenStatic, adLockOptimistic, adCmdTable
fields=Array("Firstname","Lastname","City","Street","PLZ","State","Homephone","Cellphone","Age","Gender","Interested_Prayer", "Interested_Worship","Interested_Download","Interested_Donation", "Interested_Request","Additional", "Appreciation", "Email")
values=Array(request.form("vorname"),request.form("nachname"),request.form("city"), request.form("street"), request.form("plz"), request.form("state"), request.form("homephone"), request.form("cellphone"), request.form("birthdate"), request.form("gender"), praye, worship_tog, downloa, donatio, othe, request.form("questions"), request.form ("appreciation"), request.form("emailadresse1"))
database.addnew fields, values
database.update
response.write "Your application have been successfully submited"
database.close
set database = nothing %>
|
|
|
|
