Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Web
Expertise: Intermediate
Dec 11, 2001

Calling a Stored Procedure from an ASP Page


Below is an example of passing in parameters when calling a stored procedure from an ASP page.
  
<%
Dim aConn
Set aConn = Server.CreateObject("ADODB.Connection")
aConn.Open ConnectTo()
strFrMo = cint(Request.QueryString("FrMo"))
strFrYr = cint(Request.QueryString("FrYr"))
strToMo = cint(Request.QueryString("ToMo"))
strToYr = cint(Request.QueryString("ToYr"))
aConn.Execute ("Execute sp_BusRev '" & strFrMo & "', '" & strFrYr & "', '"
& strToMo & "', '" & strToYr & "'")
%>
Jill Herrmann
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date