Re: [flexcoders] Re: DG Display with data returned as a list.

Thu, 16 Feb 2006 16:27:26 -0800

Personally I do as much up front work in CF as I can, mostly because I'm more familiar with CF than I am Flex, and manipulating data in CF is just so damn easy... .:)

Making some assumptions here, but the basic idea something like:

<cfset returnArray = arrayNew(1)>
<cfset completeList = ReturnAgents.fld_bagentId1 & "," & ReturnAgents.fld_sagentId1>

<cfloop from="1" to="#ListLen(completeList)#" index="NDX">
    <cfset returnArray[ndx] = ListGetAt(ReturnAgents.fld_bagentId1,NDX)>
</cfloop>

<cfreturn returnArray>

Or if it's a pair of lists that go hand in hand.. maybe something like:

<cfset returnArray = arrayNew(1)>

<cfloop from="1" to="#ListLen(ReturnAgents.fld_bagentId1)#" index="NDX">
    <cfset returnArray[ndx] = structNew()>
    <cfset returnArray[ndx].bagent = ListGetAt(ReturnAgents.fld_bagentId1,NDX)>
    <cfset returnArray[ndx].sagent = ListGetAt(ReturnAgents.fld_sagentId1,NDX)>
</cfloop>

<cfreturn returnArray>


Jeremy Rottman wrote: 
fld_bagentId1 contains one csv list and fld_sagentId1 contains another
csv list. And I want to ouput on a line by line basis.

  
		<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



SPONSORED LINKS
Web site design development Computer software development Software design and development
Macromedia flex Software development best practice

YAHOO! GROUPS LINKS



Reply via email to