ASP help required

[Stephen]

Hey all
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>&nbsp;</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

I will be so so so so pleased if anyone is able to help me. My asp knowledge is minimal

[Ray at]

http://www.aspfaq.com/5003
--

Ray at home
Microsoft ASP MVP
"Stephen" <st*****************@hotmail.com> wrote in message
news:05**********************************@microsof t.com...

Hey all,
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 @txtDescription

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>&nbsp;</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>
I will be so so so so pleased if anyone is able to help me. My asp

knowledge is minimal

[Bob Barrows]

Already answered over in .db

Please do not multipost Stephen. This is definitely a database-related
question so .asp.db was the perfect group in which to post it. Posting it
here as well did not increase your chances of getting an answer (most of us
subscribe to both groups). On the contrary, if somebody had taken his time
to answer it here, only to find that it was already resolved in the other
group, that person may have been annoyed enough to ignore any future posts
from you, thereby decreasing your chances of getting help in the future.

There are times when you will not be sure which group is most appropriate
(again, this was not one of them), and you will want to post a question to
both groups. In that situation, you should use the cross-posting technique,
rather than posting the same message multiple times. To crosspost, put
a semicolon-delimited* list of the newsgroups to which you wish to post in
the To: header of your post and post it once. It, and any replies to it,
will appear in all the newsgroups in your list. So, if I reply in .asp.db,
my reply will also appear here in .asp.general.

* ... or whatever delimiter is recognized by your news client

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"