subject:"\[symfony\-users\] Re\: Help me for writing criteria"

[symfony-users] Re: Help me for writing criteria

2009-10-21 Thread Avani


ya.. it's working

Thanks Gareth..  :)

On Oct 21, 12:12 pm, Gareth McCumskey gmccums...@gmail.com wrote:
 $exploded_query = explode( , $this-query);

 $k-getNewCriterion(
 sfGuardUserProfilePeer::FIRST_NAME,%.$exploded_query[0].%,Criteria::LIKE)

 $k-getNewCriterion(
 sfGuardUserProfilePeer::LAST_NAME,%.$exploded_query[1].%,Criteria::LIKE)





 On Wed, Oct 21, 2009 at 5:25 AM, Avani avani.v.puj...@gmail.com wrote:

  Hi

  I have 1 table in my project, called sf_guard_user_profile. In
  which, there are 2 fields,

  1. first_name
  2. last_name

  I m working on search module

  in table, suppose there is 1 entry

  firstname = 'John'
  lastname = 'Lee'

  In search if any body searches for  'john lee', how to match ?

  bcoz query should be like..

  first_name+' '+last_name = 'john lee'

  If user searches for john   or   lee  than I can display records,

  $k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.$this-
  query.%,Criteria::LIKE)

  $k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.$this-
  query.%,Criteria::LIKE)

  but I dont know how to write for 'first_name' + ' ' + 'last_name'

  Pls help me...

  Thanks.

 --
 Gareth McCumskeyhttp://garethmccumskey.blogspot.com
 twitter: @garethmcc- Hide quoted text -

 - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---

[symfony-users] Re: Help me for writing criteria

2009-10-21 Thread HAUSa


Maybe this helps?

http://propel.jondh.me.uk/


On 21 okt, 09:45, Avani avani.v.puj...@gmail.com wrote:
 ya.. it's working

 Thanks Gareth..  :)

 On Oct 21, 12:12 pm, Gareth McCumskey gmccums...@gmail.com wrote:

  $exploded_query = explode( , $this-query);

  $k-getNewCriterion(
  sfGuardUserProfilePeer::FIRST_NAME,%.$exploded_query[0].%,Criteria::LIKE)

  $k-getNewCriterion(
  sfGuardUserProfilePeer::LAST_NAME,%.$exploded_query[1].%,Criteria::LIKE)

  On Wed, Oct 21, 2009 at 5:25 AM, Avani avani.v.puj...@gmail.com wrote:

   Hi

   I have 1 table in my project, called sf_guard_user_profile. In
   which, there are 2 fields,

   1. first_name
   2. last_name

   I m working on search module

   in table, suppose there is 1 entry

   firstname = 'John'
   lastname = 'Lee'

   In search if any body searches for  'john lee', how to match ?

   bcoz query should be like..

   first_name+' '+last_name = 'john lee'

   If user searches for john   or   lee  than I can display records,

   $k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.$this-
   query.%,Criteria::LIKE)

   $k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.$this-
   query.%,Criteria::LIKE)

   but I dont know how to write for 'first_name' + ' ' + 'last_name'

   Pls help me...

   Thanks.

  --
  Gareth McCumskeyhttp://garethmccumskey.blogspot.com
  twitter: @garethmcc- Hide quoted text -

  - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---

[symfony-users] Re: Help me for writing criteria

2009-10-21 Thread Gareth McCumskey

You will of course need to have checks to make sure that $exploded_query[1]
exists before using it, my example was just a quick way to point you in the
right direction

On Wed, Oct 21, 2009 at 9:45 AM, Avani avani.v.puj...@gmail.com wrote:


 ya.. it's working

 Thanks Gareth..  :)

 On Oct 21, 12:12 pm, Gareth McCumskey gmccums...@gmail.com wrote:
  $exploded_query = explode( , $this-query);
 
  $k-getNewCriterion(
 
 sfGuardUserProfilePeer::FIRST_NAME,%.$exploded_query[0].%,Criteria::LIKE)
 
  $k-getNewCriterion(
 
 sfGuardUserProfilePeer::LAST_NAME,%.$exploded_query[1].%,Criteria::LIKE)
 
 
 
 
 
  On Wed, Oct 21, 2009 at 5:25 AM, Avani avani.v.puj...@gmail.com wrote:
 
   Hi
 
   I have 1 table in my project, called sf_guard_user_profile. In
   which, there are 2 fields,
 
   1. first_name
   2. last_name
 
   I m working on search module
 
   in table, suppose there is 1 entry
 
   firstname = 'John'
   lastname = 'Lee'
 
   In search if any body searches for  'john lee', how to match ?
 
   bcoz query should be like..
 
   first_name+' '+last_name = 'john lee'
 
   If user searches for john   or   lee  than I can display records,
 
   $k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.$this-
   query.%,Criteria::LIKE)
 
   $k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.$this-
   query.%,Criteria::LIKE)
 
   but I dont know how to write for 'first_name' + ' ' + 'last_name'
 
   Pls help me...
 
   Thanks.
 
  --
  Gareth McCumskeyhttp://garethmccumskey.blogspot.com
  twitter: @garethmcc- Hide quoted text -
 
  - Show quoted text -
 



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

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

