Frontpage 2003 / Access / Database Results / Address

[Andy Watts]

Hi,

I'm trying to show an address list on a page using Frontpage's database
results wizard. I'm retrieving the data fine, but where there is no data
the line is just a blank (<br>) and populates where there is data.

What I'm trying to achieve is a solution where those blanks aren't displayed
and the data shuffles up so it displays seamlessly - the same as a Word mail
merge I guess is comparable - but just cannot figure out how to do it. I
don't wish to amend the data source so that it is in consecutive fields as
this will cause problems when I go to online update fields and query fields
in the future.

I have tried the trim statement in Access to create a query which does this,
but then that just comes out in one long line.

Any help would be much appreciated - I have trawled around all over the
place but cannot find an answer.

Many thanks
Watsy

 

[Kathleen Anderson [MVP - FP]]

Wrap the DatabaseResultsColum in some script - like this:

<% If fp_rs("Municipality") > " " then %>

<li><b>Municipality:</b>&nbsp;<!--webbot bot="DatabaseResultColumn"
startspan

s-columnnames="ProgramArea,RecordNum,Date,ItemNumber,SplitItem,Session,PA_SA
,ActNumber,Section,Recipient,Municipality,FundsUse,DollarField1,DollarField2
,DollarField3,DollarField4,Any_Previous,DollarField5,FundNum,AgencyNum,SID,P
roject_Num,Description"
s-column="Municipality" b-tableformat="FALSE" b-hashtml="FALSE"
clientside
preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Municipality&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" b-makelink
b-MenuFormat --><%=FP_FieldVal(fp_rs,"Municipality")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33247" --></li>

<% End If %>