[FX.php List] summation field not being red

[Robert Janssen]

Hello, 
 
If anybody could shed some light on my following problem, I'd be much obliged ... 
 
The value of a calculated field  (summation of a related field ) is not shown / not read by the fx module. (I can see the value of het calculation in filemaker itself). 
 
If I change the fieldtype to a number instead of a calculated field, the fx module reads the field perfectly.
 
Here is the summation:
 
Sum(FLEX::uren) + Sum(P125::uren) + Sum(P150::uren) + Sum(P200::uren) 
 
greetz.
Robert Janssen



From: bob at patin.comTo: fx.php_list at mail.iviking.orgSubject: Re: [FX.php List] posting an email addressDate: Mon, 14 Apr 2008 17:17:41 -0500Andrew, 

I suppose that's true, but it's never been a problem for me, since no one ever enters their email address as "adenmanxtmea.org". 
What my code does is keep the @ sign from becoming a wildcard, and for that it works fine. I can't imagine ever needing to enclose the whole thing in double quotes...

But that's just me... :)

BP


On Apr 14, 2008, at 3:29 PM, Andrew Denman wrote:
A small correction to Bob's code:$query->AddDBParam('email','=="'.$email.'"');The @ character is a special search character in FileMaker (match onecharacter), so to use it as your data you must enclose it in the doublequotes (signifies literal text).  You can see all the special searchcharacters by doing a find in FileMaker and clicking the Symbols arrow inthe status area on the left. You can also try out your finds in FileMaker tosee what shows up and experiment with them; it's easier to troubleshoot thanhaving to change the coding on web pages.The reason the quotes are needed is that with the double equals and withoutthe quotes will match both of these:adenman at tmea.orgadenmanxtmea.orgAndrew Denman
_________________________________________________________________
De leukste online filmpjes vind je op MSN Video!
http://video.msn.com/video.aspx?mkt=nl-nl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080415/c81041a8/attachment.html