The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Frontpage ->IIS 5 with SQL Server Question


  • To: <ukha_d@xxxxxxx>
  • Subject: RE: Frontpage ->IIS 5 with SQL Server Question
  • From: "James Hoye" <james.hoye@xxxxxxx>
  • Date: Fri, 12 Apr 2002 17:09:55 +0100
  • Delivered-to: ukha_archive@xxxxxxx
  • Delivered-to: mailing list ukha_d@xxxxxxx
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@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.

Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.