How do I loop my query results?

Results 1 to 2 of 2

Thread: How do I loop my query results?

  1. #1
    Troy Guest

    Default How do I loop my query results?

    Here is my connection to the database. What do I do now to loop the first 10 results so it makes a table with them?<BR><BR><BR>Set cnInfo = Server.CreateObject("ADODB.Connection")<BR>strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR>"Data Source=mydatabase;"<BR>cnInfo.ConnectionString = strCon<BR>cnInfo.Open <BR>Set rsInfo.activeconnection = cnInfo<BR>strSql = "SELECT TOP 10 num, fname, lname from guestbook order by desc"<BR> strSql,cnInfo,adopenDynamic<BR><BR>Thanks for the help!!<BR>

  2. #2
    Neil Popham Guest

    Default See your previous post for reply

    i&#039ve replied below now Troy<BR><BR>sorry, i&#039ve been real busy...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts