CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Label value from database?

Print topic Send  topic

Author Message
yeppers
Posted: 06/30/2002, 2:24 PM

Using CCS and PHP, how would I get a label to display a value pulled from the database using a GET parameter?

Thanks!
Chris K.
Posted: 06/30/2002, 3:44 PM

You could either create database-bound Label control within some form and specify URL-type parameter in the form's datasource for some WHERE clause filtering. Or you could create Label control on page (not within any form) and assign a value to it in the control's BeforeShow event, using CCDLookUp function with filtering parameter retrieved from URL using CCGetFromGet:

function Label1_BeforeShow() {

global $Label1;
global $DBinternet;
$Label1->SetValue(CCDLookUp("expression","table","field=".CCToSQL(CCGetFromGet("fromurl"),ccsType),$DBinternet));

}
yeppers
Posted: 07/02/2002, 9:48 AM

Thanks Chris!

   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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