Hello Everyone,
I am in desperate need of help. I am trying to pass parameters to a stored procedure on SQL server but I am not having any kind of success. Here is the code that I'm using on my web and following is the stored procedure i'm using sql server.
TIA
tjacobs
<%
dim conn
dim rs
dim strsql
dim strconn
dim strZipCode
strZipcode = request("zipcode")
strconn="driver={sql server};server=servername;uid=;pwd=;database=name"
set conn = server.createobject("adodb.connection")
conn.open strconn
strsql = "exec zipcodelatlon" & strzipcode
set rs=server.createobject("adodb.recordset")
rs.open strsql, conn
rs.movefirst
%>
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>TestLatLon</title>
</head>
<body>
<% do while not rs.eof %>
<tr><%for each field in rs.fields %.
<td allign=center>
<% response.write field.value %></td>
<% next rs.movenext %>
</tr>
<% loop %>
</table>
</body>
<% rs.close
set rs.nothing
conn.close
set conn = nothing %>
</html>
Stored Procedure
CREATE PROCEDURE ZIPCODELATLON
(@zipcode1 int)
as
select lat, lon as lat1, lon1 from uscityzip
where zipcode = @zipcode
return
go
dBforums
>
Passing parameters to stored procedure using ASP
08-11-03, 17:28
Passing parameters to stored procedure using ASP
Linear Mode
