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

 Reusing Datasource

Print topic Send  topic

Author Message
kawuat

Posts: 13
Posted: 12/21/2008, 11:12 AM

I have a grid datasource that works just fine.

I am trying to integrate this rollover code to my grid utilizing the grids datasource.

My problem is that when I enable the code will populate the javascrip in the code below but then the grid is left empty.

My question is how do I reuse the grids datasource so that both the grid and javascript are populated from a single query

	  
  
		global $jscode;  
		global $ajstextcode;  
		global $notesdesc;  
		global $notesdesc1;  
		  
  		//START OF AJAX CODE	  
  		$ajstextcode = "";  
  		$linkroll = "";  
  		$htmlroll= "";  
    
  		//CREATE VARIABLES FOR ALL FIELDS TO BE LOADED,  ACTON DESCRIPTION, PROFILE, AND OFFER  
  		$ajstextcode = "<SCRIPT language=\"JavaScript1.2\" type=\"text/javascript\"> \n var FiltersEnabled = 0 \n";  
  		//add javascript code for calendar rollover information  
  
		$test = $TrackedCompany->DataSource->SQL;  
		echo $test;  
		die();  
  
		//echo $TrackedCompany->DataSource->Where. "<BR> ";  
		//echo $TrackedCompany->DataSource->Order. "<BR> ";  
		  
		$TrackedCompany->DataSource->Auto_Free = false;  
  
		$Result = $TrackedCompany->DataSource->next_record();  
  
  		if ($Result){  
  		 $alinkref =  $TrackedCompany->DataSource->f(COMP_ID);  
 		 $actdesc =  $TrackedCompany->DataSource->f(NEXT_ACT_DESC);  
 		 $prodesc =  $TrackedCompany->DataSource->f(TU_PROFILE);  
 		 $offdesc =  $TrackedCompany->DataSource->f(BUS_NEED);  
		 $tskcomp =  $TrackedCompany->DataSource->f(COMPANY_NAME);  
		 $tskst =  $TrackedCompany->DataSource->f(state_abbr);  
		 $tsktp =  $TrackedCompany->DataSource->f(TYPE_DESC);  
		 $tskrep =  $TrackedCompany->DataSource->f(LNAME);  
		 $notedesc =  $TrackedCompany->DataSource->f(NOTES_DATA);  
  
 		 $actdesc = ereg_replace("[\n\t\013\r ]+"," ",$actdesc);  
 		 $actdesc = ereg_replace('"','^',$actdesc);  
 		 $prodesc = ereg_replace("[\n\t\013\r ]+"," ",$prodesc);  
 		 $prodesc = ereg_replace('"','^',$prodesc);  
 		 $offdesc = ereg_replace("[\n\t\013\r ]+"," ",$offdesc);  
 		 $offdesc = ereg_replace('"','^',$offdesc);  
 		 $notedesc = ereg_replace("[\n\t\013\r ]+"," ",$notedesc);  
 		 $notedesc = ereg_replace('"','^',$notedesc);  
  
  
		$chars =230; // Change to the number of characters you want to display  
		$actdesc = (substr($actdesc,0,$chars));  
		$prodesc = (substr($prodesc,0,$chars));  
		$notedesc = (substr($notedesc,0,$chars));  
    
 		 $ajstextcode .= " Text[".$alinkref."]=[";		  
  		 $ajstextcode .= "\"".$tsktp." ".$tskst.", ".$tskcomp.", ".$tskrep."\",\"<b>Action Description: </b><div align='justify'>".$actdesc."<br><b>Profile: </b><div align='justify'>".$prodesc. "<br><b>Offer: </b><div align='justify'>".$offdesc."</div><b>Last Meeting: </b><div align='justify'>".$notedesc."</div>\"] \n";  
  
		while (  $TrackedCompany->DataSource->next_record() ){  
  
  		 $alinkref =  $TrackedCompany->DataSource->f(COMP_ID);  
 		 $actdesc =  $TrackedCompany->DataSource->f(NEXT_ACT_DESC);  
 		 $prodesc =  $TrackedCompany->DataSource->f(TU_PROFILE);  
 		 $offdesc =  $TrackedCompany->DataSource->f(BUS_NEED);  
		 $tskcomp =  $TrackedCompany->DataSource->f(COMPANY_NAME);  
		 $tskst =  $TrackedCompany->DataSource->f(state_abbr);  
		 $tsktp =  $TrackedCompany->DataSource->f(TYPE_DESC);  
		 $tskrep =  $TrackedCompany->DataSource->f(LNAME);  
		 $notedesc =  $TrackedCompany->DataSource->f(NOTES_DATA);  
  
  
 		 $actdesc = ereg_replace("[\n\t\013\r ]+"," ",$actdesc);  
 		 $actdesc = ereg_replace('"','^',$actdesc);  
 		 $prodesc = ereg_replace("[\n\t\013\r ]+"," ",$prodesc);  
 		 $prodesc = ereg_replace('"','^',$prodesc);  
 		 $offdesc = ereg_replace("[\n\t\013\r ]+"," ",$offdesc);  
 		 $offdesc = ereg_replace('"','^',$offdesc);  
 		 $notedesc = ereg_replace("[\n\t\013\r ]+"," ",$notedesc);  
 		 $notedesc = ereg_replace('"','^',$notedesc);  
  
  
		$chars =230; // Change to the number of characters you want to display  
		$actdesc = (substr($actdesc,0,$chars));  
		$prodesc = (substr($prodesc,0,$chars));  
		$notedesc = (substr($notedesc,0,$chars));  
  
 		$ajstextcode .= " Text[".$alinkref."]=[";		  
 		$ajstextcode .= "\"".$tsktp." ".$tskst.", ".$tskcomp.", ".$tskrep."\",\"<b>Action Description: </b><div align='justify'>".$actdesc."<br><b>Profile: </b><div align='justify'>".$prodesc. "<br><b>Offer: </b><div align='justify'>".$offdesc."</div><b>Last Meeting: </b><div align='justify'>".$notedesc."</div>\"] \n";  
 			}  
		}  
		  
  		$ajstextcode .= "\n Style[0]=[\"white\",\"black\",\"#4f5b68\",\"#f7f7f7\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",350,\"\",2,2,10,10,51,1,0,\"\",\"\"]";  
 		$ajstextcode .= "\n applyCssFilter() \n </SCRIPT>";  
  		// WRAP AROUND LINKS  
  		$TrackedCompany->DataSource->close();		  
    
  		//Assign generated Javascript and HTML code to respective labels  
  		$jscode->SetValue($ajstextcode);  
  
