[Dbix-class] Arbitrary SQL + ResultSet
Jeremy Koch
jjkoch at gwi.net
Thu Jun 19 22:32:40 BST 2008
I am having trouble getting the results of a fairly complex query returned in
a D::C::ResultSet object. Following the example found in the D::C::Manual:Cookbook
"Arbitrary SQL through a custom ResultSource" doesn't work out for my query.
Relevent query snippit:
WHERE
username NOT IN( ? )
Perl snippit:
my $attr = { bind => [ qw(joeuser doeuser moeuser) ] };
my $rs = $dbic->resultset('ExportCustomer')->search( {}, $attr );
The placeholder expects a single value but I need to pass in an unknown number of
values. How can I express this?
-Jeremy
More information about the DBIx-Class
mailing list