[FX.php List] Strange One.

DC dan.cynosure at dbmscan.com
Fri May 5 11:20:50 MDT 2006


yes, do var_export($FX_object);

it should be in there somewhere...

gerry.charest at agfa.com had written:
> I had a feeling it may have been the data in the database so I went in 
> and replaced the field contents with typed in values, compressed the 
> data to be sure it was not an indexing problem.
> I do not know how to see the XML query. Is there some special code I can 
> add to the page? I don't see anything in my packet sniffer or web logs.
> 
> Gerry
> 
> 
> Inactive hide details for DC <dan.cynosure at dbmscan.com>DC 
> <dan.cynosure at dbmscan.com>
> 
> 
> 
> 	
> 
>                         *DC <dan.cynosure at dbmscan.com>*
>                         Sent by: fx.php_list-bounces at mail.iviking.org
> 
>                         05/05/2006 11:57 AM
>                         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.
> 
> 
> 
> 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
> _______________________________________________
> 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


More information about the FX.php_List mailing list