<%=(RsProductSearch_last)%> Not Working

Help !!

I've got a very basic page with a very basic recordset on it,
I'm trying to call

First record
Last record
Total Records

but I'm getting no information, I know that my recordset is retrieving data --

heres my page

<!--#include file="Connections/Connection.asp" -->
<%
Dim RsProductSearch
Dim RsProductSearch_cmd
Dim RsProductSearch_numRows

Set RsProductSearch_cmd = Server.CreateObject ("ADODB.Command")
RsProductSearch_cmd.ActiveConnection = MM_Connection_STRING
RsProductSearch_cmd.CommandText = "SELECT * FROM dbo.[Direct-Product]" 
RsProductSearch_cmd.Prepared = true

Set RsProductSearch = RsProductSearch_cmd.Execute
RsProductSearch_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<p>Total = 

  <%=(RsProductSearch_total)%></p>
<p>Data Name = <%=(RsProductSearch.Fields.Item("Product-Name").Value)%></p>
<p>last = <%=(RsProductSearch_last)%></p>
<p>Total = <%=(RsProductSearch_total)%></p>
</body>
</html>
<%
RsProductSearch.Close()
Set RsProductSearch = Nothing
%>

Open in new window


Please help -

Thanks
garethtnashAsked:
Who is Participating?
 
Paul MacDonaldConnect With a Mentor Director, Information SystemsCommented:
Where are RsProductSearch_total and RsProductSearch_last defined?
0
 
garethtnashAuthor Commented:
I thought that the recordset automatically produced these?
0
 
garethtnashAuthor Commented:
Found the solution - thanks though :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.