Re: Frontpage ->IIS 5 with SQL Server Question

["graham_howe" <graham@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.