Ted On Flash: Stored Procedures in ASR Remoting

Ted Patrick - Events & Community @ Adobe Systems

Note: This is the personal blog of Ted Patrick. The opinions and statements voiced here are my own.

Stored Procedures in ASR Remoting

DIGG IT! 0 Comments Published Friday, October 24, 2003 at 12:26 PM .

It seems that you can seamlessly integrate stored procedure calls with ActionScript Remoting. At first I was a bit skeptical that this would work, but some engineer at MM knew what they were doing. Here is a simple ASR remoting function using a stored procedure:

function getsystem(o){

// create a stored procedure call as a string
var sql = 'sp_GetVersionInfo @id=' + o.get('id')

//execute the data via CF.query()
var ret = CF.query("data001",sql)

//return the sql result set to remoting
return ret

}

We are using SQL Server 2000 and ColdFusion MX. The database 'data001' is defined in the CF admin. Passing variables by name is a snap. Simply use the @{name} and use single quotes with stings (same as sql) and your all set. This makes using stored procedures easy.

Special thanks to Dave Gallerizzo at Figleaf for working through fine details to get this working.

Cheers,

ted ;)

Stuff I am building:

Ted Patrick - Events & Community @ Adobe Systems

Note: This is the personal blog of Ted Patrick. The opinions and statements voiced here are my own.

Stored Procedures in ASR Remoting

0 Responses to “Stored Procedures in ASR Remoting”

Where to find me:

Latest

Lists

Links

Jobs

Archives