Database Parameters

[BlueMonkey]

Hi

I run a website for a sports club with 15 different age groups. I want to have an asp page that displays results/fixtures for each age group, and obviously 1 page is easier to manage than 15 pages!

I guess I need to pass parameters to this page for the query, to tell the database which age group the user is interested in - how would I do this with frontpage?

Million thanks in advance.



B.M.

 

[Noconi]

If you have an age field then you could create a SQL statement WHERE age = x AND < x

Or something like that - if that makes sense. The x's being the age ranges. Are you using the DRW with this?

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com

 

[BlueMonkey]

Thanks for the reply Tiffany. I'm testing out the parameters option within the hyperlink, eg

http://www.tek-tipsviewthread.cfm?SQID=774376.

Using that as an example I have my AgeGroup ID in place of SQID.

Initial tests are promising...!

Thanks again

B.M.