Memnoch1207
07-31-2002, 11:40 AM
Below is my code
<!--#include virtual="/core/classes/dbpaging.asp" -->
<!--#include virtual="/core/modules/common.asp" -->
<%
set t = new dbpaging
call t.set_table_name("catalogCategories")
call t.set_sqlString("SELECT catId, des FROM catalogCategories ORDER BY des")
call t.set_recordsDisplayed(15)
numPages = t.calculate_totalPages()
db_open(application("connectionString"))
set myD = t.get_page()
c = 1
do until c = myD.Count
.setVariable "FIELD1", myD(c)("catId")
.setVariable "FIELD2", myD(c)("des")
c = c + 1
loop
db_close
%>
I am getting an "Invalid or Unqualified Reference" error on the line that reads.
.setVariable "FIELD1", myD(c)("catId")
any ideas?
I have checked out MSDN, but it states
You attempted to use the With statement on something other than an object. The With statement can only be used with non-null object values. The following demonstrates the correct structure of a With block.
<!--#include virtual="/core/classes/dbpaging.asp" -->
<!--#include virtual="/core/modules/common.asp" -->
<%
set t = new dbpaging
call t.set_table_name("catalogCategories")
call t.set_sqlString("SELECT catId, des FROM catalogCategories ORDER BY des")
call t.set_recordsDisplayed(15)
numPages = t.calculate_totalPages()
db_open(application("connectionString"))
set myD = t.get_page()
c = 1
do until c = myD.Count
.setVariable "FIELD1", myD(c)("catId")
.setVariable "FIELD2", myD(c)("des")
c = c + 1
loop
db_close
%>
I am getting an "Invalid or Unqualified Reference" error on the line that reads.
.setVariable "FIELD1", myD(c)("catId")
any ideas?
I have checked out MSDN, but it states
You attempted to use the With statement on something other than an object. The With statement can only be used with non-null object values. The following demonstrates the correct structure of a With block.