Re: HOW to use find() to EXCLUDE some datasets?

Sorry... something like this should work:

'conditions' => array('NOT' => array('Model.fieldname' => array(5',
'6', 7')))
Should create something like NOT (Model.fieldname IN (5,6,7))

Lookup the book on cakephp.org for Complex Find Conditions

On Apr 19, 8:42 am, mivogt-LU <c...@mivogt.net> wrote:
> HI there,
>
> I want to use find() to exlude some data on a few conditions.
>
> My app is built like this
>
> customer->request->booking->bookingposition->lodging
>
> with request fields: Id         Name    Customer        Date1/Date2 (date1,2
> arrival,leave requested)
> with booking fields: Id         Name    Customer        Mealclass       Request
> with bookingpositionfields: Id          Booking         Date1/Date2 Lodging
> (date1,2 arrival,leave booked)
> *) I use 2 times a date fieldset if a customer might ask for a period
> he want to visit but do booking only a part of it (i.e. wants to visit
> in april staying 1 week...)
>
> Now if I do add a booking position to a customers booking the usual
> way is getting full the lodgings list from conroller by find(list).
> My goal is to exclude those that are already in use (should be easy to
> agree I need to do so..)
>
> With mysql I found 'NOT IN' syntax to fit my needs if I do something
> like this
> 1.) select * from bookingpositions, bookings, lodgings .. fittinng ore
> close the time of the new booking
> 2.) select * from lodgings not in result of 1.)
>
> Is there a way to do similar using the cake built in find function?
> Some syntax help would be great as I am not realy advanced with the
> conditions array
>
> Thanks in advance
>
> Michael
>
> Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscribe@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en