CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Resolved - ccdlookup question

Print topic Send  topic

Author Message
kirchaj

Posts: 215
Posted: 05/15/2013, 6:39 PM

I am having problems getting the dlookup before show function to work in CCS5. I had the same setup in CCS4 and it worked fine.

I am trying to retrieve a date using a parameter passed to the page. Code looks fine and there are no errors but nothing appears in the Label even though I have verified the date exists.

Here is what is generated from the dlookup settings

global $DBedtechaccount;
$Page = CCGetParentPage($sender);
$ccs_result = CCDLookUp("tbchk", "admit", "ssno='".CCGetParam("ssno","")."'", $Page->Connections["edtechaccount"]);

$ccs_result = strval($ccs_result);
$Container->stutbchk->SetValue($ccs_result);

any ideas on the problem?

Thanks.

TK
View profile  Send private message
Lucius

Posts: 220
Posted: 05/15/2013, 9:32 PM

Modify this code so it looks like:

global $DBedtechaccount;  
$Page = CCGetParentPage($sender);  
$ccs_result = CCDLookUp("tbchk", "admit", "ssno='".CCGetParam("ssno","")."'", $Page->Connections["edtechaccount"]);  
  
$ccs_result = strval($ccs_result);  
$Container->stutbchk->SetValue($ccs_result);  
  
echo('ssno: '.CCGetParam("ssno","").'<br>');  
echo('ccs_result : '.$ccs_result .'<br>');  
die();  

Then run the page once with this param present to see what is the issue.
View profile  Send private message
kirchaj

Posts: 215
Posted: 05/15/2013, 11:04 PM

I tried that and nothing shows. It appears that the beforeshow event is not firing for some reason. I will dig into it more tomorrow and see if I can figure it out. :(

TK
View profile  Send private message
kirchaj

Posts: 215
Posted: 05/16/2013, 6:35 PM

For some reason the events file for this page was corrupted. I deleted it, regenerated the page and the ccdlookup worked perfectly as setup above.
View profile  Send private message

Add new topic Subscribe to topic   


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.