Flash and ColdFusion

[Graham Pearson]

I am trying to intergrate flash and coldfusion and having abit trouble. I can create a newsfile.txt file and load it with the loadvariables function, however when I try to use the loadvariables with newsfile.cfm file to bring up the query with the requested news file it does not work.

Here is my .cfm file
<cfcontent type="application/x-www-urlform-encoded">
<cfheader name="pragma" value="no-cache">
<cfheader name="expires" value="#now()#">
<cfquery datasource="TechnologyWorkOrder" name="Get_NewsArticles" cachedwithin="#createtimespan(0, 0, 30, 0)#">
Select Article_Date, Article_Text, Article_Link, Article_Content
From News
</cfquery>

<CFOUTPUT>
<CFLOOP Query="Get_NewsArticles">
<CFSET Article_Date = #URLEncodedFormat(Get_NewsArticles.Article_Date)#>
&#Variables.Article_Date#&</CFLOOP></CFOUTPUT>

and my loadvariables line is
loadvariables ("newsinfo.cfm", _root);

When I view this in the debug window I get #Get_NewsArticles.Article_Date# as my _root.Article_Date variable, however when I display it in the browser window via the web server, It is blank.


Any ideas.

[Flash-db]

1)  It looks like their is an error either with your database connection or with the code - Because if you are getting "#Get_NewsArticles.Article_Date#" in the Article_Date it means that the code was not properly processed - or else you would get the date - if it's setup correctly (unless i'm reading it wrong).

2) If your not getting anything to show up in when running it online - either the cold fusion server is not working properly or their is an error in your code and the script is outputting that error instead of the correct string.

3)  Type in the URL to this CFM page in your web browser.  This will tell you the most.  The only thing that can be on that page is a simple string with something like:

Article_Date=The Article Date.

If their are any headers, html formatting, or errors output by the script it will not work.

If possible can you provide the Link to this CFM file online so we can check out the output.  Sometimes it's necessary to hit the 'View Source' button on the browser to make sure that thier is no hidden formatting that may be causing this error.

For example going to the URL  www.yoursite.com/newsinfo.cfm  will tell you basically all you need to know about this error or why it's not working.

[Graham Pearson]

After working on this for 3 days, I have finally learned how to get it to display, it has been alot of trial and errors. Now for the next step

1) I have a query that has returned 2 recordsets, now how do I pass all of the recordsets onto flash so it can be displayed in the flash movie

2) How can I make text scroll up one line at a time like in a credit section at the end of a movie. The text in the box is called Article_Content and would want this to scroll up line by line.