RE: [CFCDev] Flash Recordset

[Jeff Battershall]

Title: Message

You have to apply the recordset methods which are covered in the reference material.

 

1) use recordset.getLength() to get the number of records.  This can then be used to set up a loop.

2) use recordset.getItemAt(rownumber) to retreive a row.

3) individual rows can be accessed as structs, with column names as keys.

 

example below outputs all rows and column values for recordset myRS:

 

numRecs = myRS.getLength;

arrCols = myRS.getColumnNames();

numCols = arrCols.length;

 

(for i=0;i<numRecs;i++) {

    rec = myRS.getItemAt(i);

    for (j=0;j<numCols;j++) {

        trace("Column " + arrCols[j] + " value = " + rec[arrCols[j]]);

    }

}

 

HTH,

 

Jeff

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mehdi, Agha
Sent: Tuesday, March 18, 2003 4:35 PM
To: '[EMAIL PROTECTED]'
Subject: [CFCDev] Flash Recordset

Hi all,
I am working on a demo application and it's my first time doing Flash Remoting. I have tried everything I could think of but I can't display the results fetched from CF components in the flash movie. I can read the column names of the query returned from the component but I can't figure out the way to retrieve the data from those columns. Any ideas on how to get the records from the recordset inside flash?

Thanks

                          
Agha I. Mehdi
Web Developer
Littler Mendelson
Work: 415-288-6362
Cell: 510-364-5298  

----
This email may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.

To reply to our email administrator directly, send an email to
[EMAIL PROTECTED]

Littler Mendelson, P.C.
http://www.littler.com