hello all
how can we have a table with some rows that has some columns too.which for exmple column number 4,5,6,7,... of each row is dyanmic and other columns are static?
i wrote a program that has 16 rows and 25 columns.colulmn number1,2,3 of each row contains row number,HGNo,UnitNo
and are static values that i wrote them myself.but other columns are dynamic and my program should read the record that has those HGNo,UnitNo and show some values in those columns.
for example:
 <% While (NOT rs.EOF)%><table><tr>
<td>if (rs("HGNo")="4021" and rs("UnitNo")="5" then
do some thing
</td></tr></table>
<%rs.movenext()
wend%>

I am not sure I understand what you want. Can't you just add the static columns to the repeating code? This displays a row for each record in your recordset. The first two columns display static data while the other two display data from the recordset.

Note that I took the <table> tags outside the loop.

Does this help?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

thank you.i've done it

i thought that the program is run correctly but now i sea just it woroks for first column of the first row.i wrote a while loop for each td because each td has a different program:
<tr><td>static value</td>
<td><%while not rs.eof
if(statement)then
...
end if
rs.movenext()
wend%>
</td></tr>
is it correct?????if it is correct why it doesn't work for other columns.

I don't know if this is correct, as it depends on your business logic.

This code writes out a single <tr> and loops through the recordset writing out the value for each record in a single <td>. If that's what you're after, it works....

If you want to write a row for each record in the recordset, move the code that writes a <tr> and a <td> to inside the loop.

E.g.: This writes out a row for each record, with a static column, and a column with data from the recordset.

HtH,

Imar



---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

those if's are for each record for each td.so as you said the program is write but it doesn't work.i will work on it maby somewhere i made a mistake.

Do you want to repeat *all* records in the recordset in each table row?

Then you need to reset the recordset using MoveFirst.

If I were you, I'd first determine what exactly it is you want. Draw it out on a piece of paper, or try to write pseudo code of how you'd like the application to work. If you do that, things will be much clearer to you (and us).

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

i want to search all the recordset for each td to find a recordset with special specifications that i defined them with if codes.
you mean i should write rs.movefirst for each td before while loop for searching from the first record????sorry if i'm not writting my programs in a right way.and thank you because your very useful helps during this time because there no one eles to help me

Yes, exactly.

Using While .... MoveNext will loop through the entire recordset. After the last record, the recordset will be EOF (End of File). After that, you can no longer read from the recordset, until you call MoveFirst that positions the cursor at the first record so you can start looping.

HtH,

Imar

I did everything as you said and it works in my local computer but when i uploaded it to internet it shows 6 rows and in one the columns of the 6th row it shows this error:
Active Server Pages error 'ASP 0113'

Script timed out

/kitmaterialsel.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools
what should i do with such error????