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
<*> 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/
