代码点火器总是转义我的SELECT ... CASE查询 [英] Code igniter always escaping my SELECT ... CASE query
问题描述
我正在使用Codeigniter在我的数据库上触发查询。代码如下:
I am using Codeigniter to fire a query on my db. The code looks like:
$this->db->select("category.Name,
booking.Comment,
CASE WHEN amount > 0 THEN amount END AS PosAmount,
CASE WHEN amount < 0 THEN amount END AS NegAmount");
但是我总是得到一个
You have an error in your SQL syntax ... right syntax to use near
'WHEN amount > 0 THEN amount END AS PosAmount, `CASE` WHEN amount < 0
THEN amount' at line 1
Codeigniter正在转义CASE,但我不知道如何防止这种情况。
Codeigniter is escaping the CASE but I do not know how to prevent this.
有什么想法吗?
推荐答案
来自文档:
$ this-> db-> select()
接受可选的第二个参数。如果将其设置为FALSE
,CodeIgniter将不会尝试保护您的字段或表名。如果需要复合选择语句,其中的字段自动转义可能会破坏它们,这将很有用。
$this->db->select()
accepts an optional second parameter. If you set it toFALSE
, CodeIgniter will not try to protect your field or table names. This is useful if you need a compound select statement where automatic escaping of fields may break them.
在您的情况下:
$this->db->select("category.Name,
booking.Comment,
CASE WHEN amount > 0 THEN amount END AS PosAmount,
CASE WHEN amount < 0 THEN amount END AS NegAmount", FALSE);
第二个参数也可以在where和join子句中使用。
This second parameter can also be used in where and join clauses.
这篇关于代码点火器总是转义我的SELECT ... CASE查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!