Database data layout in a table 1

[Jeremy74]

Hi

I have a table with three rows and three colums. What I want is the three rows and Colums to be filled with the same database Colum (different entry).

Example

[recordset1.pic][recordset1.pic][recordset1.pic]
[recordset1.pic][recordset1.pic][recordset1.pic]
[recordset1.pic][recordset1.pic][recordset1.pic]

I can get the all the recordsets going down or accross the way using the repeat region command, but can't get it to populate all 9 cells.

Am I being thick? What's the easy way to do this.

Cheers

Jeremy

 

[ChrisHirst]

"Am I being thick? What's the easy way to do this"

Only by expecting some other program to write code that you need.

You need a nested FOR..NEXT loops to go around the recordset and cells, Write the cell tags and display the RS field, then move to the next record on each iteration.

something like;
for i = 1 to int(rs.recordcount/3)
response.write &quot;<tr>&quot;
for cellLoop = 1 to 3
response.write &quot;<td>&quot;
response.write rs.fields(&quot;field&quot
response.write &quot;</td>&quot;
if not rs.eof then
rs.movenext
next
else
response.write &quot;<td>&nbsp;</td>
next
end if
response.write &quot;</tr>&quot; & vbCRlf
next

this should write a 3 column table on the page with the rows determined by the number of records.

btw. above code not tested just thinking at the keyboard.




Chris.

Indifference will be the downfall of mankind, but who cares?

 

[Jeremy74]

Thanks Chris