[FX.php List] Strange FX behavior

[Erik Andreas Cayré]

Den 01/05/2007 kl. 12.31 skrev Bob Patin:

> I'm working on a project for a client who has a nightmare set of  
> databases that she wrote in FM3 and has now converted to 8.5. There  
> are somewhere over 4000 fields in one of the 24 database files; to  
> say that it's a mess is a major understatement.
>
> At any rate, I'm trying to return 15 fields after a simple query; I  
> created a layout, wrote the simple little query, and the query  
> returns the appropriate record.
>
> However, no matter what I've done, I can't make FX return a few of  
> the fields; the field names are simple: 'analyst' is one, and  
> 'asset_manager' is another. I even created a new layout just to see  
> if that would make any difference. I can see that the returned  
> record has the same recid as the record in the db...
>
> So is there anything that would make a query NOT return all the  
> fields in a database? Could it be the huge # of fields? Only 15 are  
> on this layout; the missing fields are present on the layout, the  
> spelling is consistent in database and PHP page...
>
> I'm totally at a loss; I wonder if these databases are just too  
> bloated and goofy... any thoughts?

There have been a few similar cases on the list, where the problem  
was a damaged layout...
Have you tried creating a new layout?
Are you searching on one layout and returning using another layout?
Have you checked permissions aren't customised (limited acces to some  
fields)?
Do you get an error from FX?
How does the raw return data from FX look?
Are you positve the Filemaker file in question has never crashed?

Sorry for shooting like this. Hope I got a hit...!

best regards

---
Erik Andreas Cayré
Spangsbjerg Møllevej 169
6705 Esbjerg Ø

Privat Tel: 75150512
Mobil: 40161183

---
»Interesse kan skabe læring på en skala sammenlignet med frygt, som  
en nuklear eksplosion i forhold til en kineser.«
--Stanley Kubrick

»Kun p....sure mennesker kan ændre verden. Innovation skabes ikke af  
'markedsanalyse', men af folk, der er afsindigt irriterede over  
tingenes tilstand «
--Tom Peters

»Hvis du ikke kan forklare det simpelt, forstår  du det ikke godt nok.«
-- Albert Einstein

»Hvis du ikke har tid til at gøre det rigtigt, hvornår vil du så have  
tid til at lave det om?«
-- John Wooden, basketball coach