find_by_sql 小结

#  管理员有多少个

@member_count = Member.count(:conditions => ["authority = ?", "admin"])

# データ抽出「projects」Ruby Communityun:yp#M#K
      project = Project.find(:first,:conditions => ["project_code = ? ",params[:login][:project_code]]

# SQL作成（一覧）
M;T-\6N2J#i'q0      sql =      "SELECT id, info_name, member_name, updated_on "Ruby CommunityN$u+h dAV5qq
      sql.concat("FROM (SELECT * FROM infos WHERE project_id = ?) infos ")Ruby CommunityA3Q'_0sukP`]
      sql.concat("WHERE 1 = 1 ")

# セッションの確認Ruby Community.qu tP'[b1r)u2e
      if (session[:project] == nil)Ruby Community:sX0a5J/C/g
        raise "session error"
tY*~W/]6b#u0      end

# 権限の確認Ruby CommunityT W-a_$BC;J[
      if (session[:member][:authority].to_s == "guest")Ruby Community#Qli-@%`f J6ad
        raise "authority error"
v'hD?)V@rA;l0      end