Hello,
I'm having trouble with the following issue. I have a table called 'test' where circuit IDs are listed and the customer name for each circuit ID is blank. I would like to compare my current table to another table called 'ioc' (which has the same circuitIDs and also customer names) to pull the customer name into my "test" table. Currently, I am trying with the following code:
function Row_Rendered() {
ew_Execute("UPDATE `test` SET customername= '$customername' WHERE `ioc.circuitid`= " . $this->circuitid->CurrentValue);
}
thanks,
lhardee