Jump to content

html tables + data


This topic is 8521 days old. Please don't post here. Open a new topic instead.

Recommended Posts

hi,

i have a problem that has me stuck for a couple days... i am new to FileMaker but in a week i figured out how to do some cool stuff...

http://www.images.co.uk/new/index2.htm

if you click on 'people' you see the problem right away. i'm trying to drop data into a table that has each column 220 pixels wide. after a couple days in trying different things i finally put a 1x220 pixel gif in the table to have it stay wide enough. but then i got 30 coumns of blank table cells and the 12 coumns of data at the very end... at least they where 220 pixels wide though... argh...

here is the html:

<form action="FMPro" method="POST">

<input type="hidden" name="-DB" value="portfolio"><input type="hidden" name="-Lay" value="bios"><input type="hidden" name="-Format" value="record_detail_reply.htm"><input type="hidden" name="-Error" value="record_detail_error.htm"><input type="hidden" name="-recid" value="[fmp-currentrecid]">

<table border="0" width="150" cellpadding="5" cellspacing="0">

<tr align="right" valign="top">[FMP-RECORD]

<td width="220" align="left" valign="top"><font face="LTUnivers 630 BasicRegular,Arial,Helvetica">[FMP-field:name]<br>

</font><font face="LTUnivers 630 BasicRegular,Arial,Helvetica">[FMP-field:title]<br>

<br>

<br>

</font><font face="LTUnivers 630 BasicRegular,Arial,Helvetica">[FMP-field:bio]<br>

<br>

</font></td>

[/FMP-RECORD]

<td width="220" align="left" valign="top"></td>

</tr>

</table>

Link to comment
Share on other sites

OK. Your problem is not with FileMaker. It is your html formatting.

Copy this code into simpletext or notepad. Name it. Drag and drop to your browser and see if it looks like what you might be trying to achieve. Understand this is just code and will look differently when connected with your db files, and everything fills in.

<p><center>

<table border="1" cellpadding="5" cellspacing="0" width="88.7%">

<tr><td align="center">Name</td><td align="center">Title</td><td align="center">Biography</td></tr>

[fmp-record]

<tr><td width="25%"><font face="verdana,geneva, arial, sans_serif" color="#0000ff" size="+0">[fmp-field: name]</font></td>

<td width="15%"><font face="verdana,geneva, arial, sans_serif" color="#0000ff" size="+0">[fmp-field: title]</font></td>

<td width="60%"><font face="verdana,geneva, arial, sans_serif" color="#0000ff" size="+0">[fmp-field: bio]</font></td></tr>

[/fmp-record]

</table></center>

Peace

Keith M. Davie

Link to comment
Share on other sites

thanks for the tips guys, it's still not quite formatting right, but i've gotten some sleep and i'll try some more variations..

here is a page i've 'hard-coded' so it's not connected to the database in any way... http://64.81.53.94:571/about2.htm

i really would like to have it connected to the databse because i've got it so you can choose which designer shows up first and edit the bios easily...

Link to comment
Share on other sites

this is the most promising result so far...

<table border="0" cellpadding="0" cellspacing="2" width="220">

<tr>

<td><font face="LTUnivers 630 BasicBold,Arial,Helvetica" size="1">[FMP-RECORD][FMP-field:name]</font><font face="LTUnivers 630 BasicRegular,Arial,Helvetica" size="1"><br>

[FMP-field:title]<br>

</font></td>

</tr>

<tr>

<td><font face="LTUnivers 630 BasicRegular,Arial,Helvetica" size="1">[FMP-field:bio][/FMP-RECORD]</font></td>

</tr>

</table>

the problem is that instead of going across the page in columns it goes down the page in one column and a bunch of rows...

argh! any advice? it is finally 220 pixels in a column though... heh heh...

again, here is a hard-coded html version of what i would like it to look like...

http://64.81.53.94:571/about2.htm

any tips appreciated... thanks...

Link to comment
Share on other sites

ok, i figured out what was wrong...

this html works great:

<table border="0" width="2680" cellpadding="5" cellspacing="0" align="left">

<tr align="right" valign="top">[FMP-RECORD]

<td width="220" align="left" valign="top"><font face="LTUnivers 630 BasicBold,Arial,Helvetica" size="1">[FMP-field:name]<br>

</font><font face="LTUnivers 630 BasicRegular,Arial,Helvetica" size="1">[FMP-field:title]<br>

<br>

<br>

</font><font face="LTUnivers 630 BasicRegular,Arial,Helvetica" size="1">[FMP-field:bio, Break]<br>

<br>

</font></td>

[/FMP-RECORD]

<td width="220" align="left" valign="top"></td>

</tr>

</table>

i put a border on the table to see exactly how it was getting built, well.. i could see a bunch of extra columns, this was squishing all the columns together... since i am new to this it looked like somehow there were extra records with no data in them, so i opened the db file and yes, instead of the 13 bios it said i had 24 records, so i deleted those extra records, well after i did that i noticed that all the portfolio records where gone so i figured out that it was showing ALL RECORDS in the html! and now i had deleted the porfolio records in teh database file!

so, i guess i am putting together my Search wrong and grabbing ALL the records instead of the particular records for each page, like just the designer bios...

any tips on moving forward on this?

if you see this : http://www.images.co.uk/new/index2.htm -- click on PEOPLE and you can see it is finally formatted correctly from the database but i'm getting extra slots from the portfolio records at the end... yikes!

Link to comment
Share on other sites

This topic is 8521 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.