Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\UpdateData\Update_customer_credit.php on line 12
Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\UpdateData\Update_customer_credit.php on line 12
Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\UpdateData\Update_customer_credit.php on line 13
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\UpdateData\Update_customer_credit.php on line 13
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\UpdateData\Update_customer_credit.php on line 14
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\UpdateData\Update_customer_credit.php on line 14
SELECT cu.OKCUNO as CUSCODE,
cu.OKCFC9 as CUSDUO,
cu.OKCUNM as CUSNAME,
(cu.OKCUA1+cu.OKCUA2+cu.OKCUA3+cu.OKCUA4) as CUS_ADDR,
cu.OKPHNO as CUS_PHONE,
cu.OKSMCD as CUS_SALECODE,
cu.OKSDST as CUS_ZONE,
cu.OKCFC1 as CUS_AREA,
cu.OKCFC8 as CUS_TEAM,
'' as CUS_SHOP,
cu.OKCFC3 as CUS_SPE,
cu.OKPONO as CUS_POSTEL,
cu.OKECAR as CUS_PROVINCE,
cu.OKADID as CUS_LG,
cu.OKTXAP as CUS_VAT,
cu.OKVRNO as CUS_TAXNO,
SUBSTRING(cu.OKTEPY,2,2) as CUS_DUE,
cu.OKWHLO as CUS_WH,
cu.OKCRL2 as CUS_CF1,
case WHEN OKCFC5 in('A','B') then 'Y' else 'N' END as CUS_CF2,
case WHEN OKCFC0 in('V','B') then 'A' else '' END as CUS_CF3,
'' as CUS_LAT,
'' as CUS_LNG,
cu.OKLMDT as LAST_UPD
FROM MVXJDTA.OCUSMA AS cu
where cu.OKCUNO <>'COMMISSION'
AND cu.OKCONO = '410'
and cu.OKCUCL in ('102','200')
and cu.OKCUNO NOT in('BBL','BBL0001','TARGET')
order by cu.OKCUNO asc Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\UpdateData\Update_customer_credit.php on line 63
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\UpdateData\Update_customer_credit.php on line 63
Data prepare Complete . . . All Rows For Upload -> [ 0 ] Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\UpdateData\Update_customer_credit.php on line 161
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\UpdateData\Update_customer_credit.php on line 161
Data prepare Complete . . . All Rows For Upload -> [ 0 ]