Total records = "-1"

Report · Jun 19, 2007

Hi there,

windows xp, dw cs, asb.vb, sql2005 express, iis6

Using server behavior "Record Set" and try to display "total records". But i am getting not the real count i am getting "-1".

What is the problem? thx n regards

See Line 329 in the source: Source Code Screenshot

thx for the support
Sebastian

Report · Jun 19, 2007

The record count only works with certain cursor types. DW uses a firehose
cursor, which does not support that property.

"eFscl" <webforumsuser@macromedia.com> wrote in message
news:f58cu2$8ld$1@forums.macromedia.com...
> Hi there,
>
> windows xp, dw cs, asb.vb, sql2005 express, iis6
>
> Using server behavior "Record Set" and try to display "total records". But
> i
> am getting not the real count - i am getting "-1".
>
> What is the problem? thx n regards
>
> See Line 329 in the source:
> http://img26.picoodle.com/img/img26/8/6/19/f_screenshot3m_4c4e2cb.jpg
>
> thx for the support
> Sebastian
>

Report · Jun 19, 2007

quote:

Originally posted by: Newsgroup User
DW uses a firehose
cursor, which does not support that property.

Thank you very much for your feedback.
I am not using my own or special ASP code for getting the record count. I am using the dw cs3 record count feature. See the screenshot in my posting and
this screenshot with the dw server behavior

or do i have to modify the cursor type which was added by dw cs3 himself?

any other help around

Report · Jun 19, 2007

I do not know how CS3 implements its own record count.
Look at the code; if yourRecordset.RecordCount is used, then file a bug
report. If some variable (like yourRecordset__totalRecords) is used, then
there's some other problem.

"eFscl" <webforumsuser@macromedia.com> wrote in message
news:f58kjc$hjg$1@forums.macromedia.com...
>

quote:

Originally posted by: Newsgroup User
> DW uses a firehose
> cursor, which does not support that property.
>

> Thank you very much for your feedback.
> I am not using my own or special ASP code for getting the record count. I
> am
> using the dw cs3 record count feature. See the screenshot in my posting
> and
> http://www.fanclub.ch/screenshot4.jpg
>
> or do i have to modify the cursor type which was added by dw cs3 himself?
>
> any other help around
>

Report · Jun 25, 2007

Lionstone: this doesnt help - CS3 is implementing a lot of code to generate the record count - and its still -1

somebody knows the problem?