<%=(RsProductSearch_last)%> Not Working

Posted on 2011-10-18
Last Modified: 2012-05-12
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" "">
<html xmlns="">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>

<p>Total = 

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

Open in new window

Please help -

Question by:garethtnash
    LVL 33

    Accepted Solution

    Where are RsProductSearch_total and RsProductSearch_last defined?

    Author Comment

    I thought that the recordset automatically produced these?

    Author Closing Comment

    Found the solution - thanks though :)

    Featured Post

    Course: CSS Specialist

    We don’t have to sell you on the idea of becoming a developer. If you’re you here, you already know it’s one of the most lucrative (and fastest growing) career tracks out there. It’s CSS that allows you to set yourself apart from other web and mobile developers.

    Join & Write a Comment

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
    In this tutorial viewers will learn how to position items using CSS's three positioning types Create a new HTML document with an internal stylesheet.: Create another div in CSS and name it Absolute : Type "position:absolute;" and "top:10px; left:50p…
    HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now