How do I pass database records to flash from a cfm page?

[d0jk03m]

I downloaded a flash login setup and have been trying to revise it to my specific needs.



I have the login function working in that when they enter a valid username and password, they are directed to the correct frame in flash.



What I want to do is for a specific field record from my Access database to be diplayed on that page. Let's say, I have a field called "PetName"



Right now, the coldfusion setup is set to give a thumbs up or down as far as access. Here is the code:

Code:

SELECT * 

FROM Clients

WHERE Customer = '#form.usr#'

AND Secret = '#form.pw#'







 

&CFresponse1=ok& 



&CFresponse1=bad&

What would I need to add to this code for it to send the data from the field "PetName" along with the ok or bad response?



Also, from within flash, what code would I need to display that record? Something to this affect:



loadVariables("f22clientlogin.cfm", _root.form);

Name = _root.form.PetName;



This flash is setup so that on the root level, various movieclips are loaded throughout the process, hence the root level references.



Thanks,

Dave

More Information:

1. If you did the loading and saving tutorials and have a basic understanding on how to handle database records with php, you can manage to extend the guestbook to whatever you like
2. In this lesson of the ColdFusion tutorial, you have learned how to connect to a database to insert and select records and to use this ability to create registration and login forms
3. This course also demonstrates how to use Dreamweaver to link a variety of multimedia file types - from Flash to Java to RealAudio - to Web pages
4. What am I doing wrong here on passing a string and also how could I pass the sting with single quotes in it? On my CFM page:
5. Using the HTTP methods GET and POST, Macromedia Flash can pass variables to ColdFusion templates just like any other Web page
6. NET to Flash! This is a simple but powerful video because you will now know how to pass ASP
7. 6 posts - 5 authors - Last post: Dec 19, 2008In turn this queries the database based on the information passed to it and returns the recordset to the Flash movie
8. Create a new page named "show" and ensure it has an extension of cfm
9. cfm" page that "display" and "keyword" aren't passed into it? Same

More:

• What PHP and ColdFusion have in common
• Fusebox
• sending hex data to a socket
• output 1 column into separate html tables
• Our own board!
• Email Form - Beginner
• ColdFusion is Java..
• Open Sourceness
• Welcome to the new Cold Fusion CFML Board
• ColdFusion Turorials

[billgeytslol]

First of all, why do you have &CFresponse1=ok& instead of #CFresponse1=ok# ?

And, &CFresponse1=bad& instead of #CFresponse1=bad#

More Information:

1. Next, the Flash movie communicates with another CFM page, which performs any kind of processing or queries to a database
2. Most databases have some sort of row-level locking of database records, however when building a web application you need more than that
3. I am attempting to pass variables into flash from the php page which my flash file is viewed in
4. 4 posts - 2 authors - Last post: May 8, 2009Brand new to Coldfusion and I'm struggling to figure out how to pass values from multiple checkboxes on a form to a confirmation page and then an action
5. How can I call a Oracle database procedure in my CFM page and can pass a parameter? Need a code to refer
6. How do I pass this variable to flash/get coldfusion to recognize the box was checked and display it's value?
7. cfm?id=3", how can I rewrite/redirect the url to go to that new script and pass it "news
8. Database Driven News Page In Flash, How? How Do I Return Database Record To Flash From Cfm Page; Database Driven News Page In Flash, How?
9. cfm?id=#id# and the record is removed from the database based on the id passed
10. cfm; Locking Session and Application variables with <cflock>; Exercise 16: Password Protecting Pages (optional)

[phuongbr]

This is code I took from a login setup. It was set up with the "&" at the beginning and end. This part works though. I does pass the response as ok or bad. What I want to do is also pass a variable from a query to flash if the response is ok.

More Information:

1. Updating Database Data; Building an Update Form Page; Building Update Logic; Deleting Records from the Database; Improving SQL Security
2. For purposes of tracking we have wriiten a function for each of the nav element, that makes a call to a cfm page which writes a record in the database
3. I have a basic form in flash which calls a cfm script, but somehow the cfm script does not pass on the form content to the server
4. in doing so we'll pass a variable from the show_news page to the show page which will determine the record selected by the query
5. The cfm page will then query a database and return any
6. We are also open to migrating the Access Database to linux and just converting the CFM page to PHP
7. Get data from a database and display it on the page; Insert, Edit and Delete records from a database; Pass data from one page and receive it on another using HTML Forms
8. It will create the database in the DSN you provide it, by simply running an install script by calling a cfm page