How do I call ADODB Command.Execute() using JavaScript?

[mikegolden]

An application I'm working on makes extensive use of output parameters and return values, thus forcing me to use the ADODB Command object to execute the stored procs. For recordset returning stored procs, calling Execute() is no problem using javascript:

    var rs = cmd.Execute();
 

However, for non-recordset returning stored procs -- and this app has many -- I need to call Execute() passing adExecuteNoRecords for the Options parameter, leaving the other parameters missing. For example, in vbscript:

    cmd.Execute , , adExecuteNoRecords
 

How the heck do I make that call in JavaScript? It barfs when I try:

    cmd.Execute(, , adExecuteNoRecords);        //doesn't work
 

Does anyone have a clue how to make this call?

Thanks!
--Mike



(Note: for the moment, I'm working around the problem by having JavaScript call a VBScript sub that performs the Execute call. Still, I would like to know the correct way of calling an object method from JavaScript having optional parameters not at the end of the parameter list.)

[jeffstl]

This subject has seemed to come up multiple times lately.

It has also sparked some good discussions so don't take everything I say here as certainty.

However, javascript (assuming its set up how it typically is) runs locally on a browser. Therefore you cannot make requests to a database server in run time like this with it.

Secondly, things like ADODB are strictly microsoft objects that only server software can decipher (compile) and run. So no browser will have the capability to create an ADODB object. As a general statement, ADODB and javascript just do not work together (unless you are doing some kind of dynamic generation of ASP with javascript, hence the mention of the discussions sparked from this topic previously).