[FX.php List] Running a FM script in FM 7 Server Adv ?

[Ankur Goyal]

Thanks for a quick reply, really appreciate it.

Yes, I can directly use PHP to send an email, but there a calculation  
I'm doing in the database:
Only after a certain days I want to send an email to a set of users !  
but I don't know how I am going to automate this event using PHP only ??

Somehow, I need to have this event trigger automatically, whenever  
that record in the database full-fill a criteria !

Any idea in this direction ??
Thank you so much for your help.

Ankur

On Jan 23, 2006, at 9:58 AM, Derrick Fogle wrote:

> The OpenURL script step doesn't work on server under that scenario.  
> Why aren't you directly using PHP to send the mail?
>
> On Jan 23, 2006, at 11:48 AM, Ankur Goyal wrote:
>
>> Hello everyone,
>>
>> I am running a database application using two MACs, one for  
>> FileMaker 7 Server Adv. and another one for Web-Server.
>>
>> I am calling a FM script from my web page, and it seems that the  
>> script works partially.
>>
>> Here is my web page code:
>>
>> 	include_once("../FX/FX.php");
>> 	include_once('../FX/FMErrors.php');
>> 	include_once('../FX/server_data.php');
>> 	$q2 = new FX( '****', '80' );
>> 	$q2->SetDBData('Test.fp7','Test','all');
>> 	$q2->SetDBPassword('***','Admin');
>> 	$q2->AddDBParam('-script','PHPemail');
>> 	$q2->AddDBParam('Day1','2');
>> 	$r2 = $q2->FMFind();
>> 	foreach($r2['data'] as $key=>$searchData2){
>> 		echo $searchData2['Today'][0]."-".$searchData2['email1'][0]."-". 
>> $searchData2['Eflag1'][0]."<br>";									
>> 	}
>>
>> And here is the "PHPemail" in the "Test.fp7" database:
>>
>> If [ Test::Day1 < 7]
>> 	Open URL [No dialog; "http://****/email.php"]
>> 	Set Field [Test::Eflag1; 2]
>> End If
>> End Script []
>>
>>
>> So the problem is, when I run my web page, I believe it executes  
>> this script, because it changes the value of "Eflag1" to 2 in the  
>> database but it doesn't open the URL I specified under "Open  
>> URL"....any idea, why ??
>>
>> I would really appreciate for any guidance/comments, thanks !!
>>
>> Sincerely,
>> Ankur
>>
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> Derrick Fogle
> derrick at fogles.net
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list