Re: Running Stored Procedure from ASP

Hi Len,

If by parameter you mean a column(s) value, here's an example ...

Define your connection and do your select statement

<%
Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "database", "username", "password" SQLQuery = "SELECT blah FROM table"
set objResults = oConn.Execute(SQLQuery)
%>

You then stick the following in a table statement for example

<%= objResults("blah")%>

You could also set a variable to be the objResults statement and then use it elsewhere within your page or pass it on to other pages, etc, etc, etc ...

(I'm assuming you have ASP knowledge)

Hope this helps Received on Thu Jun 04 1998 - 03:52:19 CDT