Tnx for this. Never saw such thing in doc.
On May 14, 5:52 pm, grigri <[email protected]> wrote:
> Why not do it this way?
>
> $conditions = array(
> 'MATCH(Product.title) AGAINST (? IN BOOLEAN MODE)' => array($blah)
> );
>
> I find this notation to be very convienient for this sort of thing
> (automatic sanitizing works fine)
>
> hth
> grigri
>
> On May 14, 4:30 am, "Dr. Loboto" <[email protected]> wrote:
>
> > You should properly escape value before put it in SQL:
>
> > 'MATCH(SearchIndex.data) AGAINST('.
> > ConnectionManager::getDataSource($this->ModelName->useDbConfig)->value
> > ($this->params['named']['search']).
> > ') IN BOOLEAN MODE)'
>
> > On May 14, 6:50 am, Kyle Decot <[email protected]> wrote:
>
> > > Awesome! I thought when you used an array, you had to provide a key.
> > > Thanks Brian!
>
> > > On May 13, 7:41 pm, brian <[email protected]> wrote:
>
> > > > I meant that you can add it to the array, though as a string (ie. no
> > > > key).
>
> > > > $conditions[] = 'MATCH(SearchIndex.data) AGAINST(\''
> > > > . $this->params['named']['search']
> > > > . '\') IN BOOLEAN MODE)';
>
> > > > On Wed, May 13, 2009 at 7:24 PM, Kyle Decot <[email protected]> wrote:
>
> > > > > Oh, my bad. I must have typed it incorrectly. They should all be
> > > > > $conditions; I'd rather do it in an array because I have a lot of
> > > > > different conditions/fields that can go into the array. Is it
> > > > > possible to do MATCHES in an array?
>
> > > > > On May 13, 7:20 pm, brian <[email protected]> wrote:
> > > > >> You mention both $conditions & $criteria so it's a bit difficult to
> > > > >> say for sure. But that last bit would probably work better as one
> > > > >> complete string.
>
> > > > >> 'MATCH(SearchIndex.data) AGAINST(\''
> > > > >> . $this->params['named']['search']
> > > > >> . '\') IN BOOLEAN MODE)';
>
> > > > >> On Wed, May 13, 2009 at 6:37 PM, Kyle Decot <[email protected]>
> > > > >> wrote:
>
> > > > >> > I am attempting to construct my array but am having some problems
> > > > >> > w/
> > > > >> > the $conditions array. I am doing something like:
>
> > > > >> > $conditions = array("Model.approved"=>1);
>
> > > > >> > if($something == $something_else)
> > > > >> > $conditions['Model.something'] = 1;
>
> > > > >> > if(!empty($search)) {
>
> > > > >> > $criteria["MATCH(SearchIndex.data) "] = "AGAINST(" .
> > > > >> > $this->params
> > > > >> > ['named']['search'] . "') IN BOOLEAN MODE)";
>
> > > > >> > }
>
> > > > >> > This is not making a valid mysql query. It's putting an equals sign
> > > > >> > right before the AGAINST part. How should I do this? Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
