You have 2 options: 1) Build a string of HTML and then response.write them at different times. This assumes that you response.write your select tags before and after each one. 2) Loop thru your recordset and write out the first dropdown, then move back to the first record in the recordset and start over. If you have an immense amount of records, use GetRows to convert your recordset to an array, as it's much faster to loop thru an array then a recordset. Mark
Cady <[EMAIL PROTECTED]> wrote: hi, i don't know whether this problem of mine has been asked by another user or not? ok here the thing i have 2 dropdown box. and i want to fill it with the same data from the database. the dropdown is in the same page.. right now what i use is, i make the connection twice... and it make my page load like a turtle... can anybody help me.. thank you Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
