Recordsets manipulation

[sabavno]

Hi

My goal is to create the table like that:

Transit AssetType Charges

80000 1 200
90000 2 300
85000 1 250


I have my transits in one recordset. I take one value at the time, pass it to another function that retrieves the AssetTYpe and charges for particular transit and stores it in another recordset. Then I move on to the next transit.

The workflow is this:

Select Transits into rst_transits

Do Unitl rst_transits.EOF
param = rst_transits("Transit_No&quot
call AnotherFunction()
rst_transits.MoveNext
Loop

Function AnotherFunction(Transit_No)

Select AssetType, Charges where transit = param

Create HTML table that looks like the one above.



PLEASE, help me with this....as I really have a critique deadline for this and don't have a time to study this myself.



Thanks...

 

[GaryC123]

Is this for some school/course work? Saturday 12.00

20.00

3.00am

Sunday [img http

 

[sabavno]

No, it's not for the school...

 

[GaryC123]

Open your table tag and set the headers prior to your code above...

<Table width= ...blah blah><TR>
<TD>Transit</TD>
<TD>Asset TypeTD>
<TD>Charges<TD>
</TR>

place code like the below into your code after your
Select AssetType, Charges where transit = param
statement

<TR>
<TD><%=rst_transits(&quot;transit_no&quot%>></TD>
<TD><%=rst_transits(&quot;transit_no&quot%>></TD>
<TD><%=rst_transits(&quot;transit_no&quot%>></TD>
</TR>

and then close your table after all the code Saturday 12.00

20.00

3.00am

Sunday [img http

 

[sabavno]

Thanks a lot GaryC123!