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: "graham_howe" <graham@xxxxxxx>
  • Date: Fri, 12 Apr 2002 16:02:00 -0000
  • 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

--- In ukha_d@y..., "Dr John Tankard" <john@s...> wrote:
> 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 ?
>
> John

In your ASP page you will have a line that builds the SQL statement,
for example:

<%
SQL = "SELECT * FROM tblRecipies WHERE CaloriesPerPortion < 500"
%>

If you want to build this using a value submitted from a form (for
example MaxCalories text box, then you could use this:

<%
SQL = "SELECT * FROM tblRecipies WHERE CaloriesPerPortion < " &_
    Request.Form("MaxCalories")
%>


Is that the sort of thing you're after?

Graham



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.