Forum Moderators: open

Message Too Old, No Replies

JavaScript & Calling a Stored Procedure

         

scoobydoo987

6:26 pm on Oct 13, 2005 (gmt 0)

10+ Year Member



Is it possible to call a stored procedure using JavaScript and display results from it?

I need this to be placed in the appropriate order depending on the results of a stored procedure.

var linerText = document.forms[0].elements["liner_Year_" + vid].value;
linerText += ' '
linerText += document.forms[0].elements["liner_Make_" + vid].value;
linerText += ' '
linerText += ' '
linerText += document.forms[0].elements["liner_Make_" + vid].value;
linerText += ' '

Depending on the stored procedure results
document.forms[0].elements["liner_Make_" + vid].value
might need to be moved before document.forms[0].elements["liner_liner_Year_" + vid].value

If the results that come back from the stored procedure are:
vm.make
vm.year
vm.model
-----------------------
var linerText shold be:

var linerText = document.forms[0].elements["liner_Make_" + vid].value;
linerText += ' '
linerText += document.forms[0].elements["liner_Year_" + vid].value;
linerText += ' '
linerText += document.forms[0].elements["liner_Model_" + vid].value;
linerText += ' '

bsterz

2:21 am on Oct 16, 2005 (gmt 0)

10+ Year Member



Well you can always use something like:

<script language="javascript src="somefile.php">
</script>

Then you can do the stored proc call from the js and document.write it or set innerhtmls to the values returned from the js file