function premaintain_query() { foreach ( $this->pre_sql as $sql) { $nsql = reportico_assignment::reportico_lookup_string_to_php($sql); $recordSet = false; $errorCode = false; $errorMessage = false; try { $recordSet = $conn->Execute($nsql) ; } catch ( PDOException $ex) { $errorCode = $ex->getCode(); $errorMessage = $ex->getMessage(); } if ( !$recordSet ) { if ( $errorMessage ) handle_error("Query Failed<BR><BR>".$nsql."<br><br>" . $errorMessage); else handle_error("Query Failed<BR><BR>".$nsql."<br><br>" . "Status ".$conn->ErrorNo()." - ". $conn->ErrorMsg()); } } $this->fetch_column_attributes(); // Run query for each target. Currently having more than // one target means first target is array which becomes source // for second target //for ($i = 0; $i < count($this->targets); $i++ ) for ($i = 0; $i < 1; $i++ ) { $target =& $this->targets[$i]; $target->set_query($this); $target->set_columns($this->columns); $target->start(); } }
function premaintain_query() { foreach ($this->pre_sql as $sql) { $nsql = reportico_assignment::reportico_lookup_string_to_php($sql); $recordSet = $conn->Execute($sql); echo $this->query_statement . "<br>Query failed : " . $conn->ErrorMsg(); } $this->fetch_column_attributes(); // Run query for each target. Currently having more than // one target means first target is array which becomes source // for second target //for ($i = 0; $i < count($this->targets); $i++ ) for ($i = 0; $i < 1; $i++) { $target =& $this->targets[$i]; $target->set_query($this); $target->set_columns($this->columns); $target->start(); } }