• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

<%=(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
0
garethtnash
Asked:
garethtnash
  • 2
1 Solution
 
Paul MacDonaldDirector, 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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now