I know this can be done...

[Apple Plexy]

tearing my hair out here...,

I am creating a site to show artists work. I have a database and can
retrieve and display a list of artisits, other info, and a related image for
each artist - all drawn from the respective entries on the database. What i
would like to do is then use that record to dynamically generate another
page that would display more detailed information about that one specific
artist that the user clicks on - again drawn from that entry in the
database, (rather than merely linking to a static html page - which would
require making some 120 extra pages). I was wondering whether i would link
to another .asp page and force it to display contents relating to a specific
id - but i dont know how to do that anyway.

Im using access database and iis 5.0 generating .asp pages with VBscript.

Any help would be much appreciated.

K

[Kyle Peterson]

one way to do is jsut build a dynamic hyperlink to another page feeding it
the variable (user ID maybe) needed to show more information.. its simple
stuff

http://www.powerasp.com/content/new/...hyperlinks.asp

"Apple Plexy" <ma******@yahoo .co.uk> wrote in message
news:42******** *************@p tn-nntp-reader03.plus.n et...

tearing my hair out here...,

I am creating a site to show artists work. I have a database and can
retrieve and display a list of artisits, other info, and a related image
for
each artist - all drawn from the respective entries on the database. What
i
would like to do is then use that record to dynamically generate another
page that would display more detailed information about that one specific
artist that the user clicks on - again drawn from that entry in the
database, (rather than merely linking to a static html page - which would
require making some 120 extra pages). I was wondering whether i would link
to another .asp page and force it to display contents relating to a
specific
id - but i dont know how to do that anyway.

Im using access database and iis 5.0 generating .asp pages with VBscript.

Any help would be much appreciated.

K

[Apple Plexy]

Thanks for the quick response - it wasnt really hyperlink building i had a
problem with - moreover it was where to send the information to - however
you're reply promted me to think more laterally and i managed to get it to
work by creating another asp page that will list the correct details when i
link to it i.e. artistspage.asp ?id=56 - where "id", I can generate on the
initial results page. - It is basic stuff - if you know how! lol -

K

"Kyle Peterson" <kp*****@hotmai l.com> wrote in message
news:Om******** ******@tk2msftn gp13.phx.gbl...

one way to do is jsut build a dynamic hyperlink to another page feeding it
the variable (user ID maybe) needed to show more information.. its simple
stuff

http://www.powerasp.com/content/new/...hyperlinks.asp

"Apple Plexy" <ma******@yahoo .co.uk> wrote in message
news:42******** *************@p tn-nntp-reader03.plus.n et...

tearing my hair out here...,

I am creating a site to show artists work. I have a database and can
retrieve and display a list of artisits, other info, and a related image
for
each artist - all drawn from the respective entries on the database. What i
would like to do is then use that record to dynamically generate another
page that would display more detailed information about that one specific artist that the user clicks on - again drawn from that entry in the
database, (rather than merely linking to a static html page - which would require making some 120 extra pages). I was wondering whether i would link to another .asp page and force it to display contents relating to a
specific
id - but i dont know how to do that anyway.

Im using access database and iis 5.0 generating .asp pages with VBscript.
Any help would be much appreciated.

K

[Bullschmidt]

Perhaps this may hopefully give you some ideas:

Classic ASP Design Tips - QueryString
http://www.bullschmidt.com/devtip-querystring.asp

Example URL with a querystring:
http://www.mysite.com/mypg.asp?Category=Baseball

Because a variable might contain some odd characters like spaces, it's
usually a good idea to use Server.URLEncod e when creating a querystring
from a variable:
<a href="http://www.mysite.com/mypage?Category =<%=
Server.URLEncod e(objRS("Catego ry")) %>">objRS("Cate gory")</a>

And in the page that is opened you can use
Request.QuerySt ring("Category" ) to get the value of Category.

Category = Request.QuerySt ring("Category" )

' Set strSQL.
strSQL = "SELECT * FROM MyTable WHERE"
strSQL = strSQL & " (Category='" & Category & "')"
strSQL = strSQL & " ORDER BY Subcategory"

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***

[Jeff Cochran]

On Tue, 26 Apr 2005 18:03:16 +0100, "Apple Plexy"
<ma******@yahoo .co.uk> wrote:

Thanks for the quick response - it wasnt really hyperlink building i had a
problem with - moreover it was where to send the information to - however
you're reply promted me to think more laterally and i managed to get it to
work by creating another asp page that will list the correct details when i
link to it i.e. artistspage.asp ?id=56 - where "id", I can generate on the
initial results page. - It is basic stuff - if you know how! lol -
And there are alternatives. Postback to the same page for example,
checking to see if the URL has an artist ID sent, if so, display the
choices and the detals on that artist. Or DHTML with hidden layers,
exposing the layer if the artist is selected.

Just to nudge you further into looking at all the options for
something you wish to do. There's often several ways to do something,
and one may be better technically or experientially for your needs.

Jeff

"Kyle Peterson" <kp*****@hotmai l.com> wrote in message
news:Om******* *******@tk2msft ngp13.phx.gbl.. .

one way to do is jsut build a dynamic hyperlink to another page feeding it
the variable (user ID maybe) needed to show more information.. its simple
stuff

http://www.powerasp.com/content/new/...hyperlinks.asp

"Apple Plexy" <ma******@yahoo .co.uk> wrote in message
news:42******** *************@p tn-nntp-reader03.plus.n et...

> tearing my hair out here...,
>
> I am creating a site to show artists work. I have a database and can
> retrieve and display a list of artisits, other info, and a related image
> for
> each artist - all drawn from the respective entries on the database.What > i
> would like to do is then use that record to dynamically generate another
> page that would display more detailed information about that onespecific > artist that the user clicks on - again drawn from that entry in the
> database, (rather than merely linking to a static html page - whichwould > require making some 120 extra pages). I was wondering whether i wouldlink > to another .asp page and force it to display contents relating to a
> specific
> id - but i dont know how to do that anyway.
>
> Im using access database and iis 5.0 generating .asp pages withVBscript. >
> Any help would be much appreciated.
>
> K
>
>
>