大家好,我想问,我开发了一些应用程序与ci3,我建立了自己的模型这样,但一些错误的mysql语法,如何解决这个问题,或我的sql查询是错误的?
function get_ref_bidang()
{
$this->db->select("CAST(A.Kd_Urusan AS varchar(2))+'.'+RIGHT('0' + CAST(A.Kd_Bidang AS varchar(2)),2) AS Kd_Bidang_Gab");
$this->db->select("CAST(A.Kd_Urusan AS varchar(2))+'.'+CAST(A.Kd_Bidang AS varchar(2)) +' - '+ A.Nm_Bidang AS Nm_Bidang_Gab");
$this->db->from("Ref_Bidang A");
return $this->db->get()->result();
}
谢谢你的帮助…谢谢
1条答案
按热度按时间wfauudbj1#
你可以尝试使用concat函数
+
mysql不支持CAST
可以将数据强制转换到的varchar数据类型char
```$this->db->select("CONCAT(CAST(A.Kd_Urusan AS char(2)),'.',RIGHT(CONCAT('0',CAST(A.Kd_Bidang AS char(2))),2)) AS Kd_Bidang_Gab");
$this->db->select("CONCAT(CAST(A.Kd_Urusan AS char(2)),'.',CAST(A.Kd_Bidang AS char(2)) ,' - ', A.Nm_Bidang) AS Nm_Bidang_Gab");