tags:

views:

9

answers:

0
Q: 

Doctrine: Using DQL, how do I only grab one related record in a hasMany relationship?

Product has many product images.

I want to grab a bunch of products, while only getting one product image each. What's the DQL syntax for that?

I'm using Doctrine 1.2.

related questions

can you begin a mysql statement with "IF"?
implementing "update if exists" in Doctrine ORM
How much should doctrine record do?
Doctrine_RawSql custom Select
Doctrine raw sql and prepared statements
Complex WHERE clauses using the PHP Doctrine ORM
Doctrine Named Queries: Specifing limit on query call
Integrate Doctrine with Zend Framework 1.8 app
Why overriding Doctrine_Record::save() give me a strict standard error in Symfony 1.2 ?
Can Doctrine generated models have a prefix?
[Doctrine] Can fixtures "copy" items from other fixtures?
Why am I getting "validator failed" one a save with Doctrine on Symfony 1.2 ?
Updating textfield in doctrine produces an exception
Doctrine profiler does not catch queries
Symfony - How can I insert behaviors in my doctrine migrations ?
How to add ORM to a PHP legacy project?
How can I allow Duplicate Records in a Doctrine Collection
Should a company enforce the use of a single architecture across all development efforts?
Join Table On Self using Doctrine (DQL)
Unit testing Doctrine objects with PHPUnit
Can you generate a migration from an existing table with Doctrine?
Why is PHP Doctine's free() not working?
Why is doctrine returning more fields than I asked for?
What's your experience with Doctrine ORM?
Search strategies in ORMs