Nevemind this question.... because I had no height set on the datagrid it _looked_ like there were extra records returned, but they were just blank rows in the datagrid that were not filled in with data. Once I set a height it made sense what was going on.
Duh! -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Chad Gray Sent: Wednesday, March 05, 2008 10:50 AM To: [email protected] Subject: [flexcoders] datagrid and extra rows I am returning a query from a CFC to a datagrid and I get extra blank rows in the datagrid. I don't see a rhyme or reason for the number of extra rows either. Some queries return 5 records with 3 extra rows and some return 4 records with 3 extra rows. I double checked the query and it does not return any blank records. Is there a better way of populating the datagrid? Here is my code that is taking the returned query and populating the datagrid. private function submitJob():void { roGetJobs.getJob(); } private function onGetJobResult(re:ResultEvent):void { dgJob.dataProvider = ArrayCollection(re.result); } private function onGetJobFault(fe:FaultEvent):void { Alert.show(fe.fault.message); } <mx:RemoteObject id="roGetJobs" destination="ColdFusion" source="com.login" endpoint="http://localhost/flex2gateway/"; result="onGetJobResult(event)" fault="onGetJobFault(event)"> <mx:method name="getJob"> <mx:arguments> <jobNum>{jobNum.text}</jobNum> </mx:arguments> </mx:method> </mx:RemoteObject> <mx:TextInput x="94" y="204" id="jobNum"/> <mx:Button x="119" y="234" label="Get Job" click="submitJob()" id="getJobButton"/> <mx:DataGrid id="dgJob" x="10" y="264" width="100%"> <mx:columns> <mx:DataGridColumn headerText="Job Number" dataField="JobNum"/> <mx:DataGridColumn headerText="Job Name" dataField="JobName"/> <mx:DataGridColumn headerText="Job Description" dataField="JobDescription"/> <mx:DataGridColumn headerText="Job Ticket ID" dataField="JobTicketID"/> </mx:columns> </mx:DataGrid> Here is the CFC function: <cffunction name="getJob" returnType="query" output="no" access="remote"> <cfargument name="jobNum" type="numeric" required="yes"> <cfset var getJobInfo = ""> <cfquery datasource="data" name="getJobInfo"> SELECT Job.JobNum, Job.JobName, job.JobDescription, JobTicket.JobTicketID FROM Job, JobTicket WHERE job.JobNum = #arguments.jobNum# AND Job.JobNum = JobTicket.Jobnum </cfquery> <cfreturn getJobInfo> </cffunction> -- 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
