show coldfusion's query results with actionscript

  • futi
  • Born
  • Born
  • futi
  • Posts: 2

Post 3+ Months Ago

i have a book whose author is Ben Forta.
i've looked for getting query results for ActionScript but I don't understand it. It is a bit confuse.

in coldfusion there is no problem about getting query result, writing query result. But, when i wanna to send my queries to actionscript i encounter a problem: "undefined"

this is mycoldfusion code:
<cfquery name="get_content_for_flash" datasource="#dsn#">
SELECT * FROM CONTENT WHERE CONTENT_ID = #attributes.cntid#
</cfquery>
<cfset FLASH.result = get_content_for_flash>

Actionscript code :

thisText = new LoadVars();
var record = result.getItemAt(0);

thisText.onLoad = function(success) {
if (success) {
TextHolder.text = record.CONT_BODY
}
};

what can i do?
help please..
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Jaw
  • Graduate
  • Graduate
  • User avatar
  • Posts: 132
  • Loc: Minneapolis, MN

Post 3+ Months Ago

I would suggest getting your results using CFCs (Cold Fusion Components)

The CFC is a web service and you can use the web service component in flash to trigger and return results from the CFC.

http://tutorial348.easycfm.com/

http://tutorial469.easycfm.com/

Those two links should get you pointed in the right direction. It may look a little daunting at first but once you know how to put them together it's easy to get any results in to flash.

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 15 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.