Over my head

[Chimerical_girl]

I need to know 2 things - or maybe it's just one thing, but it involves asp
and sql

I have an index.htm page with 7 links - each link is to the same asp page,
but based on the link selected, the asp page should pull results from a
specific field in the database.

From looking at other web urls, i think on the link i need a question mark
and some sort of code after the .asp (i.e. testpage.asp?ID=24) - something
like that, but I can't quite figure the exact language.

Also, I know just from tinkering with Frontpage that I need to write a
select statement in sql - something like select from this filed stuff that
equals that field - you get the picture.

My big problem, where I am so VERY over my head, is I cannot seem to grasp
how the hyperlink to the asp page and the sql select statement work together.

I will be so grateful if anyone can provide me fairly simple answers to
these queries.

 

[Jens Peter Karlsen[FP MVP]]

Start with an ASP tutorial.
http://www.w3schools.com/asp/default.asp

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Jon Spivey]

Hi,

You're on the right lines. Let's say you have some products in your database
like this

ProductID ProductName
1 Widgets
2 Grommets

Stick the product id into the link
<a href="Product.asp?id=1">Click for Widgets</a>
<a href="Product.asp?id=2">Click for Grommets</a>

Now on produst.asp start a database wizard and on step 2 hit custom query,
type in
select * from products where ProductID=::id::

This tells FP to insert whatever value for id is in the link and use that
value to pull data from the database.

Hope that helps a bit - try making a test page in FP. It's easier to do than
explain

 

[Chimerical_girl]

You rock. I'll give it a whirl and we'll see where it goes. Are you a
relative of Laurance Spivey? If you are a Raising Arizona fan, perhaps that
gave you a chuckle. Seriously, thank you for your help.
Donna

 

[Chimerical_girl]

Thank you. Will do.
Donna

Start with an ASP tutorial.
http://www.w3schools.com/asp/default.asp

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: Chimerical_girl
[mailto:[email protected]]
Posted At: 4. januar 2005 03:51
Posted To: microsoft.public.frontpage.programming
Conversation: Over my head
Subject: Over my head


I need to know 2 things - or maybe it's just one thing, but
it involves asp and sql

I have an index.htm page with 7 links - each link is to the
same asp page, but based on the link selected, the asp page
should pull results from a specific field in the database.

From looking at other web urls, i think on the link i need a
question mark and some sort of code after the .asp (i.e.
testpage.asp?ID=24) - something like that, but I can't quite
figure the exact language.

Also, I know just from tinkering with Frontpage that I need
to write a select statement in sql - something like select
from this filed stuff that equals that field - you get the picture.

My big problem, where I am so VERY over my head, is I cannot
seem to grasp how the hyperlink to the asp page and the sql
select statement work together.

I will be so grateful if anyone can provide me fairly simple
answers to these queries.