displaying records

Results 1 to 2 of 2

Thread: displaying records

  1. #1
    Join Date
    Dec 1969

    Default displaying records

    This problem is driving me crazy.<BR>I have a series of records that all display. What I need to do, is seperate them with titles, depending on a &#039;location&#039; field.<BR>e.g location 1 would have a title, then the records that have that location. At the end of those records, a new title, then display location 2 records etc. So far I have managed to get it to work for the first two locations, but after that it displays the title for every record. This is the code. what it seems to fail to do, is apply the conditions to all the records.<BR><BR>&#060;% Set RS = Conn.Execute(MSQL)<BR>floc = locations(RS("pr_location"))<BR>response.write floc<BR>If Not RS.EOF Then<BR>Do While Not RS.EOF<BR><BR>if not locations(RS("pr_location")) = floc then<BR>response.write locations(RS("pr_location"))<BR>else response.write "" <BR>end if %&#062;<BR><BR>any ideas?<BR><BR>thanx.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default There is an article/FAQ

    on this site that tells you how to do exactly that<BR><BR><BR>

Posting Permissions

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