|
| |
|
|
watle
Posts: 6
Joined: 6/29/2009
Status: offline
 |
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 %>
|
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: My ASP doesnt work. help!!!! - 6/29/2009 23:13:57
Have you read this thread?
http://www.frontpagewebmaster.com/m-84102/tm.htm
It may provide a clue. Perhaps a number that is too large.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
watle
Posts: 6
Joined: 6/29/2009
Status: offline
|
RE: My ASP doesnt work. help!!!! - 6/30/2009 8:53:13
Yooooooo.
I change the gender from number to text and it work.
Thank you so much...
Be bless
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 