Recordset total showing -1

Question

Hi Guys,
I have a puzzle and im not seeing the problem..

Im in DW8 using VBS on ASP pages

Im pulling a recordset from a database with some sql to filter my records.
The recordset is getting pulled and the records are being displayed.

So I thought Id put a message on the page if there were no records so I tried to use

<%=(Recordset1_total)%> to get my record total value and if it was 0 or less than 0 ive put


<% 

if ((Recordset1_total) <= 0) then

response.Write("No Photos Added As Yet Please Look Back Or
Add A Photo Now!")

end if

%>

Now when I look at the value of Recordset1_total it shows as -1 all the time even when there are records in there??

Sorry its late and im just not seeing it?
Thanks again for any support
Regards
Tag

DLoe · Answer

I think this might be relevant. I've used this before for a record count:

First, the cursor must be set before opening record set:

rsRecordSetName.CursorType=1
rsRecordSetName.Open()
varCoRecCount = rsRecordSetName.recordcount

From some other posts, I understand DW8 may have a different code for opening record sets. The above came from something I dd in DW 2004 or MX. I haven't looked at the code from DW8.

It's the use of "rsRecordSetName.recordcount" that I'm pointing out.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded