Re: Model-find() using group parameter
right, thank you.
On Aug 20, 5:37 pm, teknoid [EMAIL PROTECTED] wrote:
It's a feature, find('list') is usually done to build options for a
select box.
On Aug 20, 8:39 am, bitkidoku [EMAIL PROTECTED] wrote:
What about using 'list' instead of 'all', it is failing:
$this-Production-find('list', array('fields' = 'DISTINCT
supplier'));
CakePHP is trying to fetch Product.id as well. Is this a feature or a
bug? :)
On Aug 20, 3:12 pm, Amit Badkas [EMAIL PROTECTED] wrote:
2008/8/20 Amit Badkas [EMAIL PROTECTED]
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM
products
- Or using cake, $this-Production-find('all', array('fields' =
'DISTINCT
supplier'));
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/http://coppermine-gallery.net/http://chee...
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Model-find() using group parameter
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Model-find() using group parameter
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM products
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/
http://coppermine-gallery.net/
http://cheesecake-photoblog.org/
http://www.sanisoft.com/blog/author/amitbadkas
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Model-find() using group parameter
2008/8/20 Amit Badkas [EMAIL PROTECTED]
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM
products
- Or using cake, $this-Production-find('all', array('fields' = 'DISTINCT
supplier'));
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/
http://coppermine-gallery.net/
http://cheesecake-photoblog.org/
http://www.sanisoft.com/blog/author/amitbadkas
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Model-find() using group parameter
Oh, I just got here to reply my own question, and there are two
answers already. Thanks for the answer!
On Aug 20, 3:12 pm, Amit Badkas [EMAIL PROTECTED] wrote:
2008/8/20 Amit Badkas [EMAIL PROTECTED]
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM
products
- Or using cake, $this-Production-find('all', array('fields' = 'DISTINCT
supplier'));
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/http://coppermine-gallery.net/http://cheesecake-photoblog.org/http://www.sanisoft.com/blog/author/amitbadkas
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Model-find() using group parameter
What about using 'list' instead of 'all', it is failing:
$this-Production-find('list', array('fields' = 'DISTINCT
supplier'));
CakePHP is trying to fetch Product.id as well. Is this a feature or a
bug? :)
On Aug 20, 3:12 pm, Amit Badkas [EMAIL PROTECTED] wrote:
2008/8/20 Amit Badkas [EMAIL PROTECTED]
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM
products
- Or using cake, $this-Production-find('all', array('fields' = 'DISTINCT
supplier'));
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/http://coppermine-gallery.net/http://cheesecake-photoblog.org/http://www.sanisoft.com/blog/author/amitbadkas
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
Re: Model-find() using group parameter
It's a feature, find('list') is usually done to build options for a
select box.
On Aug 20, 8:39 am, bitkidoku [EMAIL PROTECTED] wrote:
What about using 'list' instead of 'all', it is failing:
$this-Production-find('list', array('fields' = 'DISTINCT
supplier'));
CakePHP is trying to fetch Product.id as well. Is this a feature or a
bug? :)
On Aug 20, 3:12 pm, Amit Badkas [EMAIL PROTECTED] wrote:
2008/8/20 Amit Badkas [EMAIL PROTECTED]
2008/8/20 bitkidoku [EMAIL PROTECTED]
Hello everyone,
I am using CakePHP to build an application that will run on en
existing database. The problem I am facing is simple, I have products
table and let's say it is like this: id, name, supplier
Some stupid programmer (yes I am angry to him) didn't created the
table with supplier_id. So every time a product is being added
supplier field must be entered manually. This is not my problem. What
I want to do is to retrieve all the unique supplier names.
- To get unique suppliers, run query, SELECT DISTINCT supplier FROM
products
- Or using cake, $this-Production-find('all', array('fields' = 'DISTINCT
supplier'));
I tried:
$this-Product-find(
'all',
array(
'fields' = array('Product.supplier'),
'group' = 'Product.supplier'
)
);
It does not work. When I query the database manually using SELECT
supplier FROM table GROUP BY supplier it works.
Thank you very much for your answers.
--
Amit
http://amitrb.wordpress.com/http://coppermine-gallery.net/http://chee...
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---
