Database Question: Hyperlink with URL ref. not working

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi I was wondering if any of the seriously advanced guys could just take a
look at this and steer me in the right direction please.

I am baffled as this has worked for me before ????

I have a table that I reference in a database results.
In the table I have a value(URL) that I want to attach to the corresponding
word.

All works fine until I attach the Hyperlink.
In the hyperlink edit box I use the URL in the path section
and place my criteria in the Query string box.

The placements are as follows
Path----------<%=FP_FieldLink(fp_rs,"Marketplacements")%>
and the Query sting box is---------------<%=FP_FieldURL(fp_rs,"Tradingas")%>


On accepting the path and Parameters the address is as follows
----------<%=FP_FieldLink(fp_rs,"Marketplacements")%>?Tradingas=FP_FieldURL(
fp_rs,"Tradingas")%>

when opening again it has changed
to----------------------%3c%25=FP_FieldLink(fp_rs,%22Marketplacements%22)%25
%3e%3c%25=FP_FieldLink(fp_rs,%22Tradingas%22)%25%3e

or something similar.

When publishing to the web and clicking on the link however the page
displays as cannot be found.

So can any of you Please help me solve this.Any help would be gratefully
accepted

Thanks.
XChris
 
Chris said:
Hi I was wondering if any of the seriously advanced guys could just take a
look at this and steer me in the right direction please.

I am baffled as this has worked for me before ????

I have a table that I reference in a database results.
In the table I have a value(URL) that I want to attach to the corresponding
word.

All works fine until I attach the Hyperlink.
In the hyperlink edit box I use the URL in the path section
and place my criteria in the Query string box.

The placements are as follows
Path----------<%=FP_FieldLink(fp_rs,"Marketplacements")%>
and the Query sting box
Click to expand...
is--------------- said:
On accepting the path and Parameters the address is as follows
----------<%=FP_FieldLink(fp_rs,"Marketplacements")%>?Tradingas=FP_FieldUR L(
fp_rs,"Tradingas")%>

when opening again it has changed
to----------------------%3c%25=FP_FieldLink(fp_rs,%22Marketplacements%22)%25
%3e%3c%25=FP_FieldLink(fp_rs,%22Tradingas%22)%25%3e

or something similar.

When publishing to the web and clicking on the link however the page
displays as cannot be found.

So can any of you Please help me solve this.Any help would be gratefully
accepted

Thanks.
XChris
Click to expand...


The actuall code snipp:

<td bgcolor="#808000"><font face="Arial Unicode MS">
<a target="_blank"
href="<%=FP_FieldLink(fp_rs,"Marketplacements")%>?Tradingas=<%=FP_FieldURL(f
p_rs,"Tradingas")%>&Categories=<%=FP_FieldURL(fp_rs,"Categories")%>">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,Tradingas,Province,City,Suburb,Categories,Subcategory,List
ing,Name,Birthdate,Cell1,Landline1,Email1,Address,Area,Code,Urlpage,Referenc
e,Codename,Password,Remote_computer_name,User_name,Browser_type,Timestamp,Xt
raadds,Partnersname,BdateP,CellP,LandlineP,EmailP,Website,Blankurl,Referrals
,invoices,Messages,Friendorfoe,Workpool,Marketplacements"
s-column="Marketplacements" b-tableformat="TRUE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Marketplacements&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Marketplacements")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="40997" --></a></font></td>
</tr>
 
Back
Top