[Dbix-class] same column for more times

Christopher H. Laco claco at chrislaco.com
Mon Feb 5 15:39:27 GMT 2007


Octavian Rasnita wrote:
> Hi all,
> =

> I have tried to use the same column for more times in the condition part
> of the query, but it is used only once.
> =

> I want to do something like:
> =

> select count(*) from table_name where date>=3D? and date<=3D?;
> =

> Can you also tell me how to use
> =

> and date between ? and ?
> =

> Or even better, please tell me in which of the POD docs to search for
> details about these.
> I have searched in more POD docs after some keywords, but I couldn't
> find anything.
> =

> Thank you.
> =

> Octavian

http://search.cpan.org/~jrobinson/DBIx-Class-0.07999_02/lib/DBIx/Class/Resu=
ltSet.pm#search

>   my $new_rs =3D $cd_rs->search([ { year =3D> 2005 }, { year =3D> 2004 } =
]);
>                  # year =3D 2005 OR year =3D 2004


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070205/e4=
c49c5d/signature.pgp


More information about the Dbix-class mailing list