billames
Posts: 5
|
| Posted: 05/03/2005, 12:07 PM |
|
I'm trying to create a dynamic label which would display a record count from a database. I have not been able to do this without adding a grid to the page. Is there an easy way to have a label display something from say this query:
SELECT COUNT(*) AS Expr1 from Claimsdata
So then on my page it would look something like:
543 Claims in the database
Any help would greatly be appreciated.
|
 |
 |
Nicole
Posts: 586
|
| Posted: 05/04/2005, 4:34 AM |
|
Hello,
You can use CCDLookUp() function to retrieve a single field value from a table or execute custom query using Execute method. Refer to CCS docs for more information and sample code
http://docs.codecharge.com/studio/html/index.html?http:...BValue.html?toc
http://docs.codecharge.com/studio/html/index.html?http:...tomSQL.html?toc
_________________
Regards,
Nicole |
|
|
|
billames
Posts: 5
|
| Posted: 05/04/2005, 9:55 AM |
|
Thanks a bunch, I used the "Retrieve Multiple Field Values from a Database" and it works perfectly.
Thanks again.
|
|
|
|
|
