[Dynapi-Help] SODA-RPC and Databases

[Jerry H. <jer...@ho...>]

I got the SODA-RPC example of the calculator up and running and then tried 
to hijack the fraction function to query a database and return results.

<script runat="server" language="javascript">

function fraction(input)	{
	var rs = server.CreateObject("ADODB.Recordset");
                return ("Hi");
               //  Other code would normally follow in this section rather 
than the return ("Hi") to query a database and return results
}
</script>

I changed the webservice wsAddMethod to expect a string return value for the 
fraction function.  If one runs the above script, an error dialog box pops 
up (only when clicking the fraction button, all of the other buttons work 
fine) which states: System Error: [Object Error] while executing 
'fraction()'.  To retry the request, click the OK button.

My attempt to create a Recordset Object on the server (and subsequently 
query a database) is sending the SODA-RPC code into stasis.  How does one 
access a database (using ODBC or JDBC) while using SODA-RPC?  Is the code 
actually accepting the runat="server" request (the normal 'fraction()' 
function works fine within this request) or is this the source of my 
problem?

Should I be accessing a database using SODA-RPC or should I be using some 
other technology?

Any help that can be provided would be greatly appreciated!

Jerry Hammann

_________________________________________________________________
Don’t worry if your Inbox will max out while you are enjoying the holidays.  
Get MSN Extra Storage!  http://join.msn.com/?PAGE=features/es