How So?

Results 1 to 3 of 3

Thread: How So?

  1. #1
    Joel M Guest

    Default How So?

    Maybe I&#039m not doing it the best way in the first place. The way it&#039s set up now...<BR>I make a connection at the top to make a list from one table...<BR>Then I close that and make another connection to make another list from another table.<BR>Is there any way to make it easier?

  2. #2
    Join Date
    Dec 1969

    Default RE: How So?

    You should be able to use the connection as many times as you like. Just remember that after the final SELECT is done, to set it = Nothing.<BR><BR><BR>HTH<BR><BR>Jerry

  3. #3
    Join Date
    Dec 1969

    Default RE: How So?

    Open a connection at the top of the page. Create a recordset (or whatever) and populate the first list. Then reopen the same recordset using the same connection with the new sql query. Populate the next list with the new recordset info. Repeat as necessary.

Posting Permissions

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