Groups | Blog | Home
all groups > macromedia flash flash remoting > august 2004 >

macromedia flash flash remoting : Display Recordset in a Flash Application


ba_franco
8/4/2004 7:51:00 PM
Hi !
I?m using Flash Remoting and i get a recordset from a web service
Well, the result structure is:

->results: .Net DataSet (array) [optional]
-[n] : data (Object)

The Network Debbuger brings to me:
(CatID and Desc are the record fields from my table where web service do a SQL
SELECT command)

DebugId: 0
EventType: "Result"
MovieUrl: "file:///C|/Inetpub/wwwroot/sisapre/testing_ws.swf"
Protocol: "http"
Source: "Client"
Time: 1091648851592
Date (object #1)
....."Wed Aug 4 16:47:31 GMT-0300 2004"
Result (object #2)
.....Table (object #3)
..........length: (undefined)
..........mRecordsAvailable: 3
..........serverInfo: (undefined)
..........uniqueID: 3
..........items (object #4)
...............[0] (object #5)
....................CatID: 1
....................Desc: "Home"
....................__ID__: 0
...............[1] (object #6)
....................CatID: 2
....................Desc: "Professional"
....................__ID__: 1
...............[2] (object #7)
....................CatD: 3
....................Desc: "Enterprise"
....................__ID__: 2
..........mTitles (object #8)
...............[0]: "CatID"
...............[1]: "Desc"
..........views (object #9)
...............No properties

I can?t show the result.
tries:
trace(result) - Undefined
trace(result.items[1].CatID) - Undefined

thanks
barbara franco

derobinson
8/5/2004 2:00:52 AM
I think you have to scope the result with the connector instance name like this:

myConnector.result......

See if that works for you.
database_monkey
8/5/2004 5:31:33 PM
the results are stored in a property called "result" of the variable. So, if
you have a function like this.

function onResult(result:ResultEvent):Void {

// results are stored in result property of variable
var data:Object = result.result;
.
.
.
}
ba_franco
8/6/2004 5:19:19 PM
i tried "var data:Object = result.result", but it keeps displaying undefined.
How can i get the fields CatID and Description using Object ?

In NetConnection Debugger, the result appears like that: {Table [object
Object]}

thanks
barbara
ba_franco
8/6/2004 5:19:52 PM
i tried "var data:Object = result.result", but it keeps displaying undefined.
How can i get the fields CatID and Description using Object ?

In NetConnection Debugger, the result appears like that: {Table [object
Object]}

thanks
barbara
AddThis Social Bookmark Button