This should do the trick
$product_type = 'bracelet'
$q = Doctrine_Query::create()
->from('Product p')
->where('p.product_type = ?', $product_type);
$result = $q->count();
2010/10/20 xpanshun <[email protected]>:
> Sorry, I also forget to mention that in DQL, I ultimately want to get
> an actual count (i.e. 0, 1, 2, etc.) of the rows where this query
> holds true.
>
> On Oct 20, 10:35 am, xpanshun <[email protected]> wrote:
>> Hi all,
>>
>> How can I code the following SQL query in DQL for my Symfony project?
>>
>> SELECT * FROM product WHERE product_type = 'bracelet'
>>
>> Thanks in advance!
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" 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/symfony-users?hl=en
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" 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/symfony-users?hl=en
