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