returning results.

timmy · June 12, 2002

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?

Sharky · June 12, 2002

<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

timmy · June 12, 2002

hi,

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

tim.

Garry Claridge · June 13, 2002

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

Sharky · June 14, 2002

don't you think my solution is cool enough

Garry Claridge · June 15, 2002

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

Garry Claridge · June 15, 2002

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

timmy · June 17, 2002

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.

Sharky · June 17, 2002

did you make sure the field isn't stored (see store options below the calculation)

Sign In

returning results.

Recommended Posts

timmy

Sharky

timmy

Garry Claridge

Sharky

Garry Claridge

Garry Claridge

timmy

Sharky

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information