RE: Frontpage ->IIS 5 with SQL Server Question

["James Hoye" <james.hoye@xxxxxxx>]

> Ok I have knocked up a simple web site the retrieve data (recipes
in
> this case) from my server.
>
> What I want to know is how can I pass a user typed in selection and
get
> FrontPage to incorporate it into a SQL query. I can see its easy to
set
> a asp to get data from SQL server with the selection determined at
> design time, but wats the method used for doing it at runtime ?

Use Request.Form("MyFormVariable") in the ASP to retrieve form
variables
that are POSTed, ie. in <form> section on HTML page.

<form action="/findrecipe.asp">
Type:<input name="type"
type="text"></input>
Meat:<input name="meat"
type="text"></input>
</form>

ASP:
strType=Request.Form("type")
strMeat=Request.Form("meat")

If you want to pass any parameters in the URL (using HTTP GET method)
then
retrieve these using Request.QueryString("VariableName").

eg. URL="/findrecipe.asp?type=curry&meat=chicken"

ASP:
strType=Request.QueryString("type")
strMeat=Request.QueryString("meat")

HTH
James H

Yahoo! Groups Sponsor

ADVERTISEMENT

For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.