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

[Derrick Fogle]

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