View Single Post
  #6 (permalink)  
Old 10-01-2007, 11:09 PM
Bootle Bootle is offline
Junior Member
 
Join Date: Oct 2007
Posts: 5
Default

From the documentation:

Quote:
10.4.3.10. Adding the DISTINCT Query Modifier

The distinct() method enables you to add the DISTINCT keyword to your SQL query.

Example 10.63. Example of the distinct() method


<?php

// Build this query:
// SELECT DISTINCT p."product_name"
// FROM "products" AS p

$select = $db->select()
->distinct()
->from(array('p' => 'products'), 'product_name');


10.4.3.11. Adding the FOR UPDATE Query Modifier

The forUpdate() method enables you to add the FOR UPDATE modifier to your SQL query
Zend Framework: Documentation

Doesn't seem like you can execute it from a model though...
Reply With Quote