Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieving multiple fields from a form, inserting into 2 Table fields

Status
Not open for further replies.

juice

Programmer
Aug 25, 2000
4
CA
I have an online form which allows a user to register his friends for a service. He can register up to 5 friends. This info is sent to the Database using OLE DB and ODBC. I am using the AddNew Method in VB Script. I retrievethe form info using request.form and store the value in a variable. Then I use a series of of If statements. In each of these I call AddNew and pass the string values to the recordset object and finally I call the update method. I know the connection works Because the error that I get says that I cannot pass empty strings to the database. Something is going wrong when I pass the strings to the Recordset objects (I think). I've passed strings to recordset objects before and have never had this problem can anyone help me trouble shoot what I am doing wrong? Any suggestions? Any help would be good thanx.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top