Are you saying you just want to show the results of your query in the datagrid, or something more complex?
Code it looks like you just want to show the results of the query. If that's the case check out: Flex 1.5: http://www.richinternet.de/blog/index.cfm?entry=831FE26E-0D70-9C2D-2549E1D1978CF1B0 http://www.cflex.net/showfiledetails.cfm?ObjectID=303 http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=1019 Flex 2: http://www.drisgill.com/index.cfm/2005/10/21/Flex-2-and-ColdFusion-Talking-Pt2 http://www.forta.com/blog/index.cfm/2006/2/1/Getting-Started-With-ColdFusion-And-Flex-Enterprise-Services http://www.forta.com/blog/index.cfm/2006/2/1/ColdFusion-Flex-2-Sample-Application http://www.forta.com/blog/index.cfm?mode=entry&entry=A61BD24F-3048-80A9-EFAA1ABB13F5EDDF http://www.dopejam.com/shownewsitem.cfm?NewsID=208&ChannelID=1 Or are you saying fld_bagentId1, fld_sagentId1 contain the lists themselves (like a comma separated list of values), that you want to output on a line by line basis? Jeremy Rottman wrote: > In my cfc I have the function below. It returns a list from two > different database fields. The issue I have is that I want to return > this to a datagrid. I have tried everything I could think of, but for > some reason, I cant get the data grid to display the returned vaules > of hte list in seperate rows in the datagrid. Can someone give me an > example on how I can do this. > > CFC. > > <cffunction name="quAdminUpdateAgent" access="remote" > returntype="array" output="false"> > <cfargument name="fld_fileNum" type="string" > required="no" /> > <cfargument name="bagent" type="string" required="no" /> > <cfargument name="sagent" type="string" required="no" /> > <cfquery name="check" > datasource="#application.dsn#"> > select fld_fileNum, fld_bagentId1, fld_sagentId1 > from tbl_smartPanel_propInfo_Sale > where fld_fileNum = '#arguments.fld_fileNum#' > </cfquery> > <cfquery name="updateAgent" > datasource="#application.dsn#"> > update tbl_smartPanel_propInfo_Sale > set > fld_sagentId1 = > '#listAppend(check.fld_sagentId1, > arguments.sagent)#', > fld_bagentId1= > '#listAppend(check.fld_bagentId1, arguments.bagent)#' > where fld_fileNum = '#arguments.fld_fileNum#' > </cfquery> > > <cfquery name="ReturnAgents" > datasource="#application.dsn#"> > select fld_bagentId1, fld_sagentId1 > from tbl_smartPanel_propInfo_Sale > where fld_fileNum = > '#arguments.fld_fileNum#' > </cfquery> > > <cfreturn ReturnAgents /> > </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 > > > > > > > > -- 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/
