# File sql-list.rb, line 58
  def each_with_index (&block)
    sql = "SELECT " + @dummy.instance_eval("sql_quote_name('sql_assoc_id')") + " FROM " 
    sql << @dummy.instance_eval("sql_quote_name('" + @classname + "')")
    sql << " ORDER BY " << @dummy.instance_eval("sql_quote_name(@sql_primary_key.id2name)") << " ASC"
    @dbi.select_all (sql) { |row|
      obj_id = row["sql_assoc_id"].dup
      obj_id.untaint
      # create a new instance
      obj = instance_eval(@classname + ".new")

      obj.sql_assoc_id = obj_id
      # load the object from the database
      obj.select (@dbi)

      index = obj.instance_eval("@" << @symbol)
      yield obj, index
    }
    return self
  end