473,320 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

I know this can be done...

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

Jul 22 '05 #1
4 1351
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*********************@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

Jul 22 '05 #2
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*****@hotmail.com> wrote in message
news:Om**************@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" <ma******@yahoo.co.uk> wrote in message
news:42*********************@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


Jul 22 '05 #3
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.developersdex.com ***
Jul 22 '05 #4
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*****@hotmail.com> wrote in message
news:Om**************@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" <ma******@yahoo.co.uk> wrote in message
news:42*********************@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 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
>
>
>



Jul 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Peter Row | last post by:
Hi, I am writing a DLL in VB.NET that implements IHttpHandler.ProcessRequest. This code calls a sub and I need to know if that sub did a response redirect or not. Specifically I need to know...
2
by: David | last post by:
SUMMARY: If you don't want to read all of this, what I'm looking for more or less is ideas on how to implement websites using ASP.NET that have a templated look and feel and many pages that make...
1
by: lauralucas | last post by:
Hello I'm using ASP.NET 1.1, Visual Studio 2003, IIS 5.1 and windows XP as development machine. I can work in this machine locally and create web apps that I can access via localhost. No problem...
15
by: Pucca | last post by:
I'm getting an error when I tried to use this BerConverter class in my C# code. Even though the Interent doc says that it runs on Win2000 sp4, I just thgouth I'll double check. Does anyone know...
9
by: Coleen | last post by:
Hi All :-) I am desperately looking for some help/information on how to direct page flow. Forget what I have done - here's what I need to do: I have a large ASPX.Net - VB.Net web application...
10
by: =?Utf-8?B?UHVjY2E=?= | last post by:
Hi, I'm using vs2005 and .net 2.0. I started 2 threadpool threads. How do I know when they're done with their tasks? Thanks. ThreadPool.QueueUserWorkItem(new...
12
by: better_cs_now | last post by:
Hello all, I suspect that a threading issue is leading to an object being destructed in one thread context while one of its member functions is still running in another thread context. As a...
20
by: johnnyboy7 | last post by:
I don't know a lot about ASP and I know even less about SQL. I have been trying to search the web for information to be able to get done what I need. I've tried piecing things together from many...
2
by: Zerge | last post by:
I can launch threads just fine, but then I have to do a time.sleep(n) so the main thread from which they where launched will wait for all the threads to return. How can I detect when all threads...
3
Parul Bagadia
by: Parul Bagadia | last post by:
Hello, I guess it may be related with some sort of memory organisation, but am not sure. Nywaz, the situation is , am working in Turbo C++ compiler..am making a program to simulate an assembler,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.