[symfony-users] Re: Help me for writing criteria

2009-10-21 Thread Avani


yes.

I did like this

$exploded_query = explode( , $this-query);

if(count($exploded_query)  1)
{
$k3=$k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.
$exploded_query[0].%,Criteria::LIKE);
$k3-addOr($k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.
$exploded_query[1].%,Criteria::LIKE));
$k1-addOr($k3);
}



On Oct 21, 4:21 pm, Gareth McCumskey gmccums...@gmail.com wrote:
 You will of course need to have checks to make sure that $exploded_query[1]
 exists before using it, my example was just a quick way to point you in the
 right direction





 On Wed, Oct 21, 2009 at 9:45 AM, Avani avani.v.puj...@gmail.com wrote:

  ya.. it's working

  Thanks Gareth..  :)

  On Oct 21, 12:12 pm, Gareth McCumskey gmccums...@gmail.com wrote:
   $exploded_query = explode( , $this-query);

   $k-getNewCriterion(

  sfGuardUserProfilePeer::FIRST_NAME,%.$exploded_query[0].%,Criteria::LIKE)

   $k-getNewCriterion(

  sfGuardUserProfilePeer::LAST_NAME,%.$exploded_query[1].%,Criteria::LIKE)

   On Wed, Oct 21, 2009 at 5:25 AM, Avani avani.v.puj...@gmail.com wrote:

Hi

I have 1 table in my project, called sf_guard_user_profile. In
which, there are 2 fields,

1. first_name
2. last_name

I m working on search module

in table, suppose there is 1 entry

firstname = 'John'
lastname = 'Lee'

In search if any body searches for  'john lee', how to match ?

bcoz query should be like..

first_name+' '+last_name = 'john lee'

If user searches for john   or   lee  than I can display records,

$k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.$this-
query.%,Criteria::LIKE)

$k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.$this-
query.%,Criteria::LIKE)

but I dont know how to write for 'first_name' + ' ' + 'last_name'

Pls help me...

Thanks.

   --
   Gareth McCumskeyhttp://garethmccumskey.blogspot.com
   twitter: @garethmcc- Hide quoted text -

   - Show quoted text -

 --
 Gareth McCumskeyhttp://garethmccumskey.blogspot.com
 twitter: @garethmcc- Hide quoted text -

 - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---

[symfony-users] Re: Help me for writing criteria

2009-10-20 Thread Gareth McCumskey

$exploded_query = explode( , $this-query);

$k-getNewCriterion(
sfGuardUserProfilePeer::FIRST_NAME,%.$exploded_query[0].%,Criteria::LIKE)

$k-getNewCriterion(
sfGuardUserProfilePeer::LAST_NAME,%.$exploded_query[1].%,Criteria::LIKE)

On Wed, Oct 21, 2009 at 5:25 AM, Avani avani.v.puj...@gmail.com wrote:


 Hi

 I have 1 table in my project, called sf_guard_user_profile. In
 which, there are 2 fields,

 1. first_name
 2. last_name

 I m working on search module

 in table, suppose there is 1 entry

 firstname = 'John'
 lastname = 'Lee'

 In search if any body searches for  'john lee', how to match ?

 bcoz query should be like..

 first_name+' '+last_name = 'john lee'


 If user searches for john   or   lee  than I can display records,


 $k-getNewCriterion(sfGuardUserProfilePeer::FIRST_NAME,%.$this-
 query.%,Criteria::LIKE)

 $k-getNewCriterion(sfGuardUserProfilePeer::LAST_NAME,%.$this-
 query.%,Criteria::LIKE)


 but I dont know how to write for 'first_name' + ' ' + 'last_name'

 Pls help me...

 Thanks.
 



-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

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

[symfony-users] Re: Help me for writing criteria

[symfony-users] Re: Help me for writing criteria

[symfony-users] Re: Help me for writing criteria

[symfony-users] Re: Help me for writing criteria

[symfony-users] Re: Help me for writing criteria

5 matches

Site Navigation

Mail list logo

Footer information