Link to home
Start Free TrialLog in
Avatar of khuz01
khuz01

asked on

looping a query resultset to form a link in vb

I'm looping through a query resultset to form a link but get the above error.

please can someone help me put the speech marks in the correct places to form a working link.

thanks in advance.
lessonlink = ""
	do while not rs2.EOF
	lessonlink = lessonlink & "<a href=""lesson.asp?" & rs2("EntryTime") & """>"& rs2("EntryTime") & "</a>""
	Response.Write rs2("EntryTime")  
	Response.Write "<BR>"
	Response.Write rs2("Subject")
	Response.Write "<BR>"	
	Response.Write rs2("Topic")
	Response.Write "<BR>"
	Response.Write rs2("Behaviour")
	Response.Write rs2("Percentage")
	Response.Write "<BR>"
	Response.Write "<BR>"
	Response.Write rs2("TeacherComments")
	Response.Write "<BR>"
	Response.Write rs2("ParentComments")
	Response.Write "<hr>"
	rs2.MoveNext
	loop
	rs2.Close
	rs.Close
	Set rs2= Nothing

Open in new window

Avatar of PaulHews
PaulHews
Flag of Canada image

lessonlink = lessonlink & "<a href=""lesson.asp?" & rs2("EntryTime") & """>"& rs2("EntryTime") & "</a>"
ASKER CERTIFIED SOLUTION
Avatar of PaulHews
PaulHews
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial