wmoerdijk

It may sound strange, but this is normal. When you do not specifiy a find it will return all. To force a find you can put in a hidden field with no data, this will force an actual find request. <input type="hidden" name="author" value=""> To link to several detail pages you can use the [FMP-Linkrecid] tag. With this you can link to a next page from the same Filemaker record. <A HREF="[FMP-linkrecid: layout=WebFormII, format=Detail2.html]">Click here for detail page 2</a>

In my experience you can use the <img src="[FMP-Image: Containerfield]"> syntax only for images from the current database. A calculation that gets the image from another file will not display in CDML. In your case this probably means using an inline in conjunction with an FMP-IF to display the image. For example [FMP-IF: Field .eq. 1] [FMP-InlineAction: -db=images, -lay=images, ImageName="gray",-find]<img src="[FMP-Image: Imagefield]">[/FMP-InlineAction] [FMP-Else] [FMP-InlineAction: -db=images, -lay=images, ImageName="green",-find]<img src="[FMP-Image: Imagefield]">[/FMP-InlineAction] [/FMP-IF] Hope this helps, Wouter

Hi, I want to download information from a FM website using XML. The website however user the web security database for added security. When I try to import data using a HTTP request I get an exception saying "could not open file". I know the problem has to do with passing a username and password inside the HTTP request. What I am trying to do now is http://username:password@ipaddress/FMPro?-db=Study&-format=-fmp_xml&-findall This works fine directly from the webbrowser but it does not work from filemaker. Is there any way or workaround to pass the username and password from the web security database in such a XML import request? FileMaker Version: Dev 6 Platform: Windows XP

Thanks Mario! This works great. I am sure I will need more help along the way, but with help like this I am sure I will be up and running in no time. Wouter P.S. I already have another question. How do you handle username/password submissions. Do I use $_SESSION to store the variables or is there a better way. Version: Developer v6 Platform: Windows XP

Hi, I am taking my first steps towards learning fx.php to connect to my databases. I can do the simple stuff like show a list of records and move from a list to a details page for a record. Now I am trying to put together an edit form with dropdownlists and radiobuttons. I am stuck here. This is what I tried: Drop down: <? $TypeList = '<select name="Type">'; foreach ($ReturnedData['data'] as $key => $value){ $TypeList .= '<option selected>'.$value['Type'][0].'</option>'; } $TypeList .= '<option>&lt;----------------------------&gt;</option>'; foreach ($ReturnedValues['valueLists']['Type'] as $value) { $TypeList .= '<option>'.$value.'</option> '; } $TypeList .= '</select> '; echo $TypeList; ?> This does display my dropdown, but the only way I found to show the actual data is to put it on top of the list in an extra line. Although not elegant this could work for a dropdown box. For a radio button I tried: <? $StatusList = ''; $Checked =''; foreach ($ReturnedValues['valueLists']['Status'] as $value) { foreach ($ReturnedData['data'] as $key1 => $value1){ if ($value1['Status'][0] = $value) { $Checked='checked'; }} $StatusList .= '<INPUT TYPE="radio" NAME="Status" VALUE="'.$value.'" '.$Checked.'>'.$value; } echo $StatusList; ?> Wich, needless to say, does not work. It will show the radiobutton but it will mark all values as checked. There must be a better (more simple) way to do this. Any help would be appriciated. Wouter

For me the problem happens with just one user (me) accessing the database over the web. No peer-to-peer access is allowed. The database itself is about 50000 records big and there are recordlevel access restrictions that force the database to do a find even when all records are displayed. This leaves the option open for this problem to occur even when just one user goes to a listview and cancels before it is displayed. Wouter

I posted this before in databases.filemaker but got no respons. I basically have the same workaround that you use. Maybe someone else has a bright idea... Wouter.

Are you sure it is not because they hit the "Enter" key in stead of clicking the "Go" button. It works if I click the "Go" but doesn't when I hit enter (in wich case it will open the detail searchpage as expected). You could try to set the default action in the first form like so: <INPUT TYPE = "hidden" NAME = "-Find" VALUE=" "> But I am not sure how it will work with multiple forms on one page. Wouter

I have had similar problems when a user performes a large search and the user cancelled the action before filemaker was finished processing. In filemaker it looked like the password used on the server to start the databases was overruled by the password I set in the websecurity database. I am not sure it is the same problem. I also did not find a solution nor a workaround yet, so I hope this info helps. I even tried a remotely triggered script to close and reopen the database by means of a "reset" but it only works when I do it manually on the server. Wouter

Not really a secret. The [FMP-CurrentRecID] is the same as the "Status(CurrentRecID)" from filemaker. It is not the serial number you describe. You can still use your CaseNo id as long as you are absolutely sure it is a unique value in your database (so do no use "duplicate"!). Your CDML should look something like: <BODY> <P><FORM ACTION="FMPro" METHOD="post"> <P><INPUT TYPE="hidden" NAME="-db" VALUE="DATABASE.fp5"> <P><INPUT TYPE="hidden" NAME="-LAY" VALUE="CGI"> <P><INPUT TYPE="hidden" NAME="-format" VALUE="CaseDetails.html"> <p><input type="hidden" name="-Max" value=1> <p><input type="hidden" name="-op" value="eq"> CaseNo: <INPUT TYPE="text" NAME="CaseNo" VALUE="" SIZE=30><br> <INPUT TYPE="submit" NAME="-find" VALUE="Start Search" SIZE=30> <INPUT TYPE="reset" VALUE="Clear Form" SIZE=30> </BODY> If you are not so sure about the uniqueness of your caseno I suggest changing the "Casedetails.html" in a "CaseList.html" where you list all records with the CaseNo. Wouter. P.S. If you use the Web Security Database you can set the Caseno to only accept "ExactSearch". This will also eliminate a "contains" type of search on your field.