Populating Dropdowns from a Database

Results 1 to 3 of 3

Thread: Populating Dropdowns from a Database

  1. #1
    Paul Morris Guest

    Default Populating Dropdowns from a Database

    How do I populate a single Dropdown menu from a column in a database table, if the table is called test, and the column I want to populate the dropdown called date? <BR><BR>Any help would be much appreciated

  2. #2
    sathiya Guest

    Default RE: Populating Dropdowns from a Database

    sqlstr = select ID from table<BR>set rsRec = Connection.Execute("sqlstr")<BR><BR>&#060;select name="ID" size=1&#062; <BR>&#060;option&#062;<BR>&#060;/option&#062; <BR>&#060;% Do While Not rsRec.eof %&#062;<BR>&#060;option value="&#060;%=rsRec("ID")%&#062;" &#062;&#060;%=rsRec("ID")%&#062;<BR>&#060;/option&#062;<BR>&#060;%rsRecipients.MoveNext Loop %&#062; <BR>&#060;/select&#062;

  3. #3
    Paul Morris Guest

    Default RE: Populating Dropdowns from a Database

    Thanks for that, you may be screaming novice about now, but I take it that the page needs to be saved as asp, and that the page requires a DSN connection setting up for the dropdown, could you give me a novices guide to setting this up.<BR><BR>Thankyou, thankyou, thankyou in advance...<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •