Problem with flashmx and cfm

1

is there anybody can help me to point me to the rite path…really need help…i just wanna pass my variable to the cfm page…and then insert to the Access database…with variable name “NAME, ADDS, EMAIL” but it’s seem not working at all…is it this code totally wrong…

code in flash:
[AS]
//frame1
stop();

btn1.onPress = function(){
loadVariables(“insert.cfm”,"_root",“POST”);
}
btn1.onRelease = function(){
gotoAndPlay(2);

}
[/AS]

code in cfm page:


<cfset NAME = NAME>
<cfset EMAIL = EMAIL>
<cfquery name ="Getdtbase1" datasource="myDSN">

INSERT INTO Users(NAME,EMAIL,ADDS)
VALUES('#NAME#','#EMAIL#','#ADDS#')

</cfquery>

pls help me…or is there any thread for it…or link to it…thx

2

hi,

Your code looks fine.
Why would you want to use both onPress() and onRelease()?
I’d say that onRelease() would be enough.
Just in case: onRelease vs onPress.

In your ActionScript try:


loadVariables("insert.cfm",_root,"POST");
// and the preferred way (using the method):
_root.loadVariables("insert.cfm","POST");

This would send all the variables in the _root to the script.

A way to debug, and make sure you have the correct variables would be;


btn1.onRelease = function()
{
	_root.loadVariables("insert.cfm", "POST");
	trace(_root.name);
	trace(_root.email);
	gotoAndPlay(2);
};

As you’re using MX or higher, you should use the LoadVars Class instead:
http://livedocs.macromedia.com/flash/mx2004/main_7_2/wwhelp/wwhimpl/common/html/wwhelp.htm?context=Flash_MX_2004&file=00001408.html
This helps you control which variables are sent.

There are some security measures that you should take when inserting data into a DB.
One of them (not really the best, but still a good practice) is making sure the variables come from where you expect them to come.

So, if you’re using POST in flash, you sould use the FORM scope in CF:


<cfset NAME = FORM.NAME>
<cfset EMAIL = FORM.EMAIL>

Notice that if you’re using MX, the test player doesn’t send the variables using POST, it will use GET. While you’re testing, you don’t need FORM… If you add it, test in the browser to make sure it uses POST.
This bug has been corrected in MX 2004.

3

thanks for the reply nunomira…i’ll try as per ur suggest…btw it’s a good information such newbie like me…tq folks…anything i’ll let u know…

//EDIT…
ello nunomira i just replace the code as ur per suggest but it seem’s not work also…i don’t know why…supposed to I can insert new record from my swf file…i hope u can take look my file herein i attached the file…

tq