PDOException SQLSTATE[HY093]：yii-2 where和between查询

Question

经过长时间的研究，我找不到PDOException SQLSTATEHY093的确切解决方案，我正在使用yii 2框架，并且在使用between条件时出现问题。

$query = SalesOrder::find()->where(['between','created_date', ':fromDate', ':toDate']); 
$query->addParams([':fromDate' => $salesReport->fromDate,':toDate' => $salesReport->toDate]);
$query->all();

已尝试不同的方法解决相同的问题。

$qString1=':fromDate';
$qString2=':toDate';

$query = SalesOrder::find()->where(['between','created_date',$qString1,$qString2]); 
$query->addParams([':fromDate' => $salesReport->fromDate],[':toDate' => $salesReport->toDate]);
        $query->all();

由: PDOException SQLSTATEHY093:无效参数数:绑定变量数与令牌数不匹配

Answer 1

这种情况下不能传递参数名。尝试：

$query = SalesOrder::find()->where(['between','created_date', $salesReport->fromDate, $salesReport->toDate]);
$query->all();

或者，如果您想使用参数，请尝试：

$query = SalesOrder::find()->where('created_date BETWEEN :fromDate AND :toDate'); 
$query->addParams([':fromDate' => $salesReport->fromDate],[':toDate' => $salesReport->toDate]);
$query->all();