asked on

Flex Adobe Flex Connector for MS SQL Server - calling stored procedure with parameters

Hello

I am using this http://www.flexappsstore.com/index.php?route=product/product&product_id=65 and wan't to call a stored procedure with parameters but I am having some problems.

mssqlQuery(“sql string”, “unique query token”);
So if I use mssqlQuery(“Select * from users”,”getUsers”); it works fine, but I want to execute a stored procedure with parameters, the documentations says this:

      // To call a stored prodeduce, simply enter the stored
      // Prodedure name. If your SP takes parameters, you can
      // append to the string just as you would in ASP.
      mssqlQuery("ProcedureName, “unique query token”);

Here is my try on how to do it
      mssqlQuery("APP_SetMyInfo @myparm1=1391283009, @myparm2=56.162939, @myparm3=10.203921, @myparm4=3","SetMyInfo");

So what is wrong with my sql query string?

Stored procedure script works fine, tested it by executing with similar values as above.
It is expecting these values:
@myparm1bigint,
@myparm2 float,
@myparm3 float,
@myparm4 int

You got any idea how to do the stored procedure call with parameters?

dgofman

Please review my previous answer https://www.experts-exchange.com/questions/26891644/AS3-and-database-SQL-vs-MYSQL.html

You cannot access to local database using Flash Player. But if you are using AIR you can using ODBC or DLL drivers

ASKER CERTIFIED SOLUTION

JoachimPetersen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JoachimPetersen

ASKER