View profile  Send private message
mentecky

Posts: 321
Posted: 12/21/2008, 2:55 PM

kawuat,

I'm not sure I know enough to answer this, like where you are putting the code above, but try adding the following into the grid's Before Build Select event:

$TrackedCompany->DataSource->Auto_Free = false; 

Rick
_________________
http://www.ccselite.com
View profile  Send private message
jjrjr1


Posts: 942
Posted: 12/21/2008, 4:04 PM

Hi

I'm not exactly sure what your question is.

Are you expecting the code above to populate the Javascript and the grid form?

Seems to me the code you have here will only create the javascript.

Exactly what event is this code fired in. Before show?

Maybe try in the before show row event for the grid create the javascript from the fields in the row instead of opening another DB connection to do that.

Like I said, not sure what you are asking. Can you be a little more clear?

Have fun



_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
View profile  Send private message
kawuat

Posts: 13
Posted: 12/21/2008, 10:09 PM

To answer your question jjrjr1:

I have a grid "TrackedCompany" built with the CCS IDE that displays 9 of 18 fields from my mysql view.

I have a Label on my page set to HTML content and in my grids before show I have placed the custom code you see above. This code is loosesly bassed an a tutorial I found (will find the original and post later)

I would like this code to access my grid datasource and get the remianing fields to populate the javascript rollover.

