ASP code to MS Access

D

Don

I would like for someone to look at the code we are using.
I am trying to insert more than four items at once if
possible 11 items total. This code below works until you
add one more entry. Is it possible to have more than 4 or
5 entries at once go from Html (the web)go into MS Access?

sql="INSERT INTO Realtors (ID,FirstName,"
sql=sql & "LastName,RealPhone,EmailAddress)"
sql=sql & " VALUES "
sql=sql & "('" & ID & "',"
sql=sql & "'" & fname & "',"
sql=sql & "'" & lname & "',"
sql=sql & "'" & phonenum & "',"
sql=sql & "'" & emailaddress & "')"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top