[FX.php List] Strange One.

DC dan.cynosure at dbmscan.com
Fri May 5 09:57:33 MDT 2006

Previous message: [FX.php List] Strange One.
Next message: [FX.php List] Web/Database server separation
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

thanks for the additional info...

what does your XML query look like just before the error happens? FX 
builds an FMPXML query for you.... can you see it and tell if something 
is wrong? extra chars or spaces or something?

it looks like it could be something is wrong with the XML itself. that 
type of error has cropped up here on the list before (but, not with that 
specific error string AFAICT).

make sure that the XML that is returned by the "SQA" query is properly 
formed with no spurious characters.

i seem to remember someone saying that MS Word copy paste puts cruft in 
what you'd think would be a simple string. maybe someone is copy pasting 
from word to your FMP data?

HTH,
dan

gerry.charest at agfa.com had written:
> OK here is the setup on the returned page:
> 
> I set up a short test to see if it continues to fail give a small set of 
> conditions. I was pulling the values out of the post but decided to hard 
> code them in the page to be sure I was getting the correct values.
> When I use: $searchG->AddDBParam("ReportedBy", "SQA", "eq"); I get:
> 
> *Fatal error*: Cannot use object of type FX_Error as array in 
> *c:\Inetpub\wwwroot\bug\testResult.php* on line *41*
> 
> This error code is relating to: echo $searchGResult["errorCode"]; when I 
> comment this out I get FX_Error Object shown at the end of this message.
> If I change the search value from "SQA" to something else the query 
> works fine and the page returns without problem including the errorCode 
> Zero.
> 
> Any insight from the more experienced is much appreciated.
> 
> Gerry
> 
> 
> include_once($DOCUMENT_ROOT.'FX/FX.php');
> include_once($DOCUMENT_ROOT.'FX/server_data.php');
> include_once($DOCUMENT_ROOT.'FX/FMErrors.php');
> 
> //$ReportedBy_op = $_POST["ReportedBy_op"];
> //$ReportedBy = $_POST["ReportedBy"];
> 
> $searchG=new FX("theaddress","80","FMPro7");
> $searchG->SetDBData("BugLog.fp7","SRW");
> $searchG->SetDBPassword("web","web");
> $searchG->AddDBParam("ReportedBy", "SQA", "eq");
> $searchGResult = $searchG -> FMFind();
> ?>
> </head>
> <body>
> <?php
> echo $searchGResult["errorCode"];
> //print_r($searchGResult['URL']);
> print_r($searchGResult);
> 
> 
> 
> 
> 
> FX_Error Object
> (
> [error_message_prefix] =>
> [mode] => 1
> [level] => 1024
> [code] => 100
> [message] => FX: ExecuteQuery XML error: Internal error at line 1
> [userinfo] =>
> [backtrace] => Array
> (
> [0] => Array
> (
> [file] => c:\PHP\includes\FX\FX.php
> [line] => 889
> [function] => FX_Error
> [class] => FX_Error
> [type] => ->
> [args] => Array
> (
> [0] => ExecuteQuery XML error: Internal error at line 1
> )
> 
> )
> 
> [1] => Array
> (
> [file] => c:\PHP\includes\FX\FX.php
> [line] => 1051
> [function] => ExecuteQuery
> [class] => FX
> [type] => ->
> [args] => Array
> (
> [0] => -find
> )
> 
> )
> 
> [2] => Array
> (
> [file] => c:\PHP\includes\FX\FX.php
> [line] => 1102
> [function] => FMAction
> [class] => FX
> [type] => ->
> [args] => Array
> (
> [0] => -find
> [1] => 1
> [2] => full
> )
> 
> )
> 
> [3] => Array
> (
> [file] => c:\Inetpub\wwwroot\bug\testResult.php
> [line] => 29
> [function] => FMFind
> [class] => FX
> [type] => ->
> [args] => Array
> (
> )
> 
> )
> 
> )
> 
> [callback] =>
> )
> 
> 
> Inactive hide details for Jason H Awbrey 
> <jawbrey at harmonic-data.com>Jason H Awbrey <jawbrey at harmonic-data.com>
> 
> 
> 
> 	
> 
>                         *Jason H Awbrey <jawbrey at harmonic-data.com>*
>                         Sent by: fx.php_list-bounces at mail.iviking.org
> 
>                         05/04/2006 01:08 PM
>                         Please respond to "FX.php Discussion List"
> 
> 	
> 
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> cc: (bcc: Gerry Charest/MJVYN/AGFA)
> Subject: Re: [FX.php List] Strange One.
> 
> 
> 
> Hi Gerry,
> 
> Try adding print_r ($query_var['URL']) so you can get the FM XML
> query string. This should shed a little light on the problem.
> 
> HTH,
> Jason
> 
> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
> Jason Awbrey
> Web Integration
> FileMaker 7 Certified Developer
> Harmonic Data Associates
> http://www.harmonic-data.com
> jawbrey at harmonic-data.com
> w - 214 269.2804
> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
> 
> 
> 
> On May 4, 2006, at 11:41 AM, DC wrote:
> 
>  > context?
>  >
>  > gerry.charest at agfa.com had written:
>  >> OK here is a strange one...
>  >> I'm searching a field for the value "SQA"
>  >> When this value is entered is a search param I get a fatal error.
>  >> Searching other values in the field work just fine. Is SQA a
>  >> reserved word of some type?
>  >> Gerry
>  >> ---------------------------------------------------------------------
>  >> ---
>  >> _______________________________________________
>  >> FX.php_List mailing list
>  >> FX.php_List at mail.iviking.org
>  >> http://www.iviking.org/mailman/listinfo/fx.php_list
>  > _______________________________________________
>  > FX.php_List mailing list
>  > FX.php_List at mail.iviking.org
>  > http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

Previous message: [FX.php List] Strange One.
Next message: [FX.php List] Web/Database server separation
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the FX.php_List mailing list