Skip to main content
K
krazykris
Participant
May 22, 2006
Question

PLEASE HELP PROJECT DUE IN TOMMORROW

  • May 22, 2006
  • 1 reply
  • 342 views
Hi, I am really stuck and have a project to hand in tommorow, I created a web site in dmx and linked it to the following access database
ID, SEE
where see is a hyperlink in a access db coloum to a page of a word document. However when I search for a cretain ID the link in the see coloum is not clickable as a hyperlink. Does any one know where I am going wrong?
This topic has been closed for replies.

1 reply

P
primalx2003
Inspiring
May 22, 2006
What I can say is that, either the link was not saved or your coding is wrong. Can you paste your code so i can look at it??

Are you doing the following??

<cfquery datasource="whatever" name="listings">
select ID, SEE
From yourdb
</cfquery>

<cfoutput query="listings">
<cfif SEE neq "">
<a href="#URLENCODEDFORMAT(SEE)#">#ID#</a>
<cfelse>
#ID#
</cfif>
</cfoutput>

Try it.
E
elDonrico
Inspiring
May 24, 2006
krazykris,

primalx is right, you are probably outputting the hyperlink and just outputting it wont make it "clickable" you need to code it as a link like primalx said, except if you want it to look like a link you need to replace the ID to SEE (you should really try naming you columns differently ID is pretty vague try something like linkID and SEE is a common word with no correlation to you database try pageLink or something...

<cfquery datasource="whatever" name="listings">
select ID, SEE
From yourdb
</cfquery>

<cfoutput query="listings">
<cfif SEE neq "">
<a href="#URLENCODEDFORMAT(SEE)#">#ID#</a>
<cfelse>
#SEE#
</cfif>
</cfoutput>
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices