Inline problems!!!

[mattw]

Hi

I have made an iquiry before on the topic, but have had no luck with trying to figure out a solution

I would like to have a search page that is directed to two or more databases. I have been told I can use portals/relationships aswell as inlineactions.

I currently have a single search page that searches a caclulation field in the 04 Numbers db. and the same set up for the 05 Numbers db.

I am not sure if I can use a calculation field for the search perameter in an inlineaction or not!

My very ugly guess at an inline is as such....( and of course it doesn't work!!! Keep in mind my true inexperience!!

<P><FMP-InlineAction: -db=04 Numbers, -lay=04index, -find <!-- I have noticed this line is referred to like [FMP-InlineAction:...]if I use these brackets[] it shows up on the web page like that?-->

<FORM ACTION="FMPro" METHOD="POST">

<P><INPUT TYPE="hidden" NAME="-db" VALUE="04 Numbers">

<INPUT TYPE="hidden" NAME="-format" VALUE="search_results.htm">

<INPUT TYPE="hidden" NAME="-lay" VALUE="04index">

<INPUT TYPE="hidden" NAME="-recid" VALUE="FMP-CurrentRecid">

<INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm">

<INPUT TYPE="hidden" NAME="-max" VALUE="25">

<INPUT TYPE="hidden" NAME="-lop" VALUE=OR>

</FORM></P>

<FMP-InlineAction: -db=05 Numbers, -lay=05index, -find<!--Not sure if i need this?...then again Iam not sure of any of it!>

<FORM ACTION="FMPro" METHOD="POST">

<P><INPUT TYPE="hidden" NAME="-db" VALUE="05 Numbers">

<INPUT TYPE="hidden" NAME="-format" VALUE="search_results04.htm">

<INPUT TYPE="hidden" NAME="-lay" VALUE="05index">

<INPUT TYPE="hidden" NAME="-recid" VALUE="FMP-CurrentRecid">

<INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm">

<INPUT TYPE="hidden" NAME="-max" VALUE="25">

<INPUT TYPE="hidden" NAME="-lop" VALUE=OR></P>

<!--Not sure where to put this, inside the action or out!

<P><FONT SIZE="+1"><B>Search:</B></FONT><B>

</B><INPUT TYPE=text NAME=findit <!--calculation field--> VALUE="" SIZE=39>

<INPUT TYPE="submit" NAME="-Find" VALUE="Start Search"></P>

</FORM>

</FMP-InlineAction>

My luck with portals is no better. When I try to create a relationship I get the message - This name cannot be used in a calculation formula because it contains +-*...etc.

Any help would be more than appreciated!!!

[mattw]

OK I just clued in that these [brackets] means it's a tag

[Keith M. Davie]

Two potential trouble points which I see:

1. db file names. It is best to avoid the use of spaces in names. Try renaming as 04_Numbers or 04Numbers.

2. the -lop does not work as advertised by FMI. If you look at the examples which they provide, JavaScript is REQUIRED to force the tags to somewhat work. These tags do not work with cdml/html alone. Think Different or learn JavaScript.

SIMPLIFY ...

Keith

[flexistentialism]

If you post your code between the "CODE" tags none will be rendered on this forum. can make things a lot easier

I noticed the FMP-CurrentRecID tag is missing square brackets.

I'm not sure what you're trying to do (not meant in a negative way!!!) the Inline action has a find action in it but no criteria for WC to find on you should use a -findall if you don't specify specific field values for a record(s) that you want to find.

If you're trying to find all the records in a specific database and display them so they can be selected individually you also need a [FMP-Records] record detail goes here [/FMP-Records] (I think thats the right tag for Web Companion) this will repeat all the HTML / CDML between the tags for each record in the database.

As far as the portals go....You need to be carefull what you try to call fields, relationships etc there are certain "reserved" characters which are used for calculations, delimiters etc etc if you try and put any of these characters in any names you will get an error, use only alphanumeric characters (numbers and letters (english alphabet in GB or USA)).

I would also advise getting a good book to help with writing good code, there are a few recommended on the filemaker website (i think!)

keep going it's worth it when it works (honest!)