[FX.php List] FMSA7 Searching Calculation fields

[Tim Brown]

You can log them here.
http://filemaker.com/company/problems.html

Tim

On Jan 11, 2006, at 5:25 PM, Andrew Denman wrote:

> 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
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>