I'm new at ASP and I'm trying to get my search results page to divide up the results so there won't be a lot listed on just one page. This is the only thing I can't figure out. I've tried samples of other code with no luck. Here is my code:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
search = request.form("bgg")
Set cnn = CreateObject("ADODB.Connection")
str = "Provider=Microsoft.Jet.OLEDB.4.0;"
str = str & "Data Source=C:\Inetpub\wwwroot\test\test.mdb"
cnn.ConnectionString = str
SQL = "Select * From Price where Header Like '%" & search & "%' order by Page"
Set rs = CreateObject("ADODB.Recordset")
rs.ActiveConnection = cnn
(I took out the tables so the code wouldn't be that long on this post)
Response.write "<TR><TD> </TD><TD> </TD><TD> </TD><TD><center><img src=Pictures\WesServerLogo.gif></center></TD></TR>"