phalcon orm problem

Question

phalcon orm problem

Xieyongmin Jun '15

Created Jun '15	Last Reply Jun '15	Replies 1	Views 644	Votes 0

Xieyongmin 1.2k

Jun '15

I used find, but throw this error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens' in

my query array is

array(4) { ["conditions"]=> string(54) "rcodeall LIKE '%:codeall_like:' and rstatus = :status:" ["bind"]=> array(2) { ["codeall_like"]=> string(12) "/index/index" ["status"]=> int(1) } ["hydration"]=> int(1) ["columns"]=> string(3) "rid" }

any one can help me?

Calin Rada
51.1k

Accepted
answer

Jun '15

Try this:

        YourModel::find(array(
            'rcodeall LIKE :codeall_like:',
            'bind' => array(
                'codeall_like' => '%/index/index',
            ),
        ));

Xieyongmin · Answer 1 · 2015-06-29T08:08:21-07:00

Xieyongmin
1.2k

Jun '15

You are right, i'm success Thank you!