String comparison

arnabghosh · June 29th, 2006, 05:23 AM

Hi,
I have a page where records are displayed from the database in order of the address.the address are like:
1 Carragh Park - 1 record
2 Carragh Park - 4 records
4 Carragh Park-4 records
6 Carragh Park-6 records

all records of on address should display in one page

e.g. 1st page 1 Carragh Park -1 record
2nd page 2 Carragh Park- 4 records
3rd page 3 Carragh Park - 4 records
and correspondingly

I'm giving a page braek using:

<div style="page-break-after: always;"></div>

the entire display is being done using do while not rs.eof

what should be my if condition to put the page breaks

the address field is: rs("hsenumxtownland")

Can anyone pleasee out.?????

ChrisScott · June 29th, 2006, 06:01 AM

You could create a variable to store the address and then compare the new address to it each time you loop...

Code:

Dim storeAddress: storeAddress = ""
Do Until rs.EOF
    Dim address: address = rs("hsenumxtownland")
    If storeAddress <> "" And storeAddress <> address Then
        ' ----- WRITE PAGE BREAK -----
        storeAddress = address
    End If
    ' ----- DO OTHER STUFF -----
Loop

HTH,

Chris