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:
Thanks
Code:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Dim cnn
Dim str
Dim search
Dim rs
Dim SQL
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
cnn.Open
SQL = "Select * From Price where Header Like '%" & search & "%' order by Page"
Set rs = CreateObject("ADODB.Recordset")
rs.ActiveConnection = cnn
rs.Open SQL
(I took out the tables so the code wouldn't be that long on this post)
rs.MoveNext
Wend
Response.write str
Response.write "<TR><TD> </TD><TD> </TD><TD> </TD><TD><center><img src=Pictures\WesServerLogo.gif></center></TD></TR>"
Response.write "</TABLE></FONT>"
cnn.close
</SCRIPT>
Thanks