Akelos Framework v1 forum archive. This forum is no longer maintained. To report bugs please visit https://github.com/akelos/akelos/issues

Akelos Programming: Find function using IN operator

Bottom of Page

1 to 1 of 1

  1.  
    • CommentAuthorasejua
     

    Hello,

    according to the AkActiveRecord documentation it would be possible to do this

    $AlertList =& $Alert->find( 'all' , array( 'conditions' => array( 
    'group_id IN (group_ids)' , 'group_ids' => join( ',' , array(14,17,18,19)) 
)));

    But dbug() messages drop me the following line

    (mysqlt): SELECT * FROM alerts WHERE group_id IN ()
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near ')' at line 1

    Seems IN is not taking the joined array values. Some ideas?

    Thanks :)

1 to 1 of 1

  1.  
Back to Discussions Top of Page