Drop down box query no.2

[Chris]

Thanks for the prompt reply and all the info.

A question from the reply.
"""........
It's usual to use the pipe (|) to split up fields, so you might have
something like
<option

Then on the receiving page you'd do
<%
aTemp = split(request.form("DropDown"), "|")
url = aTemp(0)
reference=aTemp(1)
%>

............."""

I would like to know if at all possible once the details captured by the
form are sent to the database it is then listed as one field eg in my
case"URL"

On using this field in the database retrieval (Results) how does one split
the field there I only see the field "URL"

"''..........
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="61875" --><ul
dynamicoutline initcollapsed>
<li>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,ID1,Province,City,Name,Cell,Land,Fax,Email,Postal,Physical
,Payment,Name2,Cell2,Land2,Fax2,Email2,Postal2,Physical2,Tradingas,URLPurcha
se,Remote_computer_name,User_name,Browser_type,Timestamp,Reference"
s-column="Tradingas" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Tradingas&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"Tradingas")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="21533" --><ul>
<li>
<a target="main" href="<%=FP_FieldLink(fp_rs,"URLPurchase")%>">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,ID1,Province,City,Name,Cell,Land,Fax,Email,Postal,Physical
,Payment,Name2,Cell2,Land2,Fax2,Email2,Postal2,Physical2,Tradingas,URLPurcha
se,Remote_computer_name,User_name,Browser_type,Timestamp,Reference"
s-column="URLPurchase" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;URLPurchase&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;"
startspan --><%=FP_FieldVal(fp_rs,"URLPurchase")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="28154" --></a></li>
</ul>

......."''


What i would like to do is have a part of the field show up in the results
and when clicked it must hyperlink to the attached "url" and include some
parameters.

Once again thanks for your patients and your time.

Cheers

Chris

 

[Jim Buyens]

In a custom SQL statement, you could define a calculated field like:

SELECT '<a href="' & replace([urlfield],'|','">') & '</a>' as hlink, ...

So, if urlfield contains http://www.microsoft.com|Microsoft you get
<a href="http://www.microsoft.com">Microsoft</a>

However, this seems fairly convoluted compared to keeping the URL and the
hyperlink text in separate fields.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------