Re: avoid listing empty fields in a record?

From: Kathleen Anderson [MVP - FP] (spiderwebwoman_at_mvps.org)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 06:14:33 -0500

Greg:
Wrap the DatabaseResultColumn display area in a bit of 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" i-CheckSum="33247" endspan --></li>

  <% End If %> 

-- 
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Greg <anonymous@discussions.microsoft.com> wrote:
> i have a table with just one field listed.  with this,
> some of my records are empty which of course leaves an
> empty spot which is what i want.  when i have the DB Wiz
> displaying all this on a page, it leaves a space where
> that record is empty.  I want it to just list the records
> with info in it and not the blank ones which leave a
> gap.  how do i do this?  Thanks!