Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 12
Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 12
Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 13
Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 13
Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 14
Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 14
SELECT
RTRIM(cu.OKCUNO) as CUSCODE,
cu.OKCUNM+cu.OKCUA4 as CUSNAME,
(cu.OKCUA1+' '+cu.OKCUA2+' '+cu.OKCUA3) as CUS_ADDR,
cu.OKPHNO as CUS_PHONE,
cu.OKSMCD as CUS_SALECODE,
RTRIM(cu.OKSDST) as CUS_ZONE,
RTRIM(cu.OKCFC1) as CUS_AREA,
RTRIM(cu.OKCFC6) as CUS_SHOP,
cu.OKCFC3 as CUS_SPE,
cu.OKPONO as CUS_POSTEL,
cu.OKECAR as CUS_PROVINCE,
cu.OKVRNO as CUS_VRNO,
'2016-11-01 10:00:00' as LAST_UPD
FROM
MVXJDTA.OCUSMA AS cu
where (((cu.OKCUNO like 'V%') and (cu.OKCUNO not like 'V0%') and (cu.OKCUNO <>'COMMISSION'))
and (cu.OKCUNM not like '**%'))
order by cu.OKCUNO asc Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 46
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 46
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 71
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\www\mobile\no\_ps\ps_mi_sent_store.php on line 71
Data prepare Complete . . . All Rows For Upload -> [ 0 ]