[FX.php List] summation field not being red

Gjermund Gusland Thorsen ggt667 at gmail.com
Tue Apr 15 06:22:00 MDT 2008


Only the reports show the summery fields AFAIK, as it is heavily
relaying on the current selection.

ggt

2008/4/15, Robert Janssen <janssen_robert at hotmail.com>:
>
> 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.com
> To: fx.php_list at mail.iviking.org
> Subject: Re: [FX.php List] posting an email address
> Date: Mon, 14 Apr 2008 17:17:41 -0500
>
> Andrew,
>
>
> 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 one
> character), so to use it as your data you must enclose it in the double
> quotes (signifies literal text).  You can see all the special search
> characters by doing a find in FileMaker and clicking the Symbols arrow in
> the status area on the left. You can also try out your finds in FileMaker to
> see what shows up and experiment with them; it's easier to troubleshoot than
> having to change the coding on web pages.
>
> The reason the quotes are needed is that with the double equals and without
> the quotes will match both of these:
> adenman at tmea.org
> adenmanxtmea.org
>
> Andrew Denman
>
> ________________________________
> Chat met al je vrienden. Voeg ze nu allemaal toe aan Messenger!
> _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>
>


More information about the FX.php_List mailing list