passig variables from CF to Flash - takes forever

[digitalxaus]

G'day all

I'm, quite familiar with Coldfuson but a relative newcomer to Flash (5), i have a real headache of a problem, here goes.

I am trying to develop a simple online shopping cart using FL, CF and Access as the DB.

Ive managed to randomly add product info into a flash file via CF, that was no problem. Ive also managed to update the sale quantity and total cost values in the cart, again that seems ok.

My problem is the time it takes to display the information from when requesting the data from CF to displaying it in Flash, it can take uptu 25 seconds to see the data in flash from when i hit the "add to cart" button.

Why is this???

When i run the CF files directly in Explorer they return the values instantly, but if i run the flash SWF file to do the same thing i get this major time delay.

To record the user on the site i am using SESSION Variables to make his cart information unique, i dont know if this is the problem.

Ive tried to work out a looping system that will loop until the info is available, without success (my lack of knowledge with Flash).

The problem lies in the fact that if the user updates the info before the display has loaded it makes a new Session Variable and adds this to the cart, something i definately do not want to happen.

If someone can point me in the right direction i could possibly get my sanity back, cheers

 

[billwatson]

havent worked with cf for some time but a couple of things i do recall that can cause problems

all text being passed to flash must be in one line with no line breaks and must start with an ampersand.

session variable should make no diference and i imagine your page is similar to this

<cfquery name=&quot;flashvars&quot; datasource=&quot;whatever&quot;>select * from userinfo
where UserID = #Session.UserID#</cfquery><cfoutput
query='flashvars'>&UserID=#UserID#&variable1=#variable1#</cfoutput>

you might want to add an extra variable to test for loaded (loaded=true,say) and in flash

frame 1

if(loaded){
//do something
}
}else{
gotoAndPlay(2)
}
stop();

frame 2
gotoAndPlay(1);

this might just solve it if the case is that you trying to access the variables before they have loaded.

Not a great answer and may not help much but cf and flash 5 were a long time ago for me.