MaureenKLM
Tue Jun 05 12:07:07 CDT 2007
Silly of me - the end if clause didn't save as part of the file becasue I
can't edit FP BOT codes - it just reverts back to what it was before.
Therefore, I'm unable to edit the code as you suggest. I've played with some
other placement attempts but am unsuccessful in getting the detail to print
out - any more suggestions? The "TIP" seemed so simple....I've no idea why
this is not working...
"MaureenKLM" wrote:
> Didn't work - now the page completely errors out - here's the code showing
> where I put the end if stmt
>
> <!--#include file="_fpclass/fpdbrgn1.inc"-->
> <!--webbot bot="DatabaseRegionStart" endspan i-checksum="10259" -->
> <%
> If fp_rs("Team") <> savedID Then
> savedID = fp_rs("Team")
> %>
> <tr>
> <td>
> <!--webbot bot="DatabaseResultColumn"
> s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> s-column="Team" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
> clientside b-MenuFormat preview="<font size="-1"><<</font>Team<font
> size="-1">>></font>" startspan
> --><%=FP_FieldVal(fp_rs,"Team")%><!--webbot bot="DatabaseResultColumn"
> endspan i-checksum="4800" --></td>
> <td>
> <!--webbot bot="DatabaseResultColumn"
> s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> s-column="Logo" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
> clientside b-MenuFormat preview="<font size="-1"><<</font>Logo<font
> size="-1">>></font>" startspan
> --><%=FP_FieldVal(fp_rs,"Logo")%><!--webbot bot="DatabaseResultColumn"
> endspan i-checksum="5578" --></td>
> <td>
> <!--webbot bot="DatabaseResultColumn"
> s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> s-column="PlayerName" b-tableformat="TRUE" b-hashtml="FALSE"
> b-makelink="FALSE" clientside b-MenuFormat preview="<font
> size="-1"><<</font>PlayerName<font size="-1">>></font>" startspan
> --><%=FP_FieldVal(fp_rs,"PlayerName")%><!--webbot bot="DatabaseResultColumn"
> endspan i-checksum="28756" --></td>
> </tr>
>
> <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
> b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
> clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
> align="left" width="100%"><font color="#000000">This is the end of a Database
> Results region.</font></td></tr>"startspan --><!--#include
> file="_fpclass/fpdbrgn2.inc"-->
> <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
> </table>
>
> </body>
>
> </html>
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
> > I think the
> > <%
> > End If
> > %>
> >
> > should be after the </td></tr>
> >
> > just before the
> >
> > startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
> > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" -->
> >
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > web:
http://www.spiderwebwoman.com/resources/
> > Please reply to the newsgroup for the benefit of others.
> >
> >
> >
> >
> > "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
> > news:72931D80-2298-47FE-8983-B90A9B8D40B5@microsoft.com...
> > > THANKS SO MUCH!!
> > >
> > > <!--#include file="_fpclass/fpdbrgn1.inc"-->
> > > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="10259" -->
> > > <%
> > > If fp_rs("Team") <> savedID Then
> > > savedID = fp_rs("Team")
> > > %>
> > > <tr>
> > > <td>
> > > <!--webbot bot="DatabaseResultColumn"
> > > s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> > > s-column="Team" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
> > > clientside b-MenuFormat preview="<font size="-1"><<</font>Team<font
> > > size="-1">>></font>" startspan
> > > --><%=FP_FieldVal(fp_rs,"Team")%><!--webbot bot="DatabaseResultColumn"
> > > endspan i-checksum="4800" --></td>
> > > <td>
> > > <!--webbot bot="DatabaseResultColumn"
> > > s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> > > s-column="Logo" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
> > > clientside b-MenuFormat preview="<font size="-1"><<</font>Logo<font
> > > size="-1">>></font>" startspan
> > > --><%=FP_FieldVal(fp_rs,"Logo")%><!--webbot bot="DatabaseResultColumn"
> > > endspan i-checksum="5578" --></td>
> > > <td>
> > > <!--webbot bot="DatabaseResultColumn"
> > > s-columnnames="Team,ID,PlayerFirst,FamLast,PlayerLast,Last,Division,Grade,Level,Post,Logo,PlayerName"
> > > s-column="PlayerName" b-tableformat="TRUE" b-hashtml="FALSE"
> > > b-makelink="FALSE" clientside b-MenuFormat preview="<font
> > > size="-1"><<</font>PlayerName<font size="-1">>></font>"
> > > startspan
> > > --><%=FP_FieldVal(fp_rs,"PlayerName")%><!--webbot
> > > bot="DatabaseResultColumn"
> > > endspan i-checksum="28756" --></td>
> > > </tr>
> > > <%
> > > End If
> > > %>
> > > <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
> > > b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
> > > clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
> > > align="left" width="100%"><font color="#000000">This is the end of a
> > > Database
> > > Results region.</font></td></tr>" startspan --><!--#include
> > > file="_fpclass/fpdbrgn2.inc"-->
> > > <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
> > > </table>
> > >
> > > </body>
> > >
> > > </html>
> > >
> > >
> > >
> > > "Kathleen Anderson [MVP - FrontPage]" wrote:
> > >
> > >> Can you post the code beginning with:
> > >>
> > >> <!--#include file="../_fpclass/fpdbrgn1.inc"-->
> > >> > <!--webbot bot="DatabaseRegionStart" endspan i-checksum="24181" -->
> > >>
> > >>
> > >> through the end of the page?
> > >>
> > >> --
> > >>
> > >> ~ Kathleen Anderson
> > >> Microsoft MVP - FrontPage
> > >> Spider Web Woman Designs
> > >> web:
http://www.spiderwebwoman.com/resources/
> > >> Please reply to the newsgroup for the benefit of others.
> > >>
> > >>
> > >>
> > >>
> > >> "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
> > >> news:2EF02A58-3E49-423E-8B5D-B01EA18DF3AA@microsoft.com...
> > >> > Fantastic - location is everything...well almost everything.
> > >> >
> > >> > I now have ONE LINE per team - each team has 9 players that should
> > >> > display
> > >> > but only the first is displaying. I have the relationship of
> > >> > ONE-TO-MANY
> > >> > established for the 1st field in the results (TEAM) and the qry used as
> > >> > the
> > >> > source is sorted by team initially. Any clue what I'm missing now?
> > >> >
> > >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> > >> >
> > >> >> Find this in your page:
> > >> >>
> > >> >> <!--#include file="../_fpclass/fpdbrgn1.inc"-->
> > >> >> <!--webbot bot="DatabaseRegionStart" endspan i-checksum="24181" -->
> > >> >>
> > >> >> there should be a <tr> immediately following it - that's the one
> > >> >> you're
> > >> >> looking for.
> > >> >>
> > >> >>
> > >> >> --
> > >> >>
> > >> >> ~ Kathleen Anderson
> > >> >> Microsoft MVP - FrontPage
> > >> >> Spider Web Woman Designs
> > >> >> web:
http://www.spiderwebwoman.com/resources/
> > >> >> Please reply to the newsgroup for the benefit of others.
> > >> >>
> > >> >>
> > >> >>
> > >> >>
> > >> >> "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
> > >> >> news:7E16407F-D8F6-409B-A889-60EA5924D880@microsoft.com...
> > >> >> >I think I may be inserting the code in the wrong place. It's unclear
> > >> >> >to
> > >> >> >me
> > >> >> > exactly where the suggested code should be inserted. What starts
> > >> >> > the
> > >> >> > "master
> > >> >> > table results" area and what ends it? Is it the header row? Is it
> > >> >> > the
> > >> >> > detail row? Somewhere in between?
> > >> >> >
> > >> >> > My page - WITHOUT the code to adjust the line breaks - is at
> > >> >> > www.chestersummerbasketball/csb/teamsdivision.asp I want the Team
> > >> >> > Name
> > >> >> > and
> > >> >> > Team Logo to appear only once for each team - the player names
> > >> >> > shoudl
> > >> >> > be
> > >> >> > listed horizontally under each team name/logo. Only the girls 7-8th
> > >> >> > division
> > >> >> > has team names entered so far.
> > >> >> >
> > >> >> > THANK YOU!
> > >> >> >
> > >> >> >
> > >> >> > "MaureenKLM" wrote:
> > >> >> >
> > >> >> >> Thanks for the link -
> > >> >> >>
> > >> >> >> I tried to implement it but am getting a "type mismatch" error on
> > >> >> >> fp_rs.
> > >> >> >> The field I am using to determine when the detail row should change
> > >> >> >> it's
> > >> >> >> header is a TEXT field, not a number field. Would this make a
> > >> >> >> difference?
> > >> >> >>
> > >> >> >>
> > >> >> >>
> > >> >> >> "Kathleen Anderson [MVP - FrontPage]" wrote:
> > >> >> >>
> > >> >> >> >
http://www.spiderwebwoman.com/thingumajig/one_to_many.htm
> > >> >> >> >
> > >> >> >> > --
> > >> >> >> >
> > >> >> >> > ~ Kathleen Anderson
> > >> >> >> > Microsoft MVP - FrontPage
> > >> >> >> > Spider Web Woman Designs
> > >> >> >> > web:
http://www.spiderwebwoman.com/resources/
> > >> >> >> > Please reply to the newsgroup for the benefit of others
> > >> >> >> >
> > >> >> >> >
> > >> >> >> > "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in
> > >> >> >> > message
> > >> >> >> > news:07F65D2E-BB3E-4AE2-B612-B55B0393A58E@microsoft.com...
> > >> >> >> > > FP 2002 with an Access 2002 DB
> > >> >> >> > >
> > >> >> >> > > I have a DBR that lists names of players on teams. There are
> > >> >> >> > > several
> > >> >> >> > > diferent teams with numerous players per team. I'd like to
> > >> >> >> > > have
> > >> >> >> > > the
> > >> >> >> > > team
> > >> >> >> > > name (a separate field) and team logo (separate field linked to
> > >> >> >> > > graphic)
> > >> >> >> > > appear ONCE and then the list of team members listed out in a
> > >> >> >> > > horizontal
> > >> >> >> > > line
> > >> >> >> > > towards the right -
> > >> >> >> > >
> > >> >> >> > > Any ideas on how to do this?
> > >> >> >> >
> > >> >> >> >
> > >> >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >