Database Question: Hyperlink with URL ref. not working

[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]

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

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

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>

 

[Kathleen Anderson [MVP - FrontPage]]

You don't say what version of FrontPage you running, but if it's FrontPage
2003, have you applied SP-1? I believe this problem may be fixed by the SP.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx