inetserver asp components: ASP help required please -- inetserver asp components

ASP help required please

Stephen
2/25/2004 3:56:05 AM

inetserver asp components:

Hey Al
I have a stored procedure in SQL server which when exectuated returns a table of results. I would like to be able to pass in the parameters from a form into the stored procedures and then view the table of results in a html table when the submit button is clicked.

The parameters for my SQL statement are:
@weekenddate1, @weekenddate2, @txtpub, @txtprice and @txtDescriptio

Can anyone help me write the asp code to pass these values into a form and return a table of results on a new html page

My html form looks like the following:
<form name="form1" method="post" action=""><table width="52%" border="0"><tr><td width="43%">FROM DATE</td><td width="57%"><input name="fromdate" type="text" id="fromdate"></td></tr><tr><td>TO DATE</td><td><input name="todate" type="text" id="todate"></td></tr><tr><td>PUBLICATION</td><td><input name="publication" type="text" id="publication"></td></tr><tr><td>PRICE</td><td><input name="price" type="text" id="price"></td></tr><tr><td>DESCRIPTION</td><td><input name="description" type="text" id="description"></td></tr><tr><td> </td><td><input name="VIEW_REPORT" type="submit" id="VIEW_REPORT" value="Submit"><input name="CLEAR" type="reset" id="CLEAR" value="Reset"></td></tr></table></form

Re: ASP help required please

Ray at <%=sLocation%> [MVP]
2/25/2004 7:46:24 AM

http://www.aspfaq.com/5003

--

Ray at home
Microsoft ASP MVP

[quoted text, click to view]
table of results. I would like to be able to pass in the parameters from a
form into the stored procedures and then view the table of results in a html
table when the submit button is clicked.
[quoted text, click to view]
border="0"><tr><td width="43%">FROM DATE</td><td width="57%"><input
name="fromdate" type="text" id="fromdate"></td></tr><tr><td>TO
DATE</td><td><input name="todate" type="text"
id="todate"></td></tr><tr><td>PUBLICATION</td><td><input name="publication"
type="text" id="publication"></td></tr><tr><td>PRICE</td><td><input
name="price" type="text"
id="price"></td></tr><tr><td>DESCRIPTION</td><td><input name="description"
type="text" id="description"></td></tr><tr><td> </td><td><input
name="VIEW_REPORT" type="submit" id="VIEW_REPORT" value="Submit"><input
name="CLEAR" type="reset" id="CLEAR" value="Reset"></td></tr></table></form>
[quoted text, click to view]
knowledge is minimal