returning results.

June 12, 200223 yr

i'm performing a find and want to return the results. each result must be in an html <table> or <div> tag. thats just how it has to be, trust me. the problem is, i want to tile the results across the screen, from left to right, and then top to bottom.

i cant think of any way to do this with any of the CDML tags. any help?

June 12, 200223 yr

<tr>[FMP-Record]

<td>[FMP-Field: field1]</td>

[/FMP-Record]</tr>

</table>

is a start for horizontal search results but can you give me some more info on how it should be on screen?

Just one field?

Is it not possible to create a calculation field "newrow" that says:

If(Mod(Status (CurrentRecordNumber), 10)=0, "</tr><tr>", "")

it should look like this than:

<tr>[FMP-Record]

<td>[FMP-Field: field1]</td>[FMP-Field: newrow]

[/FMP-Record]</tr>

</table>

edit: if it works please let me know and if I made some mistakes, I will post it on http://www.ib2.nl/filemaker/ then. You also may submit it of course

June 12, 200223 yr

Author

hi,

that is exactly what i needed. i hadn't thought of the Status(CurrentRecordNumber) thing. thanks a million,

tim.

June 13, 200223 yr

Here is a Javascript for placing a sorted find into three colums:

	<script language="Javascript">

var z = 0;

var aCustomers = new Array();

var aCustomerIDs = new Array();

var iCustCount = [FMP-CurrentFoundCount] ;

var rows = Math.ceil(iCustCount / 3) ;

[FMP-Record]

aCustomers[z] = "[FMP-Field:cust_name, raw]" ;

aCustomerIDs[z] = "[FMP-Field:cust_id]" ;

z += 1 ;

[/FMP-Record]

function addbusiness(cust)

{

var cust ;

document.newquotefm.cust_id.value = cust ;

document.newquotefm.submit() ;

}

</script>

</head>

Click on a Customer Name for new quote:

<table>

for(j = 0; j< rows; j++)

{

document.write("<tr><td><a href=Javascript:addbusiness('" + aCustomerIDs[j] + "');>" + aCustomers[j] + "</a></td>");

document.write("<td><a href=Javascript:addbusiness('" + aCustomerIDs[j + rows] + "');>" + aCustomers[j + rows] + "</a></td>");

document.write("<td><a href=Javascript:addbusiness('" + ((aCustomerIDs[j + (2 * rows)] === (void 0)) ? '':(aCustomerIDs[j + (2 * rows)])) + "');>" + ((aCustomers[j + (2 * rows)] === (void 0)) ? '':(aCustomers[j + (2 * rows)])) + "</a></td></tr>");

}

</script>

</table></body>

The results run sorted down a colum then onto the next colum.

Hope this is of interest.

Garry

June 14, 200223 yr

don't you think my solution is cool enough

June 15, 200223 yr

The CDML is a good method, nice and neat! However, the Javascript is good if you want to take some of the processing away from the server, and if you want to 'fiddle' with sorts and the direction in which they are displayed.

It is one I used some time ago, so it has just been copied-and-pasted from that application.

Good to see a couple of alternatives.

All the best.

Garry

June 15, 200223 yr

I just read Timmys post on the ODBC forum. Here is a simple method:

<table><tr>

if ((i % nCols) == 0)

{ document.write("<td>[FMP-Field:name]</td></tr><tr>") ; }

else

{ document.write("<td>[FMP-Field:name]</td>") ; } ;

i++ ;[/FMP-Record]

</script></tr></table>

This is as straightforward as ASP, PHP etc.

All the best.

Garry

June 17, 200223 yr

Author

Sharky.

It doesn't work for me. It works fine when I'm doing a find all, but when I search for anything, it seems that the Current Record Number doesn't get updated. I posted a question on this in this forum. Thanks for the help,

Tim.