Reply
Link a database result
Old 01-23-2007, 10:31 AM Link a database result
Average Talker

Posts: 17
Hi,

(I did all this in frontpage....so dont expeect coding expertise from me)

The data that i submit from a asp page and goes into the database is mostly links. The links do appear But the problem is that in databse results they are not hyperlinked .................... i think u(admin) understood my problem...i want the link i submit to be hyperlinked automically.

OR
Any alternative by experts??plzz
dani01 is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 01-23-2007, 02:36 PM Re: Link a database result
tripy's Avatar
Fetchez la vache!

Posts: 1,857
Name: Thierry
Location: In the void
I've read this post 4 times, but I still don't get it....
What are you trying to do, with what kind of data ?

Do you store them as text, binary ?
Do you want to get them and add them an link, or do you want to do a processing before storing them in the db ?
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 01-23-2007, 07:26 PM Re: Link a database result
ForrestCroce's Avatar
Half Man, Half Amazing

Posts: 3,025
Name: Forrest Croce
Location: Seattle, WA
The concept of hyperlinks really doesn't exist in databases. ( MS Access actually has a hyperlink datatype - avoid it at all costs! It has this type because Access is as much an Office product as a Database. ) A hyperlink is a little piece of text you click on, and it takes you somewhere else. A db is more a storage service for data, has no inherent UI, and really can't be clicked on.

What you want to do is store the address in your database, and then when you pull up your query results on an asp page, you need to use html to turn the addresses into links. Something like this:

Code:
Response.Write("<a href='" + address + "'>" + label + "</a")
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Old 01-23-2007, 07:27 PM Re: Link a database result
ForrestCroce's Avatar
Half Man, Half Amazing

Posts: 3,025
Name: Forrest Croce
Location: Seattle, WA
... ooops ... missed the last > in that code snippet.
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Reply     « Reply to Link a database result
 

Thread Tools

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

vB 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.13272 seconds with 13 queries