Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Formatting links in an Access database
Old 10-05-2006, 06:25 AM Formatting links in an Access database
Super Talker

Posts: 129
Trades: 0
Hi all, got a small problem I hope someone can help me resolve. I'm working on a website displaying photographic images. The main page is an asp linked to an Access db, the image changes as you scroll through the records using server behaviours etc. The field in the database is set to hyperlink ands the image is selected as a datasource, all through DW, nice and simple. However, the images are re-sized smaller than ideal to allow for the page layout. i would like to have a field displayed for each record that is a hyperlink to a page with a larger version of that particular image on it. Questions are:
what field format do I use in Access - is it hyperlink?
I actually want every link to read "Click for larger image", but of course the underlying record would be different for each image as it is displayed. is this possible?
By parallel a jump link can be named anything you want, i.e.
<A HREF="#Picture1">Archway<A/>

Would this format work in a db field

<A HREF="Images/arch.jpg">Archway<A/>

Would the field type have to be set to text or hyperlink?

Sorry for the length of post!

Cheers, Lol
__________________

Please login or register to view this content. Registration is FREE
- Street Photography
Lol999 is offline
Reply With Quote
View Public Profile Visit Lol999's homepage!
 
 
Register now for full access!
Old 10-07-2006, 06:26 AM Re: Formatting links in an Access database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,526
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
doesn't matter one bit what you have in the database, it's just text. It's what you do when it's written to the page that will make it work

all you need in the field is the path & image name, then code it in asp;

Code:
<%
with response
      .write "<a href="
      .write chr(34)
      .write objRS("field")
      .write chr(34)
      .write " alt="
      .write chr(34)
      .write "insert alt text here"
      .write chr(34)
      .write " title="
      .write chr(34)
      .write "insert title text here"
      .write chr(34)
      .write ">"
      .write "Anchor text goes here"
      .write "</a>
end with
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?

Last edited by chrishirst; 10-07-2006 at 06:37 AM.. Reason: typo
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-07-2006, 08:08 AM Re: Formatting links in an Access database
Super Talker

Posts: 129
Trades: 0
Hi Chris, thanks for your help. Now then, to clarify because I'm a bit thick, the image I want to show larger would be on it's own page, so for example if I had an image in Images called Street, it's own page displaying the large image would be called Street.htm. Is this what I put in the database field, presumably formatted to text? if that's the case how does this affect the asp you quoted? Also, where would I put the asp, in any particular part of the page? I'm new to asp and have only managed to do my asp pages through DW's server behaviours etc.

Thanks again, Lol
__________________

Please login or register to view this content. Registration is FREE
- Street Photography
Lol999 is offline
Reply With Quote
View Public Profile Visit Lol999's homepage!
 
Old 10-07-2006, 08:46 AM Re: Formatting links in an Access database
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,526
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
depends on how your page is coded. If you create a seperate page (long winded method) for every photo then it's that URL you would have in the database.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 10-08-2006, 10:47 AM Re: Formatting links in an Access database
Super Talker

Posts: 129
Trades: 0
Thanks Chris, just the answer!

Cheers, Lol
__________________

Please login or register to view this content. Registration is FREE
- Street Photography
Lol999 is offline
Reply With Quote
View Public Profile Visit Lol999's homepage!
 
Reply     « Reply to Formatting links in an Access database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.21380 seconds with 12 queries