Still baffled by ASP variables and Flash...

[aljones]

I hate to continue this thread and demonstrate my absolute lack of knowledge on this subject so publicly, but I hope everyone can be patient with me. I've been writing ASP, VB, SQL, etc. for years and years, but I'm new to Flash and a little confused...

I have followed all the posted suggestions, however, my Flash movie is reading everything EXCEPT the value of the ASP variable. You see, I use a SQL statement to retrieve a recordset and the correlating value for this variable. As long as I don't include the code for the recordset, my hard-coded ASP variable value gets passed into MX just fine.

However, with the recordset as output from the asp I put:

Response.write "&Flash_LevelID=" & rs(0)

My Flash movie is only seeing:

Flash_LevelID= "

---- OR ----

If I change the ASP code to:

Response.write "&Flash_LevelID=" & rs(0) & "&"

then what Flash sees is:

Flash_LevelID="\"

---- OR -----

I have also tried:

Response.write "Flash_LevelID=" & rs(0)
(without the ampersand before the variable name)

In response, my Flash movie is only seeing:

Flash_LevelID= undefined

-----------------------------------------------
Like I said, if I create ASP code that says:

"&Flash_LevelID=23&"

Then Flash reads CORRECTLY:

Flash_LevelID=23
----------------------------------------------

Apparently I've missed something very important in transferring the values from ASP recordset and I just can't get a handle on what it might be.

Can someone who knows what they are doing with these crazy ASP recordsets and Flash variables help me?

Thank you, thank you, thank you!

[final_eternity]

What is the code in Flash you are using to load the variables?

I've been doing it like this

myVar = objRS("Fieldname")
Response.Write "&myVar=" & myVar

and that seems to load fine.. it might be in how you are using the flash coding to bring it in..

.fe.

[aljones]

Thanks final_eternity....

Here's my Flash MX code...

externaldata=new LoadVars();
externaldata.load("HeirarchyXMLFlash.asp");


The Flash_LevelID variable exists in both ASP and in my Flash movie. The Flash movie sees the correct value if I hard-code something in the ASP for Flash_LevelID, but not if I try to pass a recordset value.

Thank you very much for helping me! I'm just about to pull my hair out after chasing this one for over a week!

Amy

[final_eternity]

That is interesting.. looks like it should work.

I am actually having a problem right now loading ASP data with LoadVars() ...

seems if I do
LoadVarsObject.load("whatever.asp")
it wont load correctly

if I do
LoadVarsObject.load("http://localhost/folder/whatever.asp"
everything loads perfect..

Might be same problem for you..

Try setting a variable to your recordset value then doing
Response.Write "&myVar=" & whatever you set it to

..?

[aljones]

Well, I tried your suggestion and that, too, didn't work. In fact, it got the same results. I'm just stumped....

On the other hand (and this is probably a really dumb question since you obviously know what you are doing) --

You said:
------------------
seems if I do
LoadVarsObject.load("whatever.asp")
it wont load correctly

if I do
LoadVarsObject.load("http://localhost/folder/whatever.asp"
everything loads perfect..
---------------------------

Is "Whatever.asp" stored on an IIS server in the same location as your "*.fla" file? If not, that could be the problem with your pathing. I'm sure you've thought of this, but every suggestion we have from our own experience might help another newbie!

If you come up with any other suggestions, please let me know!

[final_eternity]

Yeah, the asp file is in the same directory. That is why I am baffled as to why it wont work unless I put a full path in. It finds the file, it just jumbles all the information up.

If you are on IIS or something similar, try changing your file to the full path, like

LoadVar.load("http:/localhost/NewSGCS/GetHours.asp");

see if it works that way..

here I am trying to help you out and I am just a nearly baffled..

[aljones]

Way too weird. Can you use virtual pathing at all? (i.e., "//ServerName/Directory/File.asp") That's worked for me....

[final_eternity]

Doesnt seem to work for me..

I was under the assumption that if my asp was in the same directory as my swf, that all I had to do was put "whatever.asp" and it would work.

Up to this point, it hasn't. This is the first time i've been stumped on something in Flash for a couple months.

And no one seems to be answering any of my other pleas, so maybe nobody knows what is going on.

If you figure your problem out, let me know, cause it might lead to me figuring mine out.

From the way i've been doing things, your way should be working.

[aljones]

It may have something to do with using "LoadVars()". I know that when I've used:

"loadVariables("//ServerName/Directory/filename.asp", 0, "GET")"

I've encountered no problems. However, after my last post to you, I went back and tried loading with "LoadVars()" and cannot load from a virtual directory like that. It has to be only the file name and the file has to be located in the same location as the "*.fla" file.

[borut]

Well, I cannot help you with your problem, because I do not know anything about. So - what I am doing here, huh? I want to suggest completely different attitude. When I am loading something into flash from database, I always use XML. It is simple and much more flexible. You can do virtualy miracles with XML. And if you combine XML with XSLT, then it is even more powerfull. So think about it.

[aljones]

Thanks, Borut. I am using XML for part of this development, but in this particular instance I need to pass an ASP variable into the Flash from a recordset queried on a login page.

If you come up with any other suggestions, please let me know!

[zaxis]

this is not a problem, it's because you are testing locally, when you test your movie trace out your movie path it probably says something like "C://inetpub/wwwroot/website/movie.swf" or something simular, this does NOT kick in the iis. you for anything to work you will need to specify "http://localhost/website/flashvars.asp"

this executes the asp correctly, eighter way when your ready to upload to the server (which doesn't care how you do it) then

loadVarsObject.load("flashvars.asp"); // will work correctly on the production server


what I do is set a var to my path like
myPath = "http://flashvars.asp";

then when I'm ready to sent to production server I change that code to
myPath = "flashvars.asp";