My object here is to limit DB calls. I want to query the DB once when my grid loads and then access that remaing fields of the dataset for my rollover.

I hope this help clear things up


THE CODE BELOW IS MY CURRENT WORKING CODE. AS YOU CAN SEE I HAD TO INCOPORATE OTHER LOGIC FROM MY BEFOREBUILDSELECT IN HERE SO THAT IT PULLS THE SAME DATA AS MY GRID WHEN THE GRID IS SEARCHED/b]


  
  
			global $jscode;  
		global $ajstextcode;  
		global $notesdesc;  
		global $notesdesc1;  
		  
		$TrackDB = new clsDBreport();  
		$TrackLimit = 25;  
		$TrackingPage = CCGetParam(notes1Page);  
		  
		$TrackingWhere = " TRACK_DATE IS NOT NULL";   
		$search_key = CCGetFromGet("Tracker_Key",0);  
		  
			switch ($search_key){      
            	case 0:              
            	case 1:              
            		// GET DEFAULT TYPE AND STATE   
                         
            		$des_ss = CCGetSession("DES");  
               		$det_ss = CCGetSession("DET");  
              
					// GET SEARCH PARAMETERS  
            		$s_state = CCGetFromGet("s_Tracking_State",0);  
            		$s_type = CCGetFromGet("s_Tracking_Type",0);  
            		$s_name = CCGetFromGet("s_Tracking_Criteria");  
  
            		// SELECT DATA BASED ON AVAILABLE CRITERIA - COMPANY NAME  
            		if($s_state =='' && $s_type =='' && $s_name ==''){  
					$TrackingOrder.= " TrackingReport.NEXT_ACT_DATE ASC";  
             	    }else if($s_state == '255'){  
            		$TrackingWhere.= " AND TrackingReport.COMPANY_NAME >='". $s_name."' AND TrackingReport.TYPE_ID = " . $s_type . " AND TrackingReport.STATE_ID <> ". $s_state;  
            		$TrackingOrder.= "TrackingReport.NEXT_ACT_DATE ASC";  
            		}else{  
           			$TrackingWhere.= " AND TrackingReport.COMPANY_NAME >='". $s_name."' AND TrackingReport.TYPE_ID = " . $s_type . " AND TrackingReport.STATE_ID = ". $s_state;		  
            		$TrackingOrder.= " TrackingReport.NEXT_ACT_DATE ASC";  
            		}  
            		break;  
  
            	case 2:  
              
            		// GET DEFAULT TYPE AND STATE  
            		$des_brep = CCGetSession("DES");  
            		$det_brep = CCGetSession("DET");  
  
            		// GET SEARCH PARAMETERS  
            		$brep_state = CCGetFromGet("s_Tracking_State",0);  
            		$brep_type = CCGetFromGet("s_Tracking_Type",0);  
            		$brep_name = CCGetFromGet("s_Tracking_Criteria",0);  
              
            		// SELECT DATA BASED ON AVAILABLE CRITERIA - Business Developer  
					if($brep_state =='' && $brep_type =='' && $brep_name ==''){  
            		$TrackingOrder.= " TrackingReport.LAME, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else if($brep_state == '255'){  
   					$TrackingWhere.= " AND TrackingReport.BUS_REP IN ( SELECT USR_ID FROM users where LNAME LIKE '".$brep_name."%') AND TrackingReport.TYPE_ID = " . $brep_type . " AND TrackingReport.STATE_ID <> ". $brep_state;  
            		$TrackingOrder.= " LNAME, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else{  
   					$TrackingWhere.= " AND TrackingReport.BUS_REP IN ( SELECT USR_ID FROM users where LNAME LIKE '".$brep_name."%') AND TrackingReport.TYPE_ID = " . $brep_type . " AND TrackingReport.STATE_ID = ". $brep_state;  
            		$TrackingOrder.= " LNAME, TrackingReport.NEXT_ACT_DATE ASC";    
                     }  
 					break;  
                          
            	case 3:  
              
            		// GET DEFAULT TYPE AND STATE  
            		$des_lcnt = CCGetSession("DES");  
            		$det_lcnt = CCGetSession("DET");  
              
            		// GET SEARCH PARAMETERS  
            		$lcnt_state = CCGetFromGet("s_Tracking_State",0);  
            		$lcnt_type = CCGetFromGet("s_Tracking_Type",0);  
            		$lcnt_date = CCGetFromGet("s_Tracking_Criteria",0);  
            		$fmt_lcnt_date = CCFormatDate(CCParseDate($lcnt_date,array("mm","/","dd","/","yyyy")), array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss"));  
            		// SELECT DATA BASED ON AVAILABLE CRITERIA - LAST CONTACT DATE  
              
            		if($lcnt_state =='' && $lcnt_type =='' && $lcnt_date ==''){  
            		$TrackingOrder.= " TrackingReport.LCONT, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else if($fc_state == '255'){  
   					$TrackingWhere.= " AND TrackingReport.LCONT >= '". $fmt_lcnt_date ."' AND TrackingReport.TYPE_ID = " . $lcnt_type . " AND TrackingReport.STATE_ID <> ". $lfcnt_state;			  
            		$TrackingOrder.= " TrackingReport.LCONT, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else{  
   					$TrackingWhere.= " AND TrackingReport.LCONT >= '". $fmt_lcnt_date ."' AND TrackingReport.TYPE_ID = " . $lcnt_type . " AND TrackingReport.STATE_ID = ". $lcnt_state;			  
					$TrackingOrder.= " TrackingReport.LCONT, TrackingReport.NEXT_ACT_DATE ASC";    
            		}    
            		break;  
              
            	case 4:  
              
            		// GET DEFAULT TYPE AND STATE  
            		$des_nd = CCGetSession("DES");  
            		$det_nd = CCGetSession("DET");  
              
            		// GET SEARCH PARAMETERS  
            		$nd_state = CCGetFromGet("s_Tracking_State",0);  
            		$nd_type = CCGetFromGet("s_Tracking_Type",0);  
            		$nd_date = CCGetFromGet("s_Tracking_Criteria",0);  
            		$fmt_date = CCFormatDate(CCParseDate($nd_date,array("mm","/","dd","/","yyyy")), array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss"));  
              
            		// SELECT DATA BASED ON AVAILABLE CRITERIA - NEXT ACTION DATE  
            		if($nd_state =='' && $nd_type =='' && $nd_date ==''){  
            		$TrackingOrder.= " TrackingReport.NEXT_ACT_DATE ASC, TrackingReport.NEXT_ACT_DATE ASC";   
            		}else if($nd_state == '255'){  
   					$TrackingWhere.= " AND TrackingReport.NEXT_ACT_DATE >= '". $fmt_date ."' AND TrackingReport.TYPE_ID = " . $nd_type . " AND TrackingReport.STATE_ID <> ". $nd_state;			  
            		$TrackingOrder.= " TrackingReport.NEXT_ACT_DATE ASC, TrackingReport.NEXT_ACT_DATE ASC";   
            		}else{  
   					$TrackingWhere.= " AND TrackingReport.NEXT_ACT_DATE>= '". $fmt_date ."' AND TrackingReport.TYPE_ID = " . $nd_type . " AND TrackingReport.STATE_ID = ". $nd_state;			  
  					$TrackingOrder.= " TrackingReport.NEXT_ACT_DATE ASC, TrackingReport.NEXT_ACT_DATE ASC";   
            		}  
            		break;  
              
            	case 5:  
              
            		// GET DEFAULT TYPE AND STATE  
            		$des_cpi = CCGetSession("DES");  
            		$det_cpi = CCGetSession("DET");  
              
            		// GET SEARCH PARAMETERS  
            		$cpi_state = CCGetFromGet("s_Tracking_State",0);  
            		$cpi_type = CCGetFromGet("s_Tracking_Type",0);  
            		$cpi_idx = CCGetFromGet("s_Tracking_Criteria",0);  
              
            		// SELECT DATA BASED ON AVAILABLE CRITERIA - CLOSE PERCENTAGE  
            		if($cpi_state =='' && $cpi_type =='' && $cpi_idx ==''){  
            		$TrackingOrder.= " TrackingReport.CP_INDEX, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else if($fc_state == '255'){  
   					$TrackingWhere.= " AND TrackingReport.CP_INDEX >='". $cpi_idx ."' AND TrackingReport.TYPE_ID = " . $cpi_type . " AND TrackingReport.STATE_ID <> ". $cpi_state;			  
            		$TrackingOrder.= " TrackingReport.CP_INDEX, TrackingReport.NEXT_ACT_DATE ASC";    
            		}else{  
   					$TrackingWhere.= " AND TrackingReport.CP_INDEX >='". $cpi_idx ."' AND TrackingReport.TYPE_ID = " . $cpi_type . " AND TrackingReport.STATE_ID = ". $cpi_state;			  
            		$TrackingOrder.= " TrackingReport.CP_INDEX, TrackingReport.NEXT_ACT_DATE ASC";   
            		}break;  
            }  
  
		$sorter = CCGetFromGet("TrackedCompanyOrder","");  
		if(strlen($sorter) < 1){  
		  
		  
		$TrackingWhere = $TrackingWhere;   
		$TrackingOrder = $TrackingOrder;  
  
		}else{  
  
		$TrackingWhere = $TrackingWhere;  
  
		}  
  
		  
		$Tracking_SQL = "SELECT LNAME, COMP_ID, NEXT_ACT_DATE, NEXT_CONT_DATE, TRACK_DATE, NEXT_ACT_DESC, TU_PROFILE, TU_DECISION, BUS_NEED, FCONT, LCONT, BUS_REP, PR_REP_ID,".  
		" COMPANY_NAME, TYPE_ID, STATE_ID, EMP_HERE, SALES, CP_INDEX, state_abbr, NOTES_DATA, TYPE_DESC FROM TrackingReport LEFT JOIN users ON TrackingReport.BUS_REP =".  
		" users.USR_ID";  
		  
		$Tracking_SQL .=  " Where ". $TrackingWhere;  
		$Tracking_SQL .=  " Order by ". $TrackingOrder;  
		  
		if($TrackingPage < 2){  
		$Tracking_SQL .= " LIMIT 0,25";				   
		} else {  
		$TrackingLimit = (((($TrackingPage - 1) * 25) + TrackingLimit) - 25);  
		$Tracking_SQL .= " LIMIT ". $TrackingLimit. ",25";		  
		}  
		//echo $Tracking_SQL;  
		//die();  
		  
  		//START OF AJAX CODE	  
  		$ajstextcode = "";  
  		$linkroll = "";  
  		$htmlroll= "";  
    
  		$TrackDB->query($Tracking_SQL);  
		$items = $TrackDB->num_rows(COMP_ID);  
		$i = 1;  
  
  

Cont below...
View profile  Send private message
kawuat

Posts: 13
Posted: 12/21/2008, 10:09 PM

  
  
    
  		//CREATE VARIABLES FOR ALL FIELDS TO BE LOADED,  ACTON DESCRIPTION, PROFILE, AND OFFER  
  		$ajstextcode = "<SCRIPT language=\"JavaScript1.2\" type=\"text/javascript\"> \n var FiltersEnabled = 0 \n";  
  		//add javascript code for calendar rollover information  
		  
		$Result = $TrackDB->next_record();  
		  
		//	echo $Result;  
		//die();  
  
  		if ($Result){  
  		 $alinkref =  $TrackDB->f(COMP_ID);  
		 $taskdate1 = $TrackDB->f(NEXT_ACT_DATE);  
		 $taskdate = CCFormatDate(CCParseDate($taskdate1,array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss")), array("mm","/","dd","/","yyyy"));  
         $lstmeet1 = $TrackDB->f(NEXT_CONT_DATE);  
		 $lstmeet = CCFormatDate(CCParseDate($lstmeet1,array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss")), array("mm","/","dd","/","yyyy"));   
		 $numemp = $TrackDB->f(EMP_HERE);  
		 $numemp = number_format($numemp);  
		 $sales = $TrackDB->f(SALES);  
		 $sales = number_format($sales, 0,".",",");  
 		 $actdesc =  $TrackDB->f(NEXT_ACT_DESC);  
 		 $prodesc =  $TrackDB->f(TU_PROFILE);  
 		 $offdesc =  $TrackDB->f(BUS_NEED);  
		 $tskcomp =  $TrackDB->f(COMPANY_NAME);  
		 $tskst =  $TrackDB->f(state_abbr);  
		 $tsktp =  $TrackDB->f(TYPE_DESC);  
		 $tskrep =  $TrackDB->f(LNAME);  
		 $notedesc =  $TrackDB->f(TU_DECISION);  
  
 		 $actdesc = ereg_replace("[\n\t\013\r ]+"," ",$actdesc);  
 		 $actdesc = ereg_replace('"','^',$actdesc);  
 		 $prodesc = ereg_replace("[\n\t\013\r ]+"," ",$prodesc);  
 		 $prodesc = ereg_replace('"','^',$prodesc);  
 		 $offdesc = ereg_replace("[\n\t\013\r ]+"," ",$offdesc);  
 		 $offdesc = ereg_replace('"','^',$offdesc);  
 		 $notedesc = ereg_replace("[\n\t\013\r ]+"," ",$notedesc);  
 		 $notedesc = ereg_replace('"','^',$notedesc);  
  
  
		$chars =230; // Change to the number of characters you want to display  
		$actdesc = (substr($actdesc,0,$chars));  
		$prodesc = (substr($prodesc,0,$chars));  
		$notedesc = (substr($notedesc,0,$chars));  
  		$offdesc = (substr($offdesc,0,$chars));  
  
 		 $ajstextcode .= " Text[".$alinkref."]=[";		  
  		 $ajstextcode .= "\"".$tsktp." ".$tskst.", ".$tskcomp.", ".$tskrep."\",\"<b>Sales: $</b>".$sales."<br><b>Employees: </b>".$numemp."<br><b>Last Meeting: </b>".$lstmeet."<br><b>Task Date: </b>".$taskdate."<br><br><b>Task: </b><div align='justify'>".$actdesc."<br><b>Profile: </b><div align='justify'>".$prodesc. "<br><b>Offer: </b><div align='justify'>".$offdesc."</div><b>Opportunity: </b><div align='justify'>".$notedesc."</div>\"] \n";  
		  
		while (  $TrackDB->next_record() ){  
  
  		 $alinkref =  $TrackDB->f(COMP_ID);  
		 $taskdate1 = $TrackDB->f(NEXT_ACT_DATE);  
		 $taskdate = CCFormatDate(CCParseDate($taskdate1,array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss")), array("mm","/","dd","/","yyyy"));  
         $lstmeet1 = $TrackDB->f(NEXT_CONT_DATE);  
		 $lstmeet = CCFormatDate(CCParseDate($lstmeet1,array("yyyy","-","mm","-","dd"," ","HH",":","nn",":","ss")), array("mm","/","dd","/","yyyy"));         
		 $numemp = $TrackDB->f(EMP_HERE);  
		 $numemp = number_format($numemp);  
		 $sales = $TrackDB->f(SALES);  
		 $sales = number_format($sales, 0,".",",");  
 		 $actdesc =  $TrackDB->f(NEXT_ACT_DESC);  
 		 $prodesc =  $TrackDB->f(TU_PROFILE);  
 		 $offdesc =  $TrackDB->f(BUS_NEED);  
		 $tskcomp =  $TrackDB->f(COMPANY_NAME);  
		 $tskst =  $TrackDB->f(state_abbr);  
		 $tsktp =  $TrackDB->f(TYPE_DESC);  
		 $tskrep =  $TrackDB->f(LNAME);  
		 $notedesc =  $TrackDB->f(TU_DECISION);  
		  
  
 		 $actdesc = ereg_replace("[\n\t\013\r ]+"," ",$actdesc);  
 		 $actdesc = ereg_replace('"','^',$actdesc);  
 		 $prodesc = ereg_replace("[\n\t\013\r ]+"," ",$prodesc);  
 		 $prodesc = ereg_replace('"','^',$prodesc);  
 		 $offdesc = ereg_replace("[\n\t\013\r ]+"," ",$offdesc);  
 		 $offdesc = ereg_replace('"','^',$offdesc);  
 		 $notedesc = ereg_replace("[\n\t\013\r ]+"," ",$notedesc);  
 		 $notedesc = ereg_replace('"','^',$notedesc);  
  
  
		$chars =230; // Change to the number of characters you want to display  
		$actdesc = (substr($actdesc,0,$chars));  
		$prodesc = (substr($prodesc,0,$chars));  
		$notedesc = (substr($notedesc,0,$chars));  
		$offdesc = (substr($offdesc,0,$chars));  
  
 		$ajstextcode .= " Text[".$alinkref."]=[";		  
 		$ajstextcode .= "\"".$tsktp." ".$tskst.", ".$tskcomp.", ".$tskrep."\",\"<b>Sales: $</b>".$sales."<br><b>Employees: </b>".$numemp."<br><b>Last Meeting: </b>".$lstmeet."<br><b>Task Date: </b>".$taskdate."<br><br><b>Task: </b><div align='justify'>".$actdesc."<br><b>Profile: </b><div align='justify'>".$prodesc. "<br><b>Offer: </b><div align='justify'>".$offdesc."</div><b>Opportunity: </b><div align='justify'>".$notedesc."</div>\"] \n";  
 			}  
		}  
		  
  		$ajstextcode .= "\n Style[0]=[\"white\",\"black\",\"#4f5b68\",\"#f7f7f7\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",350,\"\",2,2,300,10,51,1,0,\"\",\"\"]";  
 		$ajstextcode .= "\n applyCssFilter() \n </SCRIPT>";  
  		// WRAP AROUND LINKS  
  		$TrackDB->close();		  
    
  		//Assign generated Javascript and HTML code to respective labels  
  		$jscode->SetValue($ajstextcode);  
View profile  Send private message
jjrjr1


Posts: 942
Posted: 12/22/2008, 9:35 AM

Hi again.

I mignt be over simplifying this, but is the only thing you want to do is get the last 9 of the field not retrieved by the existing grid so you can put all of them in your javascript, why don;t you just have the CCS grid component get them all for you?

Like just add the other 9 components to the grid. Make them text boxes with the type of hidden. You do not need grid builder to do this after you have already cerated the grid. Simply add a row to the tbale in the grid. of a colomn what ever. Be sure you remove the   from the newly created volomn or row. (CCS always add that to a new row or colomn). The in that row or column add new text boxes and assign the proper datafield to them. Then set them as hidden.

Now you have all the data fields into your grid without having to do an additional database lookup. And the hidden ones do not display on your page but can be mainpulated by php or html.

Then I would guess you could do your javascript generation in the before show or before show row, which ever works for you, and have access to all the data elements for that table.

Did I over simplify that or do you still see a reason to do a separate database lookup??

Let me know.

John

_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
View profile  Send private message
jjrjr1


Posts: 942
Posted: 12/24/2008, 3:53 AM

Hi

Just wondering if you still need help with this or did I misunderstand your requirement??



_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com
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.