SonicBoomBand
Technical User
I have this bit of VB Script that writes the results of a recordset to my asp page. However nothing happens where the 'vbtabs' are located. Is it possible to do this and if so can somebody amend for me.
rs.open "SELECT ID, Year, Venue, Course1, Course2, Winner FROM tblTrophyWinners",objConn
do until rs.eof
response.write ("<font size=2><b>" & rs("ID") & vbtab & rs("Year") & " " & rs("Venue") & "</b></font><br>")
response.write ("<font size=2>" & vbtab & rs("course1") & "</font><br>")
response.write ("<font size=2>" & rs("course2") & "</font><br>")
response.write ("<font size=2>Winner:" & " " & "<b>" & rs("Winner") & "</b></font><br>")
response.write ("<hr>")
rs.movenext
loop
Many Thanks
Andrew Chamberlain
National Grid
rs.open "SELECT ID, Year, Venue, Course1, Course2, Winner FROM tblTrophyWinners",objConn
do until rs.eof
response.write ("<font size=2><b>" & rs("ID") & vbtab & rs("Year") & " " & rs("Venue") & "</b></font><br>")
response.write ("<font size=2>" & vbtab & rs("course1") & "</font><br>")
response.write ("<font size=2>" & rs("course2") & "</font><br>")
response.write ("<font size=2>Winner:" & " " & "<b>" & rs("Winner") & "</b></font><br>")
response.write ("<hr>")
rs.movenext
loop
Many Thanks
Andrew Chamberlain
National Grid