[FX.php List] Error code question

Gjermund Gusland Thorsen ggt667 at gmail.com
Tue Nov 7 00:29:54 MST 2006


Hi Jim

For you own convenience, please put IP, port and username/passwords
into variables and use /FX/server_data.php or
/FX/server_data_<<projectName>>.php to hold them.

In case of changing database location you will have only one place to
change IP/port/database/username/password

Gjermund

2006/11/7, Jim McNeely <jim at newcenturydata.com>:
> Andy,
>
> Yes, and that fixed it! So that bug is still there. THANKS!!!!!!!!!
>
> Jim
>
> Andy Gaunt wrote:
> > Jim,
> >
> > Any related fields outside portals?
> >
> > Andy Gaunt
> > Office: 321.206.3658
> > Mobile: 407.810.4722
> > andy at fmpug.com
> > http://www.fmpug.com
> >
> > 2006 FileMaker Excellence Award Winner
> > Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award
> >
> > For chapter locations, dates & times please visit the website at
> > http://www.fmpug.com If you can make it to a meeting, please RSVP at
> > http://www.fmpug.com/rsvp.php
> >
> > -----Original Message-----
> > From: fx.php_list-bounces at mail.iviking.org
> > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jim McNeely
> > Sent: Monday, November 06, 2006 6:15 PM
> > To: FX.php_List at mail.iviking.org
> > Subject: [FX.php List] Error code question
> >
> > I am having some trouble with a PHP file that was working perfectly with
> > FMSA 7, but upon updating to FMSA 8 is not working properly. Other
> > queries are working correctly that reference the same FM file, but not
> > this one. I used var_dump() to examine the contents of the array that
> > isn't working, and got this; what EXACTLY is the filemaker error in all
> > of this? - Also, if I comment the web_web query and do the web_products
> > query, it works. And yes, the layout is there and is named correctly, as
> > are all of the fields. So, WHAT???!!!  TIA, Jim
> > ==========================
> > query:
> > ==========================
> > $linkq = new FX("10.42.6.153","80");
> > //$linkq->SetDBData("soi_data.fp7", "web_products");
> > $linkq->SetDBData("soi_data.fp7", "web_web");
> >
> > $linkq->SetDBUserPass("web","bewbew2005");
> >
> > //$linkq->AddDBParam("f_new_prd_flag", "1");
> > $linkq->AddDBParam("c_table", "Links");
> >
> > $link=$linkq->FMFind();
> >
> > echo var_dump($link);
> >
> > ==========================
> > result:
> > ==========================
> > object(fx_error)(8) {
> >   ["error_message_prefix"]=>
> >   string(0) ""
> >   ["mode"]=>
> >   int(1)
> >   ["level"]=>
> >   int(1024)
> >   ["code"]=>
> >   int(100)
> >   ["message"]=>
> >   string(54) "FX: ExecuteQuery XML error: no element found at line 2"
> >   ["userinfo"]=>
> >   NULL
> >   ["backtrace"]=>
> >   array(5) {
> >     [0]=>
> >     array(6) {
> >       ["file"]=>
> >       string(38) "/Library/WebServer/Documents/FX/FX.php"
> >       ["line"]=>
> >       int(895)
> >       ["function"]=>
> >       string(8) "fx_error"
> >       ["class"]=>
> >       string(8) "fx_error"
> >       ["type"]=>
> >       string(2) "->"
> >       ["args"]=>
> >       array(1) {
> >         [0]=>
> >         string(50) "ExecuteQuery XML error: no element found at line 2"
> >       }
> >     }
> >     [1]=>
> >     array(6) {
> >       ["file"]=>
> >       string(38) "/Library/WebServer/Documents/FX/FX.php"
> >       ["line"]=>
> >       int(1057)
> >       ["function"]=>
> >       string(12) "executequery"
> >       ["class"]=>
> >       string(2) "fx"
> >       ["type"]=>
> >       string(2) "->"
> >       ["args"]=>
> >       array(1) {
> >         [0]=>
> >         string(5) "-find"
> >       }
> >     }
> >     [2]=>
> >     array(6) {
> >       ["file"]=>
> >       string(38) "/Library/WebServer/Documents/FX/FX.php"
> >       ["line"]=>
> >       int(1108)
> >       ["function"]=>
> >       string(8) "fmaction"
> >       ["class"]=>
> >       string(2) "fx"
> >       ["type"]=>
> >       string(2) "->"
> >       ["args"]=>
> >       array(3) {
> >         [0]=>
> >         string(5) "-find"
> >         [1]=>
> >         bool(true)
> >         [2]=>
> >         string(4) "full"
> >       }
> >     }
> >     [3]=>
> >     array(6) {
> >       ["file"]=>
> >       string(41) "/Library/WebServer/Documents/spot_hdr.php"
> >       ["line"]=>
> >       int(70)
> >       ["function"]=>
> >       string(6) "fmfind"
> >       ["class"]=>
> >       string(2) "fx"
> >       ["type"]=>
> >       string(2) "->"
> >       ["args"]=>
> >       array(0) {
> >       }
> >     }
> >     [4]=>
> >     array(4) {
> >       ["file"]=>
> >       string(38) "/Library/WebServer/Documents/index.php"
> >       ["line"]=>
> >       int(20)
> >       ["args"]=>
> >       array(1) {
> >         [0]=>
> >         string(41) "/Library/WebServer/Documents/spot_hdr.php"
> >       }
> >       ["function"]=>
> >       string(7) "include"
> >     }
> >   }
> >   ["callback"]=>
> >   NULL
> > }
> >
> > _______________________________________________
> > 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