[FX.php List] Error code question

[Andy Gaunt]

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