That worked. It means that query object/recordset in flash holds ITEMS array, which holds columns as array elements and you can refer to them with their index value. Also in your code I see that you're creating text fields. How do you create text fields on the fly on different frames? Do you need to prefix createTextField() with the frame name?
Thanks for your help, I really appreciate that. -----Original Message----- From: James Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:05 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] Flash Recordset Hello, Heres a couple of snippets from something I've done. After you make your call to the component "pageInfo.getBodyText()", a "result" is sent back, so you need another function to handle the returned results. pageInfo.getPromptText(1) --> getPromptText_Result(result){} HTH, James Component ----------- <cfcomponent> <cffunction access="remote" name="getPromptText" output="false" returntype="query"> <cfargument name="pageID" type="string" required="true"> <cfquery name="rsPrompt" datasource="testing4MX"> SELECT * FROM Prompts WHERE PageID = #pageID# </cfquery> <cfreturn #rsPrompt#> </cffunction> </cfcomponent> ActionScript ------------ function setPageUp(){ pageInfo.getPromptText(1); } /* Prompt Text functions. Creates Prompt field and sets properties based on database. */ function getPromptText_Result(result){ if (result.items[0].PromptText != ""){ x=result.items[0].xPos; y=result.items[0].yPos; txt=result.items[0].PromptText; // set up the text fields base properties _root.createTextField("prompt",_root.promptDepth,x,y,300,200); prompt.multiline=true; prompt.wordWrap=true; prompt.border=false; prompt.selectable=false; // set up the prompt text formatting pFormat = new TextFormat(); pFormat.color=result.items[0].pColor; pFormat.font = result.items[0].pFont; pFormat.size = result.items[0].fontSize; prompt.text = txt; // need to set formatting AFTER the text has been set. prompt.setTextFormat(pFormat); } } -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mehdi, Agha Sent: Tuesday, March 18, 2003 1: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 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
smime.p7s
Description: S/MIME cryptographic signature
"WorldSecure <littler.com>" made the following annotations on 03/18/2003 03:03:47 PM ------------------------------------------------------------------------------ ---- 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 ==============================================================================
