Write contents of Dropdown list to a database

[BubbaGump]

i am dynmically creating a dropdown list and i am wondering how to
write the contents of the dropdown list to a database.

Purpose: i am creating program which allows you to create a
questionaire. And i have a page which allows the person creating the
questionaire to enter a question and all the possible answers to the
question (the answers are added to the dropdown list). I want to be
able to write this dropdown list to a single field in the database.
Remember i am dynmanically creating the dropdown list so it will vary
in size depending on the question.

i have been stuck on this for ages.
any help greatly appreciated

Cheers

[Jeff Cochran]

On 25 Feb 2004 03:04:52 -0800, [email]octopusses_garden@hotmail.com[/email]
(BubbaGump) wrote:

>i am dynmically creating a dropdown list and i am wondering how to
>write the contents of the dropdown list to a database.
>
>Purpose: i am creating program which allows you to create a
>questionaire. And i have a page which allows the person creating the
>questionaire to enter a question and all the possible answers to the
>question (the answers are added to the dropdown list). I want to be
>able to write this dropdown list to a single field in the database.
>Remember i am dynmanically creating the dropdown list so it will vary
>in size depending on the question.

This appears rather simple unless I'm missing something (especially
since a few days ago I was facing writing a similar app). You're
creating the dropdown, so you can obviously get the input of the
dropdown items. As you get them, append them to a string, separated
by a delimiter such as a comma (probably too common) or a pound sign
or any other character. Write that string to the database field (Text
or Memo) and when you read it back put, parse for the delimiter and
split it as needed.

Jeff

[Bullschmidt]

Perhaps also use JavaScript to update a hidden field at the same time
you're updating the listbox. And if you have a character like | that
separates each item you can then later Split() things out:

Parsing with join and split - 5/9/1999
[url]http://www.4guysfromrolla.com/webtech/050999-1.shtml[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!