|
Home > Archive > IIS ASP > April 2005 > I know this can be done...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I know this can be done...
|
|
| Apple Plexy 2005-04-26, 5:55 pm |
| 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 2005-04-26, 5:55 pm |
| 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" <mafa_web@yahoo.co.uk> wrote in message
news:426e68c3$0$542$ed2619ec@ptn-nntp-reader03.plus.net...
> 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 2005-04-26, 5:55 pm |
| 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" <kpete23@hotmail.com> wrote in message
news:OmS8WunSFHA.3444@tk2msftngp13.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" <mafa_web@yahoo.co.uk> wrote in message
> news:426e68c3$0$542$ed2619ec@ptn-nntp-reader03.plus.net...
What[vbcol=seagreen]
specific[vbcol=seagreen]
would[vbcol=seagreen]
link[vbcol=seagreen]
VBscript.[vbcol=seagreen]
>
>
| |
| Bullschmidt 2005-04-26, 5:55 pm |
| 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.URLEncode when creating a querystring
from a variable:
<a href="http://www.mysite.com/mypage?Category=<%=
Server.URLEncode(objRS("Category")) %>">objRS("Category")</a>
And in the page that is opened you can use
Request.QueryString("Category") to get the value of Category.
Category = Request.QueryString("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.codecomments.com ***
| |
| Jeff Cochran 2005-04-27, 5:57 pm |
| On Tue, 26 Apr 2005 18:03:16 +0100, "Apple Plexy"
<mafa_web@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" <kpete23@hotmail.com> wrote in message
>news:OmS8WunSFHA.3444@tk2msftngp13.phx.gbl...
>What
>specific
>would
>link
>VBscript.
>
|
|
|
|
|