Record count in a query

Discussion in 'C#' started by minciamia, Mar 22, 2008.

  1. #1
    HI: i have a question about how to insert a record count in an already existing query in ASP :)

    Here's the (working) code:

    
    <!-- #include file="header.inc" -->
    
    <%
    u_search=request.form("u_search")
    u_where=request.form("u_where")
    if u_search = "" or u_where= "" then 
    response.redirect "default.asp"
    
    end if
    accessdb="/mdb-database/database.mdb" 
    cn="DRIVER={Microsoft Access Driver (*.mdb)};"
    cn=cn & "DBQ=" & server.mappath(accessdb)
    Set rs = Server.CreateObject("ADODB.Recordset")
    
    sql = "select * from tblNews where " & u_where &" like '%%"& u_search & "%%'" 
    
    rs.Open sql, cn
    If  rs.eof then
       search="nothing"
    end if
    %>
    
    <title>Search results</title>
    <body>
    <% if search <> "nothing" then %>
    <img border="0" src="news_images/icons/results.png" width="32" height="32">Results found!</font><br>
    
    <% end if %>
    <%
    On Error Resume Next
    rs.MoveFirst
    do while Not rs.eof
    %>
    
    
    Abstract: </font><b> <%= rs("abstract") %></b><br>
    
    Date of publication: <%= rs("date_of_publication") %><br>
    
    
    
    
    
    <%
    rs.MoveNext
    loop%>
    
    <% if search = "nothing" then %>
    
    	<p align=center><img border="0" src="news_images/icons/noresults.png" width="32" height="32">No Search Results Matched</font> "<font color=#CC3300><b><%= u_search %></font></b>"</td></p>
    <% end if %></table></center><!--#include file="footer.inc"-->
    Code (markup):
    I wish to insert a record count for the results found: please, someone could be so kind to help me? Thanks in advance. :)
     
    minciamia, Mar 22, 2008 IP
  2. minciamia

    minciamia Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Ooopps!! Sorry, i've already found out how to do.
    I apologize for opening an useless thread :eek:
     
    minciamia, Mar 22, 2008 IP