Possible?

1. Senior Member
Join Date
Dec 1969
Posts
287

## Possible?

2. Senior Member
Join Date
Dec 1969
Posts
96,118

## Easy...

...if you just use a counter:<BR><BR>(And you seem to be missing your &#060;TR&#062; and &#060;/TR&#062; tags!)<BR><BR>&#060;TR&#062;<BR> &#060;td&#062;Clockin Date&#060;/td&#062;<BR> &#060;td&#062;Clock in Time&#060;/td&#062;<BR> &#060;td&#062;Clock Out Time&#060;/td&#062;<BR>&#060;/TR&#062;<BR>&#060;% <BR>row = 2<BR>do while not rsProds.eof <BR>%&#062;<BR> &#060;TR&#062;<BR> &#060;td&#062;&#060;% = rsProds("Clockindate") %&#062;&#060;/td&#062;<BR> &#060;td&#062;&#060;% = rsProds("clockin") %&#062;&#060;/td&#062;<BR> &#060;td&#062;&#060;% = rsProds("clockout") %&#062;&#060;/td&#062;<BR> &#060;td&#062;=hour(e&#060;%=row%&#062;)-hour(d&#060;%=row%&#062;)&#060;/td&#062;<BR> &#060;td&#062;=j&#060;%=row%&#062;*f&#060;%=row%&# 062;&#060;/td&#062;<BR> &#060;/TR&#062;<BR>&#060;%<BR> row = row + 1<BR> rsProds.movenext <BR>loop <BR>%&#062;<BR>

3. Senior Member
Join Date
Dec 1969
Posts
287

## Thank you....it works

THank you so much. I thought I would have to go through getrows thing. Thank you,<BR>Petra.

4. Member
Join Date
Dec 1969
Posts
55

## RE: Thank you....it works

Hey Petra,<BR><BR>I used to shy away from using GetRows, too. But you know what, using GetRows becomes a LIFESTYLE.<BR><BR>Using For...Next to loop through arrays holding your recordsets may look like more code on the screen (with more scalar variables to dimension to boot), but if you&#039;re hitting the database up for several recordsets, each with several records in them, why not hit the database only once for each recordset, instead of once for each record in the recordset?<BR><BR>Think about it. Holding your recordsets in arrays (or strings, if you use the GetString method of your recordset object instead) is nice thing to do for your server and your users.<BR><BR>Cliff

#### Posting Permissions

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