How do I call an MS-SQL stored procedure from Javascript?

[Invicta]

As a learning exercise I'm writing a small application but I've hit a small problem and I'd like some help.

I have a form. On the form is a selection box. When the user selects one of the options the cursor moves onto the next input box. The bit that's missing is the bit that pre-populates this input box after the selection was made but before the cursor hits the input box.

I'd like to use "onblur" (when the user leaves the selection box) to call an MS-SQL stored procedure with the selected option as a parameter and pre-populate the input box with a returned value.

For information, I already have a connection (objConn) and I access stored procedures like this elsewhere in my application:

set cmd=Server.CreateObject("ADODB.Command&quot
cmd.ActiveConnection = objConn
cmd.CommandType = adCmdText
set rsDeviceNames = Server.CreateObject("ADODB.Recordset&quot
cmd.CommandText = "GetDeviceList '" & session("SiteID&quot & "'"
set rsDeviceNames = cmd.Execute

I then harvest the data from the returned recordset as required.
[sig][/sig]

 

[NickBulka]

You're trying to mix server-side and client-side processing. You can't do what you want without another trip to the server.

In other words, after the selection is made from the selection box, you'll need to go back to the server, get the data from the database, and create another page. [sig]<p>nick bulka<br><a href=mailto: > </a><br><a href=

http://www.bulka.com>

</a><br>Get your technical books at Bulka's Books<br>

http://www.vstorebooks.com/bulkasbooks

[/sig]

 

[Invicta]

Thanks Nick.

I could come back to the same page but with request(&quot;varname&quot populated, maybe?

I was hoping for a solution where &quot;onblur&quot; calls a javascript function that itself invokes an MS-SQL stored proc and uses the returned value to pre-poulate the input box using something like this:

<script>
function FillInputBox(parameter)
{
call to the MS-SQL SP with parameter
document.FormName.InputBoxName.value = SPReturnedValue
}
</script>

[sig][/sig]