this is what the debug showed: (the page is http://www.marsalstudios.com/testingwap.php ) only field titles are retrieved. there should be 1 row of data. thanks for repyling.
{“code”:0,“file”:"/home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php",“line”:185,“message”:“preg_match() expects parameter 2 to be string, object given”,“trace”:"#0 [internal function]: exception_error_handler(2, ‘preg_match() ex…’, ‘/home/marsscom/…’, 185, Array)\n#1 /home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php(185): preg_match(’/\\s+AS\\s+/i’, Object(stdClass))\n#2 /home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php(275): lib\db\SqlBuilder->quoteIdentifier(Object(stdClass))\n#3 /home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php(241): lib\db\SqlBuilder->compileFrom(Object(stdClass))\n#4 [internal function]: lib\db\SqlBuilder->compileComponent(‘from’)\n#5 /home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php(219): array_map(Array, Array)\n#6 /home/marsscom/public_html/dmxConnectLib/lib/db/SqlBuilder.php(208): lib\db\SqlBuilder->compileSelect()\n#7 /home/marsscom/public_html/dmxConnectLib/modules/dbconnector.php(33): lib\db\SqlBuilder->compile()\n#8 /home/marsscom/public_html/dmxConnectLib/lib/App.php(159): modules\dbconnector->select(Object(stdClass), ‘mailquery’)\n#9 /home/marsscom/public_html/dmxConnectLib/lib/App.php(128): lib\App->execSteps(Object(stdClass))\n#10 /home/marsscom/public_html/dmxConnectLib/lib/App.php(98): lib\App->execSteps(Array)\n#11 /home/marsscom/public_html/dmxConnectLib/lib/App.php(71): lib\App->exec(Object(stdClass))\n#12 /home/marsscom/public_html/dmxConnect/api/mailmessagedb.php(92): lib\App->define(’{\n “meta”: {\n …’)\n#13 {main}"}