471,852 Members | 860 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

asp and database access(sqlserver) dropdown box

Hi Everyone,
I just started coding in asp and I have a dropdown box. If the user selects a quantity from this dropdown box, this needs to be saved in the database. How can I do that?
Mar 2 '07 #1
2 1217
jhardman
3,406 Expert 2GB
Hi Everyone,
I just started coding in asp and I have a dropdown box. If the user selects a quantity from this dropdown box, this needs to be saved in the database. How can I do that?
So what have you tried so far? What kind of errors do you get?

Jared
Mar 5 '07 #2
Hi Everyone,
I just started coding in asp and I have a dropdown box. If the user selects a quantity from this dropdown box, this needs to be saved in the database. How can I do that?
on change of the dropdownbox/or on submit of the form you can call a function which will fire an insert query and the value will be saved in the database.

You need to store the value in the variable

for eg - country = request.form("country")

then sql = "insert into xyz (col name ) values ('"&counrty&"')
Mar 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.