Webmaster Forum / Flash / Flash Remoting / April 2004

I haven´t done any SSAS but I have read the book Flash Remoting: The
Definitive Guide by Tom Muck. He has put up the example code at
http://www.flash-remoting.com/examples/master.cfm. I think there are useful
files to look into.

Jens

as well?

Hi,
I use SSAS for inserting and retrieving data from my DB. If you haven't
already figured it out, here is an example:

function newAnswer(addData) {
  var sql = "INSERT INTO students.answer ";
  sql += " (id";
  sql += " , question";
  sql += " , answers";
  sql += " , testname";
  sql += " , items";
  sql += " , weights)";
  sql += " VALUES ";
  sql += " (" + addData.get("id");
  sql += "," +addData.get("question")+"";
  sql += "," +addData.get("answers")+"";
  sql += ",'" +addData.get("testname")+"'";
  sql += ",'" +addData.get("items")+"'";
  sql += "," +addData.get("weights")+""+")";
  try {
    CF.query("students",sql);
  }catch(e){
    throw sql//"There was a database error";
  }
}

In Flash you must send the parameters:

var addData = {id:user, question:question, answers:answer, testname:name,
items:item, weights:weight};
serviceObject.newAnswer(addData);

Hope this helped