大家好，我想问，我开发了一些应用程序与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");