Re: looping question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff (gig_bam_takemeout__at_verizon.net)
Date: 08/07/04 

Date: Sat, 7 Aug 2004 17:05:22 -0400

Ok. I got that part. But what about only having "against" in between the
first set of records, and not the second. like i have in the second example?
jeff

"J. Alan Rueckgauer" <void@dev.nul> wrote in message
news:%23ymV3VKfEHA.1208@TK2MSFTNGP10.phx.gbl...
> If iCol = 0 Then
> Response.Write "<td>""against""</td>"
> End If
>
> Take the quotes off ""against"":
> Response.Write "<td>against</td>"
>
> Also, you could change your outer Do to "Do Until oRS.EOF". This is more
> efficient as it's not having to perform negation on the condition.
>
> Alan
>
> "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message
> news:ul5v05JfEHA.3732@TK2MSFTNGP11.phx.gbl...
> > ok.. here is my script
> >
> > <%
> > Set Conn = Server.CreateObject("ADODB.Connection")
> > Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" &
> > Server.MapPath("/singlestour/fpdb/singles_tour.mdb")
> >
> > SET oRS= Server.CreateObject("ADODB.Recordset")
> >
> > strSQL = "Select username, total_score from current order by total_score
> > desc"
> >
> > SET oRS= Conn.Execute(strSQL)
> >
> > Const MAX_COLS = 2
> > Dim iCol, username, total_score
> >
> > Response.Write "<table border='1'>"
> > Do While not oRS.Eof
> > iCol = 0
> > Response.Write "<tr>"
> > Do While iCol < MAX_COLS
> > If oRS.Eof Then
> > username = "&nbsp;"
> > total_score = "&nbsp;"
> > Else
> > username = oRS("username").value
> > total_score = oRS("total_score").value
> > oRS.moveNext
> > End If
> >
> > Response.Write "<td>" & username & "</td>"
> > Response.Write "<td>" & total_score & "</td>"
> > Response.Write "<td>""against""</td>"
> > iCol = iCol + 1
> > Loop
> > Response.Write "</tr>"
> > Loop
> > Response.Write "</table>"
> > %>
> >
> > and the display looks like this
> > http://www.gig-golf.com/singlestour/scores.asp but i want it to look
like
> > this http://www.gig-golf.com/singlestour/scoresexample.asp
> >
> > i am trying how to learn how to put html into asp.. but the main thing i
> > want to get rid of, is having the extra column on the right that says
> > against... i just want it in the middle.... any ideas??
> > Thanks
> > Jeff
> >
> >
> >
> >
>
>

Relevant Pages

  • Deleting Multiple Records with Child File
    ... I need to loop through a file and delete multiple records while at the ... record that meets the criteria (and it's related child records) are ... I need to get the first set of code working and I am at a total loss as ... to why it is only deleting the first record. ...
    (comp.lang.clarion)
  • Deleting Multiple Records with Child File
    ... I need to loop through a file and delete multiple records while at the ... record that meets the criteria (and it's related child records) are ... I need to get the first set of code working and I am at a total loss as ... to why it is only deleting the first record. ...
    (comp.lang.clarion)
  • Re: Normalize slashes in a path
    ... thanks for the report on dash. ... first set to: ... I replaced the "set" in the loop with variable assignments ... and tested 10,000 iterations of hostile input to compare performance. ...
    (comp.unix.shell)
  • Re: selecting range and copying to new worksheet
    ... >> Regards, ... >> Tom Ogilvy ... >>> it does the first part of the job, meaning it copies first set of data ...
    (microsoft.public.excel.programming)
  • VBA Inserting rows conditionally, how to work with shifting range
    ... But when I insert the first set of rows, ... I didn't think I could redefine the range inside the loop, ... clarity but, in the meanwhile, if anyone cares to toss it out off their ... 'Reset Selection? ...
    (microsoft.public.excel.programming)