[Catalyst] How to bind an array using my own schema

Jakub Tutaj jamz at wp.pl
Wed May 13 18:10:01 GMT 2009


Hi!
Is it possible to bind an array in code like below? Binding simple variables
works perfectly...

@myArray = (1,2,3);

my $superSchema = [$c->model('myApp::mySuperSchema')->search ( 
    {}, 
    {
        bind  => [ @myArray, $number]
    }
) ];

I'm using query like that in my schema mySuperSchema.pm:

SELECT column_id, number FROM table 
WHERE column_id IN (?) AND number != ?

Now I get an error: 
"Cannot bind unknown placeholder 3"

So is it matter of '?' in SQL query or I should specify bind parameter in
different way? 

Regards
Jakub Tutaj

	
-- 
View this message in context: http://www.nabble.com/How-to-bind-an-array-using-my-own-schema-tp23526664p23526664.html
Sent from the Catalyst Web Framework mailing list archive at Nabble.com.




More information about the Catalyst mailing list