looping queries

Results 1 to 2 of 2

Thread: looping queries

  1. #1
    Join Date
    Dec 1969

    Default looping queries

    All, <BR><BR>In ASP I sometimes have query B which is driven off an ID of Query A. Someting like this <BR><BR>Select CatID from Category <BR><BR>do while not rs.EOF <BR>select ProductName from Product Where CATID = rs.fields("Catid") <BR><BR>do while not rs1.eof <BR>rs1.fields("ProductName") <BR>loop <BR><BR>loop <BR><BR>How would I set this up in ASP.NET? <BR><BR>Thanks <BR>CHopps

  2. #2
    Join Date
    Dec 1969

    Default Huh? Why not use a better query?

    This looks like a job for INNER JOIN!<BR><BR>What are the SQL statements you are using?

Posting Permissions

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