doubingling4706 2014-11-19 14:36
浏览 19

CodeIgniter不提取整个字段数据

I'm using CodeIgniter to contact a old MSSQL 6.5 database via unixODBC and FreeTDS. The connection works fine and I can run queries, but the problem is that id doesn't return the entire field data.

Ex. ["Frame9Val"]=> string(3) "13"

-> Should show 135

["Frame1BVal"]=> string(3) "2�"

-> Should show 255

Any idea for why this is happening and how to fix it?

Made a test-php with only PDO and it works fine.

        $this->db->select('tblScore.SessionNum, 
                        tblScore.GameNum, 
                        tblScore.LaneId, 
                        tblScore.PlayerCnt,
                        tblPlayerScore.BowlerName,
                        tblFrameScore.Frame1Val,
                        tblFrameScore.Frame2Val,
                        tblFrameScore.Frame3Val,
                        tblFrameScore.Frame4Val,
                        tblFrameScore.Frame5Val,
                        tblFrameScore.Frame6Val,
                        tblFrameScore.Frame7Val,
                        tblFrameScore.Frame8Val,
                        tblFrameScore.Frame9Val,
                        tblFrameScore.Frame10Val,
                        tblPinfall.Frame1AVal,
                        tblPinfall.Frame1BVal,
                        tblPinfall.Frame2AVal,
                        tblPinfall.Frame2BVal,
                        tblPinfall.Frame3AVal, 
                        tblPinfall.Frame3BVal, 
                        tblPinfall.Frame4AVal, 
                        tblPinfall.Frame4BVal, 
                        tblPinfall.Frame5AVal, 
                        tblPinfall.Frame5BVal, 
                        tblPinfall.Frame6AVal, 
                        tblPinfall.Frame6BVal, 
                        tblPinfall.Frame7AVal, 
                        tblPinfall.Frame7BVal, 
                        tblPinfall.Frame8AVal, 
                        tblPinfall.Frame8BVal, 
                        tblPinfall.Frame9AVal, 
                        tblPinfall.Frame9BVal,
                        tblPinfall.Frame10AVal, 
                        tblPinfall.Frame10BVal, 
                        tblPinfall.Frame11AVal');
    $this->db->from('tblScore, tblPlayerScore, tblPinfall, tblFrameScore');
    $this->db->where('tblScore.SessionNum = tblPlayerScore.SessionNum');
    $this->db->where('tblScore.LaneId = tblPlayerScore.LaneId');
    $this->db->where('tblScore.GameNum = tblPlayerScore.GameNum');
    $this->db->where('tblPlayerScore.SessionNum = tblFrameScore.SessionNum');
    $this->db->where('tblPlayerScore.LaneId = tblFrameScore.LaneId');
    $this->db->where('tblPlayerScore.GameNum = tblFrameScore.GameNum');
    $this->db->where('tblPlayerScore.BowlerNum = tblFrameScore.BowlerNum');
    $this->db->where('tblPlayerScore.SessionNum = tblPinfall.SessionNum');
    $this->db->where('tblPlayerScore.LaneId = tblPinfall.LaneId');
    $this->db->where('tblPlayerScore.GameNum = tblPinfall.GameNum');
    $this->db->where('tblPlayerScore.BowlerNum = tblPinfall.BowlerNum');
    $this->db->where('tblScore.SessionNum', intval($sessionNum));
    $this->db->where('tblScore.LaneId', intval($laneId));
    $this->db->where('tblScore.GameNum', intval($gameNum));
    $query = $this->db->get();
    echo '<pre>';var_dump($query->result());echo'</pre>';
    return $query->result_array();
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度