asp and database access(sqlserver) dropdown box

[sunikrish]

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?

[jhardman]

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

[Ashfaque Sayani]

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&"')