"Tracy Spratt" <[EMAIL PROTECTED]> wrote: > > So the selected item in the combobox contains the key/filter value for > the php query?
Thats true Tracy. > > > > In the change event of the combo, invoke send() on the HTTPService, > passing in the key(s). In a result handler function, assign the > returned data to the dataProvider of the DataGrid and chart.. I have tried it, without luck. When I do that, my combobox end up turning empty. I would post my code below. <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"; layout="absolute"> <mx:HTTPService id="quarterRequest" url="http://x.x.x.x/flex/constants.php"; useProxy="false" method="GET"> </mx:HTTPService> <mx:HTTPService id="quarterzRequest" url="http://x.x.x.x/flex/constants-1.php"; useProxy="false" method="POST"> <mx:request xmlns=""> <selectedqtr> {Selectedqrtr.text} </selectedqtr> </mx:request> </mx:HTTPService> <mx:Script> <![CDATA[ private function send_data():void { quarterzRequest.send(); } ]]> </mx:Script> <mx:ComboBox id="quarterz" prompt="Select quarter" dataProvider="{quarterRequest.lastResult.auditinfo.quarters.quarter}" labelField="quarter" x="878" y="19" width="116" creationComplete="quarterRequest.send()" change="send_data()"></mx:ComboBox> <mx:DataGrid x="19.5" y="67" id="FPFirstdg" width="705" height="149" dataProvider="{quarterzRequest.lastResult.selectedauditinfo.microsoft}"> <mx:columns> <mx:DataGridColumn headerText="Quarter" dataField="currentqtr"/> <mx:DataGridColumn headerText="OS" dataField="os"/> <mx:DataGridColumn headerText="Servers" dataField="msnrows"/> <mx:DataGridColumn headerText="High" dataField="msnhigh"/> <mx:DataGridColumn headerText="Medium" dataField="msnmed"/> <mx:DataGridColumn headerText="Low" dataField="msnlow"/> </mx:columns> </mx:DataGrid> <mx:Label id="Selectedqrtr" text="{quarterz.selectedItem}" visible="false"> </mx:Label> </mx:Application> PHP code for the cosntants-1.php is as follows: <?php $link = mysql_connect('localhost','user','password') or die ('Could not connect: ' . mysql_error()); $connected = mysql_select_db('xyz') or die( 'Unable to select database'); $return ="<selectedauditinfo>"; $return .="<microsoft>"; $return .="<currentqtr>".$_POST['selectedqtr']."</currentqtr>"; $return .="<os> Microsoft </os>"; $query = 'SELECT DISTINCT host FROM quarters WHERE quarter="'.$_POST['selectedqtr'].'" and os="msft"'; $msnresult = mysql_query($query) or die ('Query failed: ' . mysql_error()); $msnum_rows_SRVRS = mysql_num_rows($msnresult); $return .="<msnrows>".$msnum_rows_SRVRS."</msnrows>"; $query = 'SELECT DISTINCT host FROM results WHERE r="3" and quarter="'.$_POST['selectedqtr'].'" and os="msft" and falsepos="N"'; $msnresult = mysql_query($query) or die ('Query failed: ' . mysql_error()); $msnum_rows_sHIGH = mysql_num_rows($msnresult); $return .="<msnhigh>".$msnum_rows_sHIGH."</msnhigh>"; $query = 'SELECT DISTINCT host FROM results WHERE r="2" and quarter="'.$_POST['selectedqtr'].'" and os="msft" and falsepos="N"'; $msnresult = mysql_query($query) or die ('Query failed: ' . mysql_error()); $msnum_rows_sMED = mysql_num_rows($msnresult); $return .="<msnmed>".$msnum_rows_sMED."</msnmed>"; $query = 'SELECT DISTINCT host FROM results WHERE r="1" and quarter="'.$_POST['selectedqtr'].'" and os="msft" and falsepos="N"'; $msnresult = mysql_query($query) or die ('Query failed: ' . mysql_error()); $msnum_rows_sLOW = mysql_num_rows($msnresult); $return .="<msnlow>".$msnum_rows_sLOW."</msnlow>"; $return .="</microsoft></selectedauditinfo>"; } print($return) ?> As I am quite a novice to Flex, I am sure I must have made some kind of newbie mistake. Frustrating part is , though it looks quite simple, I was unable to locate my mistakes. I appreciate you taking time out for helping me. Thanks
