[FX.php List] FX.php problem ... Calculated Values not shown

[Stephe Pocock]

Hi and thanks Tim and Joel

There must be something wrong with the database, because I can get it to work with another database with the same config.  When I get a chance I will rebuild the database.

In the meantime I have just created a temporary table in the same file, which I propagate with the required data every 15 minutes using a server schedule.  All seems to be fine now with this work around.

Thanks for the help

Stephen




________________________________
From: Joel Shapiro <jsfmp at earthlink.net>
To: FX.php Discussion List <fx.php_list at mail.iviking.org>
Sent: Friday, 17 July, 2009 1:35:31 AM
Subject: Re: [FX.php List] FX.php problem ... Calculated Values not shown

Hi Stephen

FX.php requires the XML (fmxml) Extended Privelege, not the PHP (fmphp) Extended Privelege (which is required for the FM API).  Is that what you're using?

I've never heard of using the guest account for web access, but if that works, make sure that both FMP files are using the guest account and both are using the fmxml Ext. Priv.

HTH,
-Joel


On Jul 15, 2009, at 9:13 PM, Stephe Pocock wrote:

> Hi
> 
> That rings a bell.  I think I have dramas with this before, and with this database.
> 
> OK, one of the related files is an odbc connection (AM_HBM_MATTER), so I have removed that from my calculation.  The other relationship is to another FM database and that database has the guest account enabled with web access only.
> 
> Thanks Tim
> 
> S
> 
> From: Tim 'Webko' Booth <tim at nicheit.com.au>
> To: FX.php Discussion List <fx.php_list at mail.iviking.org>
> Sent: Thursday, 16 July, 2009 11:18:36 AM
> Subject: Re: [FX.php List] FX.php problem ... Calculated Values not shown
> 
> 
> On 16/07/2009, at 1:10 PM, Stephe Pocock wrote:
> 
>> Hi all
>> 
>> Long time lurker here :).  Following GGTs advice I have used pastebin.
>> 
>> I have a page that is used to claim an email by entering a matter number (case ID).
>> 
>> I have a calculated value that checks if the matter is valid using a couple of relationships.
>> c_MatterCheck =
>> Case (
>> not IsEmpty ( AM_HBM_MATTER::MATTER_NAME ) ; "Yes" ;
>> not IsEmpty ( AM_MatterNumbers_Matter::Matter Description Calc ) ; "Yes" ;
>> "No" )
> 
> Does the web account have access to those tables? As the default is No, if the accoutn can't get the data, it will always be No
> 
> Cheers
> 
> Webko
> 
> Access Yahoo!7 Mail on your mobile. Anytime. Anywhere. Show me how.
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list



      ____________________________________________________________________________________
Access Yahoo!7 Mail on your mobile. Anytime. Anywhere.
Show me how: http://au.mobile.yahoo.com/mail
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20090726/a15c9d77/attachment-0001.html