Question with ADODB.command parameters

[asharif]

Hi,

For some reason I can't get SWF kit to execute an access query that takes a parameter. It executes fine when there are no parameters, but not otherwise. Here is my code:

var adInteger = 3;
var adParamInput = 1;

var cmd = new ActiveXObject("ADODB.Command");
cmd.ActiveConnection = connStr;
cmd.CommandText = "setCurrentSession";
cmd.CommandType = adCmdStoredProc;
var currentSession = FlashPlayer.getVariable("_root.currentSession");

var parm1 = cmd.CreateParameter("CURRENTSESSION", adInteger, adParamInput, 4, 1); //will eventually be passing currentSession, but for now I can't even pass 1

cmd.Parameters.Append(parm1);

cmd.Execute;

assistance would be appriciated!

[asharif]

also...here is my MS ACCESS STORED QUERY

PARAMETERS CURRENTSESSION Long;
UPDATE sessionCounter SET sessionCounter.currentSession = CURRENTSESSION
WHERE (((sessionCounter.sessionID)=1));

[asharif]

alright, I'm a fool!

I figured it out, so I'll save someone some future pain....

The parameter was adding just find and it was executing just find. The problem was tha I had chose to package the database with the project as an attatchment and had forgot!!!

So in the testing environment I kept looking at the original DB, not the one that had been packaged with the app! So I thought that it just wasn't updating. I also kept testing it within the swfkit testing environment so my outputs never got updated (the fresh databse kept overriding the one that was being written to).

That's what happens when you jump back and forth between a bunch of projects. The joys of being an advertising agency programmer!!!!