[FX.php List] FMSA7 Searching Calculation fields

[Andrew Denman]

I have had this problem with calculated fields between tables in FM7 in two
cases:

1. The calculation field is getting values from >1 table in >1 file.  Even
with full access from the web, the calculation fields are blank.  Within
FileMaker, everything works fine.

2. The calculation field is getting values from >1 table from within the
same file BUT ONLY WHEN '[Any New Table]' is set to 'none' under 'View' (all
of this in the 'Define Accounts & Privileges' privilege set editing window
under 'Records'->'Custom Privileges...').  Even if all of the necessary
tables had view privileges set to 'all', if [Any New Table] was set to
'none' it wouldn't work.  Again, everything works fine from within
FileMaker.

In FM8 the problem in #2 has disappeared.

I have not had a chance to test a two file version (#1 above) in FM8 yet,
but I have found no way to make it work in FM7 and from the other replies it
seems we're SOL.  Has anyone tried this FM8 yet?

Also, where are you all submitting these bugs/requests to FileMaker?  I've
searched for some way to submit possible bugs but haven't found anything.

Thanks,

Andrew Denman
TMEA IT Administrator
Phone: (512) 452-0710 x109
Toll-free: 1-888-318-TMEA x109
Fax: (512) 451-9213
________________________________________
From: Kim Hawksworth
Sent: Tuesday, January 10, 2006 2:48 PM
To: fx.php_list at mail.iviking.org
Subject: [FX.php List] FMSA7 Searching Calculation fields

Greetings list members.

I’ve got another web application I’m converting from FM6 Unlimited to FMSA7.
 The application calls the FX.php FMFind() function to several calculation
fields.  This worked flawlessly under FM6, however with FMSA7 the query
returns a 401 error (no records found).  If I change the calculation field
to plain text and manually enter some data into the field, the query returns
the entered results.  If I search the calculation fields directly from the
FM7 client, the database returns the expected results.  The problem appears
only with the web publishing engine and FX.php. Has anyone else seen this
behavior with calculation fields and if so can you offer any
work-arounds/solutions?

Thanks for your help.

-- 
Kim David Hawksworth, R.Ph., Web Manager
The OSUMC Dept. of Pharmacy
410 W. 10Th Ave, Room 368 Doan
Ph# (614) 293-3765
Pager# (614) 730-8143
Email: kim.hawksworth at osumc.edu