DS
|
| Posted: 05/19/2001, 2:34 PM |
|
When I limit the no. of records outputted on a grid, e.g. 10 records, the
following navi links are added at the bottom: prev [n] next -- where n is
the page no.
Question: Is there a way of getting the total no. of records that are being
paged on the grid?
I also need to get the total of a column on a grid form.
Question: How is this done?
Thanks for any help in advance.
Best regards,
Dante S.
|
|
|
 |
CodeCharge
|
| Posted: 05/20/2001, 11:32 PM |
|
You may see this is in the BookStore example.
When you search for books, you will see a message "Items found: 22"
This is implemented in Books.asp page by adding "Open" event:
sSQL="select count(item_id) as i_item_id from items as i"
In many cases you can use your own SQL statement instead of the table by
specifying it in Form properties.
"DS" <dante@sandigan.com> wrote in message
news:9e6otm$6c6$1@mail.tankhill.com...
> When I limit the no. of records outputted on a grid, e.g. 10 records, the
> following navi links are added at the bottom: prev [n] next -- where n is
> the page no.
> Question: Is there a way of getting the total no. of records that are
being
> paged on the grid?
>
> I also need to get the total of a column on a grid form.
> Question: How is this done?
>
> Thanks for any help in advance.
>
> Best regards,
> Dante S.
>
>
|
|
|
|
Roger
|
| Posted: 07/31/2001, 1:25 PM |
|
Could never get it to work.
I am using PHP. So.
$sSQL="select count(id) as total_id from registration as i";
Please explain total_id & i.
Alias?
Any extra hints?
--
Rgds
Roger Tng
"CodeCharge" <support@codecharge.com> wrote in message
news:9eacqd$s64$1@mail.tankhill.com...
> You may see this is in the BookStore example.
> When you search for books, you will see a message "Items found: 22"
> This is implemented in Books.asp page by adding "Open" event:
> sSQL="select count(item_id) as i_item_id from items as i"
>
> In many cases you can use your own SQL statement instead of the table by
> specifying it in Form properties.
>
>
>
> "DS" <dante@sandigan.com> wrote in message
>news:9e6otm$6c6$1@mail.tankhill.com...
> > When I limit the no. of records outputted on a grid, e.g. 10 records,
the
> > following navi links are added at the bottom: prev [n] next -- where n
is
> > the page no.
> > Question: Is there a way of getting the total no. of records that are
> being
> > paged on the grid?
> >
> > I also need to get the total of a column on a grid form.
> > Question: How is this done?
> >
> > Thanks for any help in advance.
> >
> > Best regards,
> > Dante S.
> >
> >
>
>
|
|
|
|
|
