doushan6161 2016-06-27 14:04
浏览 24

PHP ODBC:在CLI中运行时,字段名称被截断为1个字符

Decided to put my script in /etc/crontab instead of running it from the browser, but realized that I'm getting different results.

Running script from the browser:

Array
(
    [ACTIVE] => C  
    [CUSTOMER_NUM] => 123
    [CUSTOMER_NAME] => 123 CORP                
    [REPNUM] => 099
    [ADDRESS1] => IDD# 123                           
    [ADDRESS2] => P O BOX 123
    [CITY] => CLEVELAND                
    [STATE] => OH 
    [ZIP] => 44136       
    [REPNAME] => House Account                 
    [PHONENUM] => 123
)

Running script from php-cli:

Array
(
    [A] => P O BOX 123
    [C] => CLEVELAND
    [R] => House Account
    [S] => OH
    [Z] => 44136
    [P] => 123
)

So I wonder why associative array keys are truncated? Please help. Thanks.

Script:

  $result = odbc_exec($db, "SELECT
CAST(F0101JC.ABAT1 as varchar(20) CCSID 37) as Active,
F0101JC.ABAN8 as CUSTOMER_NUM,
F0101JC.ABALPH as CUSTOMER_NAME,
CAST(F0101JC.ABAC02 as varchar(20) CCSID 37) as RepNum,
F0101JC.ALADD1 as Address1,
F0101JC.ALADD2 as Address2,
F0101JC.ALCTY1 as City,
CAST(F0101JC.ALADDS as varchar(20) CCSID 37) as State,
CAST(F0101JC.ALADDZ as varchar(20) CCSID 37) as Zip,
F0005.DRDL01 as RepName,
trim(CAST(F0115.WPAR1 as varchar(20) CCSID 37))  || '-' || trim(CAST(F0115.WPPH1 as varchar(20) CCSID 37)) as PhoneNum
FROM CLTPRDDTA.F0101JC \"F0101JC\"
LEFT JOIN GENCOM.F0005 \"F0005\"
ON \"F0101JC\".\"ABAC02\" = trim(\"F0005\".\"DRKY\")
LEFT JOIN CLTPRDDTA.F0115 F0115
ON F0101JC.ABAN8 = F0115.WPAN8
WHERE  DRSY = '01  '
AND DRRT = '02'
AND WPRCK7 = '1'
AND F0101JC.ABAT1 = 'C'
  ");

  while($myRow = odbc_fetch_array( $result )) {
    print_r($myRow);
  }

Versions:

php.x86_64                       5.6.22-1.el7.remi                   @remi-php56
php-cli.x86_64                   5.6.22-1.el7.remi                   @remi-php56
php-odbc.x86_64                  5.6.22-1.el7.remi                   @remi-php56
httpd.x86_64                     2.4.6-40.el7.centos                 @base
libphp5.so
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 mysql架构,按照姓名分表
    • ¥15 MATLAB实现区间[a,b]上的Gauss-Legendre积分
    • ¥15 Macbookpro 连接热点正常上网,连接不了Wi-Fi。
    • ¥15 delphi webbrowser组件网页下拉菜单自动选择问题
    • ¥15 linux驱动,linux应用,多线程
    • ¥20 我要一个分身加定位两个功能的安卓app
    • ¥15 基于FOC驱动器,如何实现卡丁车下坡无阻力的遛坡的效果
    • ¥15 IAR程序莫名变量多重定义
    • ¥15 (标签-UDP|关键词-client)
    • ¥15 关于库卡officelite无法与虚拟机通讯的问题