CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 CCDLookUp problem

Print topic Send  topic

Author Message
RonB
Posted: 05/04/2002, 2:44 AM

Still trying to get the hang of this new studio lingo

here's the code:

function fzortextra_Medewerker_BeforeShow() {
//fzortextra_Medewerker_BeforeShow @10-754A045D

//Custom Code @96-2A29BDB7

// -------------------------

global $fzortextra;

$fzortextra->Medewerker->setvalue(CCDLookUp($medewerkers,$naam,$id1=CCGetUse
rId(),$connection2));

// -------------------------

//End Custom Code



Here's the error:

Fatal error: Call to a member function on a non-object in c:\program
files\apache group\apache\htdocs\personal\Common.php on line 397




Help?



Ron Borkent


Dave Rexel
Posted: 05/04/2002, 12:34 PM

SOLVED : Re: howto use CCGetDBValue($sql, $db)

I took a deep breath and scratched unwillingly in CC code

function eko_trans_out_mysum_BeforeShow() { //eko_trans_out_mysum_BeforeShow
@34-6C3823F0
//Custom Code @36-2A29BDB7
// -------------------------
// Write your own code here.
global $eko_trans_out;

//#### YOU HAVE TO FIND WHAT CCS NAMES YOUR CONNECTION
//####MAKE IT GLOBAL IN THIS PLACE
global $DBConnection1;

//####TEST CODE
$sql = "SELECT SUM(eko_amount) FROM eko_trans_out";

//####NOW USE THE COMMON FUNCTION
$myLookup = CCGetDBValue($sql, $DBConnection1);

$eko_trans_out->mysum->Value = $myLookup;
// -------------------------
//End Custom Code

Hope this helps
:-) Dave

"RonB" <r.borkent@123chello.nl> wrote in message
news:ab0ail$fal$1@news.codecharge.com...
> Still trying to get the hang of this new studio lingo
>
> here's the code:
>
> function fzortextra_Medewerker_BeforeShow() {
> //fzortextra_Medewerker_BeforeShow @10-754A045D
>
> //Custom Code @96-2A29BDB7
>
> // -------------------------
>
> global $fzortextra;
>
>
$fzortextra->Medewerker->setvalue(CCDLookUp($medewerkers,$naam,$id1=CCGetUse
> rId(),$connection2));
>
> // -------------------------
>
> //End Custom Code
>
>
>
> Here's the error:
>
> Fatal error: Call to a member function on a non-object in c:\program
> files\apache group\apache\htdocs\personal\Common.php on line 397
>
>
>
>
> Help?
>
>
>
> Ron Borkent
>
>
>

RonB
Posted: 05/04/2002, 1:39 PM

Thanx a million, worked like a charm.

Ron Borkent

"Dave Rexel" <therex_spamenot@hotmail.com> schreef in bericht
news:ab1d4q$au9$1@news.codecharge.com...
> SOLVED : Re: howto use CCGetDBValue($sql, $db)
>
> I took a deep breath and scratched unwillingly in CC code
>
> function eko_trans_out_mysum_BeforeShow() {
//eko_trans_out_mysum_BeforeShow
> @34-6C3823F0
> //Custom Code @36-2A29BDB7
> // -------------------------
> // Write your own code here.
> global $eko_trans_out;
>
> //#### YOU HAVE TO FIND WHAT CCS NAMES YOUR CONNECTION
> //####MAKE IT GLOBAL IN THIS PLACE
> global $DBConnection1;
>
> //####TEST CODE
> $sql = "SELECT SUM(eko_amount) FROM eko_trans_out";
>
> //####NOW USE THE COMMON FUNCTION
> $myLookup = CCGetDBValue($sql, $DBConnection1);
>
> $eko_trans_out->mysum->Value = $myLookup;
> // -------------------------
> //End Custom Code
>
> Hope this helps
> :-) Dave
>
> "RonB" <r.borkent@123chello.nl> wrote in message
>news:ab0ail$fal$1@news.codecharge.com...
> > Still trying to get the hang of this new studio lingo
> >
> > here's the code:
> >
> > function fzortextra_Medewerker_BeforeShow() {
> > //fzortextra_Medewerker_BeforeShow @10-754A045D
> >
> > //Custom Code @96-2A29BDB7
> >
> > // -------------------------
> >
> > global $fzortextra;
> >
> >
>
$fzortextra->Medewerker->setvalue(CCDLookUp($medewerkers,$naam,$id1=CCGetUse
> > rId(),$connection2));
> >
> > // -------------------------
> >
> > //End Custom Code
> >
> >
> >
> > Here's the error:
> >
> > Fatal error: Call to a member function on a non-object in c:\program
> > files\apache group\apache\htdocs\personal\Common.php on line 397
> >
> >
> >
> >
> > Help?
> >
> >
> >
> > Ron Borkent
> >
> >
> >
>
>


   


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

Web Database

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.