I am not sure whether I followed ur Question properly. But, If you want to fill 2 dropdown Boxes with the same data fetched from the Database, then --- When you retrieve the data from the RecordSet like rs.open SQL, Conn. Do :: dim myarray
if not rs.eof then myarray = rs.getrows() end if NoofCols = ubound(myarray,1) NoofRows = ubound(myarray,2) And then you can fill the dropsown boxes using myarray(col,row). Hope this helps Mingle. On Sun, 31 Oct 2004 18:42:34 -0000, 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 Links > > > > > -- Mingle Work Smarter not Harder ------------------------ 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/
