[FX.php List] Strange One.

Jason H Awbrey jawbrey at harmonic-data.com
Fri May 5 14:50:41 MDT 2006


Gerry,

Try sending the XML query but substitute Dev for SQA and see what the  
result is. My guess is your getting some sort of error from FileMaker.

HTH,
Jason

On May 5, 2006, at 3:19 PM, gerry.charest at agfa.com wrote:

> Dan
>
> The var_export valus shown below:
>
> Nothing is comming out of the print_r($searchGResult['URL']); This  
> line produces a Fatal error
> Fatal error: Cannot use object of type FX_Error as array in c: 
> \Inetpub\wwwroot\bug\testResult.php on line 33
> When I change the query to something other than "SQA" I get results  
> without error.
> and this is the url: http://web:web@xx.xxx.xx.xx:80/fmi/xml/ 
> FMPXMLRESULT.xml?-db=BugLog.fp7&-lay=SRW&- 
> max=50&ReportedBy.op=eq&ReportedBy=Dev&-find
>
>
> Gerry
>
> Not sure what Im looking for here:
>
> var_export valus
>
> class FX_Error {
> public $error_message_prefix = '';
> public $mode = 1;
> public $level = 1024;
> public $code = 100;
> public $message = 'FX: ExecuteQuery XML error: Internal error at  
> line 1';
> public $userinfo = NULL;
> public $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 => true,
> 2 => 'full',
> ),
> ),
> 3 =>
> array (
> 'file' => 'c:\\Inetpub\\wwwroot\\bug\\testResult.php',
> 'line' => 26,
> 'function' => 'FMFind',
> 'class' => 'FX',
> 'type' => '->',
> 'args' =>
> array (
> ),
> ),
> );
> public $callback = NULL;
> }
>
>
>
>
> <graycol.gif>
> DC <dan.cynosure at dbmscan.com>
>
>
> <ecblank.gif>
>
> <ecblank.gif>
>
> DC <dan.cynosure at dbmscan.com>
> Sent by: fx.php_list-bounces at mail.iviking.org
> 05/05/2006 01:20 PM
> Please respond to "FX.php Discussion List"
>
> <ecblank.gif>
>
>
> 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.
>
>
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> <graycol.gif>
> <ecblank.gif>
> <pic02168.gif>
> _______________________________________________
>
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060505/556ed68f/attachment-0001.html


More information about the FX.php_List mailing list