html tables + data

[Anatoli]

The URL is dead.

Anyway, put RECORD tag

then TR

TD /TD

TD /TD

/TR

RECORD end.

[instigator]

thanks... well i tried that and it just formatted the table into 1 column and 30 rows instead of the 13 columns and 1 row i need...

thanks anyway...

[instigator]

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>

[Anatoli]

I am sorry, I've misunderstood your requirements.

Usually there are the multiple row requirements.

Dynamic Columns are a bit problematic, but do the similar for TD and do not put anything more into the table.

[Keith M. Davie]

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

[instigator]

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...

[instigator]

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...

[instigator]

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!

[yafreax]

password protect your databases, anyone with FM can access your Portfolio.fp5 through tcp/ip and have full reign (except define fields) over your database.

Enjoy

Jeremy