Home | Advertising Info53 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Saturday, January 25, 2025  


Using Select Statement With A Loop.




In this example we are selecting all records and showing them all.

The SQL statement is the key and by changing that you can limit the results however you want. This is just an example to get you started.
Don't be afraid to mix a little creative HTML before, during, and after the loop. Thats how dynamic tables are created.

<%
' declaring variables
' not neccesary but a good habit
Dim DataConn
Dim CmdSimpleSelect
Dim MYSQL
   
Set DataConn = Server.CreateObject("ADODB.Connection")
Set CmdSimpleSelect = Server.CreateObject("ADODB.Recordset")
   
' The line below shows how to use a system DSN instead of a DNS-LESS connection
' DataConn.Open "DSN=System_DSN_Name"
DataConn.Open "DBQ=" & Server.Mappath("../_database/database.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
   
MYSQL = "SELECT ID, NAME, EMAIL, MESSAGE FROM some_table"
   
CmdSimpleSelect.Open MYSQL, DataConn

' the following code causes the select Statement to start looping through the records
While Not CmdSimpleSelect.EOF
%>

<%= CmdSimpleSelect("ID") %><br>
<%= CmdSimpleSelect("NAME") %>
<br>
<%= CmdSimpleSelect("MESSAGE") %>
<br>
<%= CmdSimpleSelect("EMAIL") %>
<br>
<hr>

<%
' the following code ends the loop
CmdSimpleSelect.MoveNext
Wend
   
' closing objects and setting them to nothing
' not neccesary but a good habit
CmdSimpleSelect.Close
Set CmdSimpleSelect = Nothing
DataConn.Close
Set DataConn = Nothing
%>



 

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2025 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com