fld_bagentId1 contains one csv list and fld_sagentId1 contains another csv list. And I want to ouput on a line by line basis.
--- In flexcoders@yahoogroups.com, Tariq Ahmed <[EMAIL PROTECTED]> wrote: > > 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/