[Dbix-class] Constructing "WHERE" clause in DBIx

[Eric Wee]

All good guys!

 

Thanks heaps for your help.

 

________________________________

From: fREW Schmidt [mailto:frioux at gmail.com] 
Sent: Tuesday, 11 August 2009 1:50 PM
To: DBIx::Class user and developer list
Subject: Re: [Dbix-class] Constructing "WHERE" clause in DBIx

 

Yeah, that's gonna need to be 

-or => [ ... ]

And I don't think the -and is needed.

	On Aug 10, 2009 8:58 PM, "Rob Kinyon" <rob.kinyon at gmail.com>
wrote:

	On Mon, Aug 10, 2009 at 19:42, Eric Wee<EWee at au.westfield.com>
wrote: > $c->model(DB::Client)->searc...

	This should do the trick. Peter will chime in with corrections
as needed.

	->search({ is_retail => '1', enabled_date => { '!=' => undef }, 

	   enabled_date => { '<' => \'NOW()' },
	   -and => {
	       -or => {
	           disabled_date => undef,
	           disabled_date => { '<' => 'enabled_date' },
	           disabled_date => { '>' => \'NOW()', }
	       },
	   },
	});
	
	The scalarref is important for NOW() otherwise it won't work.
	
	Rob
	
	_______________________________________________
	List:
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
	IRC: irc.perl.org#dbix-class
	SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
	Searchable Archive:
http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk


______________________________________________________
    CONFIDENTIALITY NOTICE    
This electronic mail message, including any and/or all attachments, is for the sole use of the intended recipient(s), and may contain confidential and/or privileged information, pertaining to business conducted under the direction and supervision of the sending organization. All electronic mail messages, which may have been established as expressed views and/or opinions (stated either within the electronic mail message or any of its attachments), are left to the sole responsibility of that of the sender, and are not necessarily attributed to the sending organization. Unauthorized interception, review, use, disclosure or distribution of any such information contained within this electronic mail message and/or its attachment(s), is (are) strictly prohibited. If you are not the intended recipient, please contact the sender by replying to this electronic mail message, along with the destruction all copies of the original electronic mail message (along with any attachments).
______________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20090811/78bae8c6/attachment-0001.htm