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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you insert data when using a select box with multiple items sel

Status
Not open for further replies.

bongmarley

Programmer
Oct 21, 2002
74
CA
I want to know the sql syntax to insert data from a select box with multiple data
 
Place the multiple values into an array like so

dropdownbox = Split(dropdownname, ",")

then create your sql statement with something like this

for i = LBound(dropdownbox ) to UBound(dropdownbox )
sql=sql & dropdownbox(i)
next Saturday 12.00
im6.gif
im2.gif
im2.gif
20.00
im5.gif
im4.gif
im7.gif
3.00am
im8.gif
Sunday [img http
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top