CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 count

Print topic Send  topic

Author Message
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.
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.