i tried simply using a variable in a block of code on a new page as follows...
<?php require_once('Connections/PowerCMSConnection_i.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php
if ("" == "") {
$InsertQuery = new WA_MySQLi_Query($PowerCMSConnection_i);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "tbleventmember";
$InsertQuery->bindColumn("EventID", "i", "275", "WA_DEFAULT");
$InsertQuery->bindColumn("MemberID", "i", "101", "WA_DEFAULT");
$InsertQuery->bindColumn("InviteSent", "i", "0", "WA_DEFAULT");
$InsertQuery->bindColumn("CampaignID", "s", "".$campaignid."", "WA_DEFAULT");
$InsertQuery->saveInSession("eventmember");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
echo $InsertQuery->debugSQL();
?>
but this gives me the following...
Fatal error: Call to undefined method WA_MySQLi_Query::debugSQL() in D:\vhosts\inchorus\_sqldump_test.php on line 23
(though the query runs ok and the table is updated)