469,903 Members | 1,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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

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
header always reads:

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.

Thanks in advance

David

Feb 15 '06 #1
2 1272
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
header always reads:

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.
(Please change the x'es to dots in my emailaddress)
Feb 15 '06 #2
>
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?
Feb 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Charles Alexander | last post: by
2 posts views Thread by Xiaozhu | last post: by
5 posts views Thread by Carmine Cairo | last post: by
8 posts views Thread by Jeff | last post: by
47 posts views Thread by fb | last post: by
8 posts views Thread by koorb | last post: by
11 posts views Thread by felixnielsen | last post: by
1 post views Thread by Promextheus Xex | last post: by
5 posts views Thread by =?Utf-8?B?Z215ZXJz?= | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.