469,331 Members | 1,885 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

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 1183
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 this site, you agree to our Privacy Policy and Terms of Use.