Hi, I have a button on our contact list which returns a page from a 'departments' database with a portal from the contact list showing the members of that department. This has worked for so long I'd forgotton about it.

But now I'm trying to get the same result from a URL and I can't get the portal to display, just the departments.

I've taken all the search variables out uf the URL so it's just:

http:/mydomain.com/FMPro?-db=departments&-layout=layout1&-format=printpage.htm&-error=search_error.htm&-FindAll

The form code is:

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

<INPUT TYPE="submit" NAME="-Find" VALUE="show list">

<INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE=hidden NAME="master contact list::company" VALUE=william>

<INPUT TYPE="hidden" NAME="-DB" VALUE="departments">

<INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1">

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

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

<INPUT TYPE="hidden" NAME="-SortField" VALUE="department">

<INPUT TYPE="hidden" NAME="-SortORder" VALUE="Ascending">

<INPUT TYPE="hidden" NAME="-SortField" VALUE="master contact list::surname">

<INPUT TYPE="hidden" NAME="-SortORder" VALUE="Ascending">

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

</FORM>

----------------------------- and the results page--------------------

<TABLE BORDER=0 CELLSPACING=0 WIDTH=210>[FMP-RECORD]

<TR>

<TD WIDTH=206>

<P><B><TABLE BORDER=0 CELLSPACING=0 WIDTH=206>

<TR>

<TD>

<P>[FMP-FIELD: department]</P>

</TD>

</TR>

<TR>

<TD>

<P ALIGN=right>[FMP-FIELD: master contact list::floor]

floor

[FMP-FIELD: master contact list::building]</P>

</TD>

</TR>

</TABLE>

[FMP-PORTAL: master contact list]

<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=200>

<TR>

<TD WIDTH=130>

<P>[FMP-FIELD: master contact list::wholename]</P>

</TD>

<TD WIDTH=58>

<P ALIGN=right>[FMP-FIELD: master contact list:: phone ext]</P>

</TD>

</TR>

</TABLE>

[/FMP-PORTAL]</B></P>

</TD>

</TR>

<TR>

<TD WIDTH=206>

<P></P>

</TD>

</TR>[/FMP-RECORD]

</TABLE>

I cannot spot your mistake. Is the portal on layout "Layout1" in database 'departments'?

I think there is an issue with name 'departments'

It will be better to use 'departments.fp5’

Hi, yes the portal's in the layout and what's so puzzling is that it works fine when I use the form to make the search, but I just can't seem to write a URL string that'll do the same thing.

Take a look at the page: http://www.william-reed.net:591/Contact_list/search_copy.htm

Based on the URL string you submitted, you have a "-Layout" this should be a "-Lay". The databae in the -db tag does NOT need to have a .fp5 or .fp3, there cannot be two different versions of web companion werving on the same port, FileMaker knows this so it substitutes for whichever verion of the web companion is serving on that port.

Yes, that's absolutely right! I've just swopped it for -lay. As soon as I put the right syntax in, it's worked.

Now I have to get it working with inlines .......................

yep, that's working. too!

What I was trying to do was to make that list display in 3 columns so that it prints properly onto a page using an inline action for column 2 and 3 and the "skip" tag.

Thanks guys ..........been a long week

regards, Jeff

[ September 28, 2001: Message edited by: Jeff Spall ]

Good show!

In above example it was correct: <INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1">