[FX.php List] FMFindAll (or not!)

[Michael Layne]

Roger,

I'm pretty sure every time I've ever seem this message(error), it's  
about permissions.... either within FM or the database file itself.  
Are you sure you have the user "fmxml" (or something like that)  
configured?

Anyway, I'd start looking there...

HTH,

Michael

Sorry for the less than thorough response.  I can dig more if necessary.

On May 8, 2007, at 7:34 AM, Roger Price wrote:

> I have the following FX.php request in a web page:
>
> $dbArchiveEvents = 'events.fp7';
> $layArchiveEvents = 'web';
> $ArchiveEventsQuery = new FX($serverIP, $webCompanionPort,  
> $dataSourceType);$ArchiveEventsQuery->SetDBData($dbArchiveEvents,  
> $layArchiveEvents);
> $ArchiveEventsQuery->setDBUserPass($webUN);
> $ArchiveEventsData = $ArchiveEventsQuery->FMFindAll();
>
> it returns the following when I do:
> 'print_r($ArchiveEventsData);
>
>
> fx_error Object ( [error_message_prefix] => [mode] => 1 [level] =>  
> 1024 [code] => 100 [message] => FX: ExecuteQuery XML error: no  
> element found at line 3 [userinfo] => [backtrace] => Array ( [0] =>  
> Array ( [file] => /var/htdocs/FX/FX.php [line] => 1362 [function]  
> => fx_error [class] => fx_error [type] => -> [args] => Array ( [0]  
> => ExecuteQuery XML error: no element found at line 3 ) ) [1] =>  
> Array ( [file] => /var/htdocs/FX/FX.php [line] => 1529 [function]  
> => executequery [class] => fx [type] => -> [args] => Array ( [0] =>  
> -findall ) ) [2] => Array ( [file] => /var/htdocs/FX/FX.php [line]  
> => 1758 [function] => fmaction [class] => fx [type] => -> [args] =>  
> Array ( [0] => -findall [1] => 1 [2] => full [3] => 1 ) ) [3] =>  
> Array ( [file] => /var/htdocs/events/archive/results/index.html  
> [line] => 59 [function] => fmfindall [class] => fx [type] => ->  
> [args] => Array ( ) ) ) [callback] => )
>
> It suggests a missing element at line 3, but line 3 of what?  
> However If I execute a find using a specific field name and value  
> then the record is returned.
>
> I've tried 'fooling' it by searching for a numeric field value >=0  
> but returns the same as 'FMFindAll'
>
> Any suggestions would be appreciated.
>
> Roger
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



Michael Layne  |  9 degrees development  |  www.9degrees.com  |   
404.226.7835 [m]  |   Skype: LayneBay


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070508/98db0465/attachment.html