InlineAction help!!

[Denniz]

Hi!

I've got a question about the InlineAction tag.

I want the last record from type "news_topics" show on my index page with another type (http://127.0.0.1:95/sdugb/fmpro?-db=mywebsite.fp5&-lay=web&-format=index.html&type=portfolio_links&-find)

i've tried:

[FMP-InlineAction: -db=mywebsite.fp5="1", -lay=web, -sortfield=datum_start, -type=news_topics, -sortorder=descending, -FindAll]

[FMP-RECORD][FMP-FIELD: titel][/FMP-InlineAction][/FMP-RECORD]

Can somebody tell me what i do wrong??

(Im using a filemaker 5 database in a Filemaker 6 environment.)

Dennis

[Denniz]

never mind, got the answer! that "1" has to be -max=1.

Another problem:

[FMP-InlineAction: -db=mywebsite.fp5,-max=20, -lay=web, -sortfield=datum_start, type="jobs", -sortorder=descending, -FindAll]

[fmp-record]<tr>

<td width="24" align="center" valign="middle"><img src="images/rd.gif" width="8" height="8" border="0"></td><td align="left" valign="middle"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular" size="1">[fmp-field:titel]</font></td></tr>

[/fmp-record]

[/FMP-InlineAction]

Question:

There are only three records at this moment in "Jobs". The InlineActions shows those three records on top but shows the other records too! Isn't that strange if i say just to show the records in "jobs"?

please help!!

Dennis

[Denniz]

ok, just remove the -max=20 lol

God, what a nice forum! ;-)

[Jeff Spall]

hi, in the first one, if you're only looking for 'news topics', then the action should be "Find", not "FindAll", and close the inline after the [/FMP-record] tag

so to show the one latest news item (is that what the "datum_start" sort order would do?):

[FMP-InlineAction:-db=mywebsite.fp5,-lay=web,-sortfield=datum_start,-sortorder=descending,-op=eq,type=news_topics,-Find]

[FMP-RECORD][FMP-FIELD: titel][/FMP-RECORD][/FMP-InlineAction]

you can get away without specifying the layout if there are no portals or related fields to show and if you leave out the -op Filemaker will default to 'eq'. NOTE, though that ther's no '-' between the operator and the field name.

in the second one, try:

[FMP-InlineAction:-db=mywebsite.fp5,-lay=web,-sortfield=datum_start,-op=eq,type="jobs",-sortorder=descending,-max=20,-Find]

[fmp-record].......

regards, jeff

[Denniz]

thanks but i have the answer written above your reply..it works!!!

Thanks anyway Jeff