How do you call an asp function from java script

bertrandkis · Aug 10, 2002

I need to execute an asp script that calls a stored procedure on SQL server.Each time a form button is clicked the result of the query executed by the asp script must be shown on a form field.With the script I have writen the textbox value stays the same event if the stored procedure returns different values each time it is executed. Here is the code.

<html>
<body>
<script >
function rep()
{
<% SET cn=server.CreateObject("adodb.connection&quot

with cn
.ConnectionString ="Provider=sqloledb;datasource=(local);uid=sa"
.Open
.DefaultDatabase ="Test database"
end with
%>
<%
dt="3/11/2002"
set rs=server.CreateObject("adodb.recordset&quot

set rs=cn.Execute("testproc '"& dt &"'" ,,adCmdStoredProc)
response.write("foo=" & rs.fields(0))
%>
document.f1.t1.value= foo;
}
</script>
<form name=f1>
<input type=text name=t1 >
<input type=button name=b2 value="New nber" onclick="rep()">
</form>
</body>
</html>

The text of the stored procedure is:

create proc testproc @d datetime
as
begin
set dateformat dmy
declare @n int,@k int
set @k=0
set @n=rand()*20+1

while @k=0
begin
if exists(select * from testnumbers where testcode=@n and testdate=@d)
begin
set @n=rand()*20+1
continue
end --end if
else
break
end --end while
select @n --create a recordset
end -- end of proc

The content of the table against which the stored procedure executes:
----------------------------------------
testcode Testdate
----------- ----------------------
7 2002-03-11 00:00:00.000
8 2002-03-11 00:00:00.000
9 2002-03-11 00:00:00.000
10 2002-03-11 00:00:00.000
6 2002-03-11 00:00:00.000

I will appreciate your help and if you can email me directly at bertrandkis@usa.com I will appreciate, the project I am working on has come to a dead end because of this problem. Thank you

prasadalone · Aug 10, 2002

hey its easy

<input type=text name=t1 value = '<%=rs.fields(0)%>'>

bertrandkis · Aug 12, 2002

Thanks for your reply, I do have that line: <input type=text name=t1 value = '<%=rs.fields(0)%>'> but when you click the button the number in the textbox does not change..Which suggests that a new recordset is not generated whenever the button is clicked.So the problem is still not solved.

sunjv · Aug 12, 2002

there are two thing you have to do..
first you have to call a ASP sub
second you have to pass the result to javscript..

here is how to do.

first make a sub
eg.
Sub GetRecord()

'put your searhing code here..
'declare the foo variable

foo= rs.fields(0)

end sub

second make a javascript function
eg.
function ShowTheResult(MyResult)
{
document.f1.t1.value= MyResult;
}

here is the line how to call this both functions..
put this code in the button click..

<input type=button onclick="<%call GetRecord()%>;ShowTheResult('<%=foo%>')">

that's all..

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How do you call an asp function from java script

bertrandkis

Programmer

prasadalone

Programmer

bertrandkis

Programmer

sunjv

Technical User

Similar threads

Part and Inventory Search

Sponsor