[FX.php List] Strange One.

Dale Bengston dbengston at preservationstudio.com
Mon May 8 17:11:41 MDT 2006

Previous message: [FX.php List] Strange One.
Next message: [FX.php List] FX Examples
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Gerry,

What happens if you print_r() your $searchGResult again?

-Dale

On May 8, 2006, at 11:58 AM, gerry.charest at agfa.com wrote:

> Time for an upgrade? With the release of the 8.0v3 Server/Web  
> update I thought this may be a good time to move off server Seven.  
> I upgraded two boxes this morning and the strange query results or  
> lack of a result is gone and the "SQA" query works on both systems.
>
> I guess some times you just need to start over.
>
> Best regards
> Gerry
>
> <graycol.gif>
> Jason H Awbrey <jawbrey at harmonic-data.com>
>
>
> <ecblank.gif>
>
> <ecblank.gif>
>
> Jason H Awbrey <jawbrey at harmonic-data.com>
> Sent by: fx.php_list-bounces at mail.iviking.org
> 05/05/2006 04:50 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.
>
>
> 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
>
> _______________________________________________
> 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>
> <pic21489.gif>
> _______________________________________________
> 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] FX Examples
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the FX.php_List mailing list