Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>Wrap the user info row in a condition and then work out when the user changes. Something like this;</p> <pre><code>&lt;% IF RS2.EOF THEN 'No results ELSE 'start loop WHILE NOT RS2.EOF rowCount = rowCount + 1 'set the first user and then work out when the user changes if userid="" then userid=RS2("U_ID") progress=true else if userid-RS2("U_ID") = 0 then progress=false else userid=RS2("U_ID") progress=true end if end if IF (progress AND rowCount &gt; 1) THEN Response.write "&lt;/table&gt;" &amp; vbcrlf END IF 'user has changed IF progress THEN Response.write "&lt;table width=""80%""&gt;"&amp; vbcrlf Response.write "&lt;tr&gt;"&amp; vbcrlf Response.write "&lt;td&gt;&lt;strong&gt;Name:&lt;/strong&gt;&lt;span class=""underline""&gt;"&amp; Rs2("stdName")&amp;" &lt;/span&gt;&lt;/td&gt;" &amp; vbcrlf Response.write "&lt;td&gt;&lt;strong&gt;Class:&lt;/strong&gt; &lt;span class=""underline""&gt;" &amp; Rs2("Class_Code")&amp;" &lt;/span&gt;&lt;/td&gt;" &amp; vbcrlf Response.write "&lt;td&gt;&lt;strong&gt;UID:&lt;/strong&gt; &lt;span class=""underline""&gt;"&amp; Rs2("U_ID") &amp;"&lt;/span&gt;&lt;/td&gt;"&amp; vbcrlf Response.write "&lt;td&gt;&lt;strong&gt;Date:&lt;/strong&gt; &lt;span class=""underline""&gt;"&amp; Rs2("submit_date") &amp;"&lt;/span&gt;&lt;/td&gt;"&amp; vbcrlf Response.write "&lt;/tr&gt;" &amp;vbcrlf Response.write "&lt;tr class=""trhead2""&gt;" &amp;vbcrlf Response.write "&lt;td&gt;Subject&lt;/td&gt;" &amp;vbcrlf Response.write "&lt;td&gt;Total Marks&lt;/td&gt;" &amp;vbcrlf Response.write "&lt;td&gt;Obtained Marks&lt;/td&gt;" &amp;vbcrlf Response.write "&lt;td&gt;Actual Marks&lt;/td&gt;" &amp;vbcrlf Response.write "&lt;/tr&gt;" &amp;vbcrlf END IF 'write out user's data Response.Write "&lt;tr class=""trhighlight""&gt;" &amp;vbcrlf Response.Write "&lt;td&gt;"&amp; Rs2("Subject") &amp;" &lt;/td&gt;" &amp;vbcrlf Response.Write "&lt;td&gt;"&amp; Rs2("total_marks")&amp;" &lt;/td&gt;" &amp;vbcrlf Response.Write "&lt;td&gt;"&amp; Rs2("obt_marks")&amp;" &lt;/td&gt;" &amp;vbcrlf Response.Write "&lt;td&gt;"&amp; Rs2("act_marks")&amp;" &lt;/td&gt;" &amp;vbcrlf Response.Write "&lt;/tr&gt;" &amp;vbcrlf RS2.MoveNext WEND IF progress = false THEN Response.write "&lt;/table&gt;" &amp; vbcrlf END IF END IF %&gt; </code></pre> <p>You'll need to order your recordset results by the user id.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload