Hi Tarik,
As you probably noticed, I primarily used your excellent example from
your blog. Thanks for the head start. It has really helped.
I changed the doResult function as you specified and the error
disappeared but the query still didn't return any results. I looked
at the bpurcell example and he converts his record set into an
array. This makes sense except his version seems to be using Web
Services. Nevertheless, it looks like I need to bind something to
the data provider attribute of the DataGrid...I just don't know how.
Here are the edits to my code and the CFC:
MXML:
private function doResult(event:Object):Void{
output.dataProvider = event.result._items;
}
<mx:DataGrid id="output" width="520" wordWrap="true">
<mx:columns>
<mx:Array>
<mx:DataGridColumn width="200" headerText="Update Form"
columnName="FUNCTION"/>
<mx:DataGridColumn width="320" headerText="Description"
columnName="DESCRIPTION"/>
</mx:Array>
</mx:columns>
</mx:DataGrid>
CFC:
<cfcomponent>
<cffunction name="GetUpdateAuthorization" access="remote"
returntype="query">
<cfargument name="AuthorizedUserId" type="string" required="yes">
<CFSTOREDPROC PROCEDURE="spUpdateAuthorization" DATASOURCE="Dev">
<CFPROCPARAM DBVARNAME="AuthorizedUserId" TYPE="IN"
VALUE="#Arguments.AuthorizedUserId#" CFSQLTYPE="CF_SQL_CHAR">
<CFPROCPARAM DBVARNAME="CaseFlag" TYPE="IN" VALUE="No"
CFSQLTYPE="CF_SQL_CHAR">
<CFPROCPARAM DBVARNAME="CourtOrderAvailableFlag" TYPE="IN"
VALUE="No" CFSQLTYPE="CF_SQL_CHAR">
<CFPROCRESULT NAME="qGetUpdateAuthorization">
</CFSTOREDPROC>
<cfreturn qGetUpdateAuthorization>
</cffunction>
</cfcomponent>
Thanks,
Darius
--
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/
