[FX.php List] Strange One.

Jason H Awbrey jawbrey at harmonic-data.com
Fri May 5 11:20:40 MDT 2006


Gerry,

You already have the line in your code:

 > //print_r($searchGResult['URL']);

Just un-comment it.

-Jason


On May 5, 2006, at 12:00 PM, gerry.charest at agfa.com wrote:

> 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
>
>
> <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 11:57 AM
> 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.
>
>
> 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
> <graycol.gif>
> <ecblank.gif>
> <pic27982.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/3e90c1cb/attachment.html


More information about the FX.php_List mailing list