My cfm script pulls the contents of database fine. (a cfoutput reveals variables) In flash however i cannot see my dynamic variables. I don’t know why?
I am new so its probably simple.
What am I doing wrong in syntax?
// In the flash mainframe I have.
loadVariables(“LoadVars.cfm”,0,“GET”);
// Ive also tried this:
myLoadVars = new LoadVars();
myLoadVars.load(“LoadVars.cfm”);
// In the LoadVars.cfm I have.
<CFQUERY NAME=“ElfVars” DATASOURCE=“ElfQuest”>
SELECT * FROM Stats
</CFQUERY>
I have a dynamic text field named “Name”. Why doesn’t it display the Name in the database.
I can see my variable hardcoding cfoutput in the page. SQL is working. Why can’t I see them in Flash?
Im new to flash. Thanks so much, been a problem 4 me.
welcome to the forums (and flash).
is your cfm page outputting a valid HTML query string? That’s how you send/recieve data from one page to another.
myLoadVars = new LoadVars();
myLoadVars.onLoad = function(success){
//your vars (if loaded correctly will
//be accessible via myLoadVars.myVarName
}
myLoadVars.load("LoadVars.cfm");
the string should look something like this (similar to a GET a string in an address bar)
myfirstVar=this is what my first var is and i can put anything&mySecondVar=this is what my second var is notice the 'and' sign.
cfm is cold fusion right? Well, im not too familar with cold fusion, but i do know that you have to submit you data correctly no matter what SSL you use.
the my_lv.myVarName can be anything you want. and if i’m not mistaken a select query returns an ARRAY of data right? essentially all you should have printed on your page is the query string:
myfirstVar=this is what my first var is and i can put anything&mySecondVar=this is what my second var is notice the 'and' sign.
Thank you so much for your fast replies. I think your right, I am not passing the vars correctly. I think I may have found a possible helper here: http://www.cfconf.org/cfsouth/talks/towes.ppt
myLoadVars = new LoadVars();
myLoadVars.onLoad = function(success){
//your vars (if loaded correctly will
//be accessible via myLoadVars.myVarName
}
myLoadVars.load(“LoadVars.cfm”);
// This is my Coldfusion which seems to work
<CFQUERY NAME=“ElfVars” DATASOURCE=“ElfQuest”>
SELECT * FROM Stats
</CFQUERY>
The contents of the variable Name in the database is Derek. It displays correctly when using cold fusion in the cfm template, BUT!! I can’t get it to display in flash. Im sure its my sytax or something stupid, obviously stupid cause i hate it
There is a white dynamic text field in the flash that does not display my contents of the variable Name. I tried naming it Name as well as myLoadVars.myVarName
The dynamic text is suppoed to apear, well it aint grrr
Thanks for any help guys. Im sure this is a simple answer and I miss it.
The src=“ElfQuest.swf” has the action script like so:
myLoadVars = new LoadVars();
myLoadVars.onLoad = function(success){
//your vars (if loaded correctly will
//be accessible via myLoadVars.myVarName
}
myLoadVars.load(“http://seadigital.anumina.com/LoadVars.cfm”);
I then have the dynamic text field Var named (well just about everything, but…) myLoadVars.Name as well as Name
Now Name is werking with cfoutput as well as our trace we did. So, what am I not doing that should?
I need to display in dynamic text field. Ive even check if text was white on whie and i cannnot see text. i dont know why i dont see it. if i name a variable in the movie like Name = Derek
then Derek shows in dynamic font, but i thought with our trace it shows derek is dumped from access (the database) in flash. if its in flash why cant it show in dynamic text… im stumped atm
Thanks !!!
html file (with swf only).
cfm file (with cold fusion only When you run this file by itself it should out put ‘&Name=derek’ ONLY)
the swf code should be like this:
myLoadVars.load(“LoadVars.cfm”);
and run this: http://seadigital.anumina.com/LoadVars.cfm by itself. Right click on the page and view the source. See all that whitespace? get ride of it! i was suggesting putting all of your cold fusion tags on one line.
Thnx for help!
