RE: [CFCDev] Flash Recordset

[James Johnson]

Great. Glad it worked for you. To answer your other question, I really don't
know. This code was from an app I did that was all contained on one frame. 

Figleaf.com has a very busy set of Flash newsgroups. If you go to
chattyfig.figleaf.com and subscribe, I'm sure you'll get the answer there.

James

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


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).

----------------------------------------------------------
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).