Velocity Reviews > Problem with asp loop........

# Problem with asp loop........

David
Guest
Posts: n/a

 02-15-2006
Hi,

The data I am trying to print on the web looks as follows:

Date 1

Record 1
Record 2
Record 3

Date 2

Record 1
Record 2
Record 3

and onwards ..........................

This I have working fine.
I need to add a calculation into the page print, so the page looks
like:

Date 1 (There are 437 units this week)

Record 1
Record 2
Record 3

Date 2 (There are 821 units this week)

Record 1
Record 2
Record 3

PROBLEM:
The calculation is done by stuffing a variable at the end of the loop,
and then calling a function which prints either 'No Data' or 'There are
xxx units this week'

Because the calculation has to be done at the end of the record loop
before the date changes, when the page first loads, the first date

Date 1 (No Data)

Record 1
Record 2
Record 3

Which is true, because the code has not yet looped through that dates
records, and hence the calculation = 0. Except there is a value. How
can I get around this problem ??

The calculation for the 1st date in the recordset is always printed
against the 2nd date header and so on down the listing. This is
obvious, as on the second loop, the first calculation has been done,
and gets printed when the next date header is created....

Much confused. I have tried everything I know.

David

Evertjan.
Guest
Posts: n/a

 02-15-2006
David wrote on 15 feb 2006 in microsoft.public.inetserver.asp.general:

> Because the calculation has to be done at the end of the record loop
> before the date changes, when the page first loads, the first date
>
> Date 1 (No Data)
>
> Record 1
> Record 2
> Record 3
>

Safe your html code in a string and response.write that later:

s1 = "<br><br>Date 1"

'' start of loop

s3 = "<br><br>Record 1"

s3 = s3 & "<br>Record 2"

s3 = s3 & "<br>Record 3"

'' end of loop

s2 = "(computed result)"

response.write s1 & s2 & s3

--
Evertjan.
The Netherlands.

Noozer
Guest
Posts: n/a

 02-15-2006
>
> PROBLEM:
> The calculation is done by stuffing a variable at the end of the loop,
> and then calling a function which prints either 'No Data' or 'There are
> xxx units this week'

Loop twice?

Build your output and output it at the end of the loop?

Where is the data coming from?