first record

Results 1 to 2 of 2

Thread: first record

  1. #1
    Mark Guest

    Default first record

    i need to display a the first row in a table and put the details into variables. and then use those variables in an sql statement to query another table in the same database. if anything matches to display the id no in the second table. and then loop back to the next record in the first table. and do the same thing.<BR><BR>im don&#039t know how to do the first bit. To display the first record in the first table and then loop. the rest i should be able to figure out... any help appreciated..<BR><BR>thanx from mark please e-mail response to aswell as posting it please..,...,. .

  2. #2 Guest

    Default RE: first record

    You should make the connection<BR> dim var, var2, var3<BR> set rs = ...<BR> Query,<BR> If NOT rs.EOF Then<BR> rs.MoveFirst<BR> var = rs("name")<BR> var2= rs("id")<BR> var3 = rs("whatever")<BR> end if<BR> &#039Then build you sql with var var2 var3<BR>laters

Posting Permissions

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