draad

Thanks for pointing this out, that was my mistake. Issue resolved, thanks to you !

Hello, Â I'm trying to create a schedule script that will run every 20 min, but I can't get it working. Actually, I created the schedule, if I run it, it's working, but it wont run every 20min. Â Please, see attached file to see how I did my setup, as you can see, blue underlined script named "Update running campaign status" should run every 20min, but if you check the "Next Run" state, it will run only once next day. Â Â Am I missing something? Â Â Thanks for your help. Â Â PS : Of corse I tried to wait to see if this was just a display related issue, but the script will really not run until the next day.

Hello everyone. I'm plyaing for the first time with filemaker PHP API, and, even if I succeed on doing a basic newFindRequest (), I'm stuck on something that must be very simple but I can't get working. I have a layout called "Php Ipv4 Blocks" linked to a table that keep tracks of IPs as long and the country associated to thoses IPs. My table structure looks like this : In my php script, I transform an ip to a long value and then, I try to perform a newFindRequest() where I use this function to transfor IP to long : $longIp = printf("%un", ip2long($IP)); If I try with a random ip, for exemple : 173.176.47.188 Converted as long I find this value : 2914004924 So now, I try to perform my find : function getCountryForIp ($IP){ $longIp = printf("%un", ip2long($IP)); $findCommand = $GLOBALS["fm"]->newFindCommand("Php Ipv4 Blocks"); $findCommand->addFindCriterion("integer_ip_from", '<=' . $longIp); $findCommand->addFindCriterion("integer_ip_to" , '>=' . $longIp); $result = $findCommand->execute(); if (FileMaker::isError($result)) { echo $result->getCode(); echo $result->getMessage(); echo "No country found"; return false; } else { $record = $result->getFirstRecord(); $country = $record->getField("country_id"); echo "country id " . $country; return true; } This will return me : 401 No records match the request. Note that if for testing purpose I replace my var $longIp and input the long value directly I find my record: $longIp = 2914004924; //printf("%un", ip2long($IP)); Can you guys help me on this issue ? Thanks.