How to use the 'in' of SQL using Class::DBI


No such thing as a small change
	PerlMonks

by palette (Scribe)

on May 21, 2007 at 08:41 UTC ( [id://616513]=perlquestion: print w/replies, xml )

Need Help??

palette has asked for the wisdom of the Perl Monks concerning the following question:

How to use the 'in' of SQL using Class::DBI

Eg: SELECT * FROM T1 WHERE COL1 IN ('AX','BX').

How can I implement the same in Class::DBI.

Comment on How to use the 'in' of SQL using Class::DBI

Replies are listed 'Best First'.
Re: How to use the 'in' of SQL using Class::DBI by fenLisesi (Priest) on May 21, 2007 at 09:23 UTC
Class::DBI::AbstractSearch and Class::DBI::Sweet should let you use `-in`, as in this untested bit: `MyClass->search_where({ col1 => { -in => \@items }})` [download] Hope this helps.	[reply] [d/l] [select]

Domain Nodelet^?

Node Status^?

node history
Node Type: perlquestion [id://616513]
Approved by planetscape
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others scrutinizing the Monastery: (8)

As of 2024-04-19 15:34 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found