PLEASE HELP PROJECT DUE IN TOMMORROW

[krazykris]

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?

[primalx2003]

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.

[elDonrico]

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>
<font color=white style="background-color: 3E3E3E;">#SEE#</font ft>
</cfif>
</cfoutput>