rookie
|
Posted: 10/18/2003, 8:40 AM |
|
How can I count how many are in a table, or grid...? and present it on the
default (first) page....?
I have a Default page, I need to present in it, how many users are in the
"users" table , messeges are in the "messeges" table, etc.
|
|
|
Roger Gough
|
Posted: 11/13/2003, 8:54 AM |
|
Use CCDLookUp() Function, e.g.:
CCDLookUp("count(*)" "users", "", <connection>)
to set the value of a label.
Hope this helps.
--Roger
"rookie" <pcboss1976@hotmail.com> wrote in message
news:bmrmto$h99$1@news.codecharge.com...
> How can I count how many are in a table, or grid...? and present it on the
> default (first) page....?
> I have a Default page, I need to present in it, how many users are in the
> "users" table , messeges are in the "messeges" table, etc.
>
>
|
|
|
DonB
|
Posted: 11/13/2003, 11:58 AM |
|
This feature is implemented as an "action" type of event. Just put a label
within the grid (between the start and end icon, but NOT within the rows of
the table or it will repeat the value for each row displayed. Assign the
label the Action named "Retrieve Number of Records" and CCS takes care of
the rest.
--
DonB
http://www.gotodon.com/ccbth
"Roger Gough" <rgough@bev.net> wrote in message
news:bp0d0q$fcj$1@news.codecharge.com...
> Use CCDLookUp() Function, e.g.:
>
> CCDLookUp("count(*)" "users", "", <connection>)
>
> to set the value of a label.
>
> Hope this helps.
>
> --Roger
>
> "rookie" <pcboss1976@hotmail.com> wrote in message
>news:bmrmto$h99$1@news.codecharge.com...
> > How can I count how many are in a table, or grid...? and present it on
the
> > default (first) page....?
> > I have a Default page, I need to present in it, how many users are in
the
> > "users" table , messeges are in the "messeges" table, etc.
> >
> >
>
>
|
|
|
|