Changeset 284

Show
Ignore:
Timestamp:
11/24/06 14:33:41 (2 years ago)
Author:
markus
Message:
  • Fix on postgresql
Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • tags/tag-1.2.0-alpha4/app/views/asset_tree/_recursive_tree_view.rhtml

    r242 r284  
    77<% for node in nodes -%> 
    88    <% 
    9       counts = Asset.connection.select_all("SELECT (SELECT count(*) FROM assets WHERE (assets.parent_id = #{node.id})) AS 'child_count', (SELECT count(*) FROM assets_user_groups WHERE (asset_id = #{node.id} and user_group_id in (#{group_ids.join(',')}))) AS 'aug_count'").first.values 
     9      counts = Asset.connection.select_all("SELECT (SELECT count(*) FROM assets WHERE (assets.parent_id = #{node.id})) AS child_count, (SELECT count(*) FROM assets_user_groups WHERE (asset_id = #{node.id} and user_group_id in (#{group_ids.join(',')}))) AS aug_count").first.values 
    1010      is_leaf = (counts.first == '0') 
    1111      is_root = node.is_root? 

© 2004-2007 Norfello Oy All Rights Reserved