--- a/admin/partialdata/importamendments.php +++ b/admin/partialdata/importamendments.php @@ -1,6 +1,13 @@ <?php include_once ("../../lib/common.inc.php"); - +/* +update contractnotice set "supplierABN" = a."supplierABN" +from contractnotice as cn inner join (select "supplierABN", +"supplierName" from contractnotice where "supplierABN" +IS NOT NULL and "supplierABN" != 0) as a on +cn."supplierName" = a."supplierName" where +cn."CNID"=contractnotice."CNID" and (contractnotice."supplierABN" +IS NULL or contractnotice."supplierABN" = 0) */ // http://www.lastcraft.com/browser_documentation.php // http://code.google.com/p/phpquery/ require('phpQuery-onefile.php'); @@ -313,3 +320,4 @@ } ?> +