See http://www.cflex.net/showfaq.cfm?Object=faq&channelID=1&faqtype=&default fields=&defaultValues=#Question373 Tracy
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of juyalmanu Sent: Friday, July 29, 2005 3:39 PM To: [email protected] Subject: [flexcoders] Datagrid I am having a strange problem in populating datagrid.. I am able to populate the datagrid if there are more than 1 records. However if there is just 1 record it is not displayed in the datagrid. After checking I found out that the call to database and retrieval of records are working fine. There is problem with populating datagrid only if only single record is retrieved. any suggestion?? what is going wrong Please find below the relevant code snippets... <mx:Script> <![CDATA[ function queryByName(){ customer_srv.send({query_type:'getcustomer', custfname: txtfname.text, custlname: txtlname.text}); } ]]> </mx:Script> <mx:HTTPService id="customer_srv" url="xxxxxxx.php" fault="faultHandler(event.fault.faultstring, event.fault.faultcode)" result="resultHandler(event)" method="POST" showBusyCursor="true" useProxy="false" /> <mx:Panel id ="adminpanel" width="877" horizontalAlign="center"> <mx:Grid> <mx:GridRow> <mx:GridItem> <mx:Label text="First Name" /> </mx:GridItem> <mx:GridItem> <mx:Label text="Last Name"/> </mx:GridItem> </mx:GridRow> <mx:GridRow> <mx:GridItem> <mx:TextInput id="txtfname" /> </mx:GridItem> <mx:GridItem> <mx:TextInput id="txtlname"/> </mx:GridItem> </mx:GridRow> <mx:GridRow> <mx:GridItem> </mx:GridItem> <mx:GridItem verticalAlign="middle" horizontalAlign="right"> <mx:Button label="Button" click="queryByName()"/> </mx:GridItem> </mx:GridRow> </mx:Grid> //DATA GRID STARTS HERE <mx:DataGrid id="customergrid" dataProvider="{customer_srv.result.customers.customer}" editable="true"> <mx:columns> <mx:Array> <mx:DataGridColumn editable="false" headerText="Customer ID" columnName="customerid" /> <mx:DataGridColumn editable="false" headerText="Session ID" columnName="sessid" /> <mx:DataGridColumn editable="false" headerText="Date" columnName="orderdate" /> <mx:DataGridColumn editable="false" headerText="Time" columnName="ordertime" /> <mx:DataGridColumn headerText="First Name" columnName="customerfname"/> <mx:DataGridColumn headerText="Last Name" columnName="customerlname" /> <mx:DataGridColumn headerText="Contact F Name" columnName="contactfname" /> <mx:DataGridColumn headerText="Contact L Name" columnName="contactlname" /> <mx:DataGridColumn headerText="Email" columnName="contactemail" /> <mx:DataGridColumn headerText="Phone" columnName="contactphone" /> </mx:Array> </mx:columns> </mx:DataGrid> </mx:Panel> ///PHP FUNCTION function getCustomer(){ $firstname=$_POST['custfname']; $lastname=$_POST['custlname']; $fname=trim($firstname); $lname=trim($lastname); $conn = mysql_connect("xxx.xxx.xxx.xxx", 'xxxxxx', "xxxxxxx") or die("Could not connect to MySQL"); mysql_select_db("xxx",$conn)or die ("could not open db".mysql_error ()); $query = "SELECT C.custID, S.sessionID, C.custFName, C.custLName, C.contFName, C.contLName,C.contEmail, C.contPhone, C.custDepartment, C.custCollege, S.indate, S.intime FROM session as S, customer as C WHERE C.custFName='$fname' and C.custLName='$lname' and S.custID = C.custID ORDER BY C.custID"; $result = mysql_query($query, $conn) or die(mysql_error()); echo "<customers>\n"; while ($row = mysql_fetch_array($result)){ echo "<customer>\n"; echo "<customerid>".$row['custID']."</customerid>\n"; echo "<sessid>".$row['sessionID']."</sessid>\n"; echo "<customerfname>".$row['custFName']."</customerfname>\n"; echo "<customerlname>".$row['custLName']."</customerlname>\n"; echo "<contactfname>".$row['contFName']."</contactfname>\n"; echo "<contactlname>".$row['contLName']."</contactlname>\n"; echo "<contactemail>".$row['contEmail']."</contactemail>\n"; echo "<contactphone>".$row['contPhone']."</contactphone>\n"; echo "<orderdate>".$row['indate']."</orderdate>\n"; echo "<ordertime>".$row['intime']."</ordertime>\n"; echo "<department>".$row['custDepartment']."</department>\n"; echo "<college>".$row['custCollege']."</college>\n"; echo "</customer>\n"; } echo "</customers>"; mysql_close($conn); } -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hbs2r8g/M=362329.6886308.7839368.1510227/D=groups/S=1705007207:TM/Y=YAHOO/EXP=1122692311/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
