2007/7/24, Matt S Trout <[EMAIL PROTECTED]>:
Yeah, it's a bug. Could you file on rt.cpan please?
Ticket #28451.
Note that whatever you end up calling your rels I'd advise plural names
for has_many rels for clarity - so 'people' rather than 'person' (I
actually think 'members' is a better name
Hi All
I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'
I tried $schema->resultset('employee')->search({ department => {"IS" =>
"NOT NULL"}});
But it is not working...
Any help?
Thanks
-Ram
___
List: http://lists.rawmod
On Tue, Jul 24, 2007 at 10:15:51PM +0530, Ramprabhu Kaliaperumal wrote:
> Hi All
>
> I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'
>
> I tried $schema->resultset('employee')->search({ department => {"IS" =>
> "NOT NULL"}});
SQL::Abstract and DBIx::Class both treat
| Hi All
|
| I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'
|
| I tried $schema->resultset('employee')->search({ department => {"IS" => "NOT
| NULL"}});
|
| But it is not working...
|
| Any help?
|
$rs->search( { department => { '!=', undef } } );
or
my
Any suggestions on how to use the overlaps operator? Using Postgresql..
I read the SQL::Abstract page after bottoming out on:
Cannot mix placeholder styles ":foo" and "?"
I found this in the docs:
my %where = (
user => 'nwiger',
completion_date => {
-no
All,
Since last week, I went ahead and separated, into its own GIT
repository and distribution series, the collection of pod-only files
that comprise the Muldis D language specification; from now on, to
see the development of the language spec itself, go to:
http://search.cpan.org/dist/Lan
