similar to: Creating ToDo List App

so here is the deal. i''ve got three tables: lists, items, comments, and this is how they are laid out: lists table id title items table id list_id item comments table id list_id comment to give you some background. in order to get a list of all the lists i am making this call: SELECT lists.id, title, count(items.list_id) AS total_list_items FROM lists INNER JOIN

Noob alert! Hi, I am having trouble figuring out how to filter a select helper. The following shows all of the rows in the table but I would like to filter the collection from the list_name column (:list_name => "Project Status"): @project_status = Valuelist.all.collect {|s| [s.list_value,s.id]} Thanks in advance, James -- Posted via http://www.ruby-forum.com/. -- You received

I have a procmail recipe that does the majority of my heavy lifting for my mailing lists. It's pretty straightforward, but as I understand it, this isn't something sieve can do: # [ ] contains a space and a tab :0 * 9876543210^0 ^(List-Id:.*<|X-Mailing-List:[ ]*)\/[-A-z0-9_+]+ * 9876543210^0 ^(List-Post:[ ]*(<mailto:)?|List-Owner:[ ]*(<mailto:)?owner-)\/[-A-Z0-9_+]+ *

Hello. I want to select an item from a select list and have that result in an ajax call that updates two sections on the page. Here is the code in the controller def create ... render :update do |page| page.replace_html ''list_items'', :partial => ''lists/list_items'' page.replace_html ''add_item'', :partial =>

hi, I have list of length 5453 and vector of length 14318.I need to compare the vector with the list and return the list name if matched.I am thinking of using an lapply but how to retrive the listname is wat i am puzzled abt. kindly let me know how to go abt it. Ramya -- View this message in context:

I''m new to RoR and have used PHP. I want to develop a personal organizer that allows me to add lists (tables) and search them. The ActiveRecord concept seems to allow me to set up something that works with an existing table, but I want the ability to add tables without programming. I know how to do this in PHP and I can put the SQL into queries in RoR, but does ActiveRecord let

In a quest to remove ?duplicate? messages sent to both me and lists I subscribe to I came up with this, which I think should clean out my Archive folder, but I?ve been unable to get it to work for scanning all on my list-user email. $ doveadm -f table fetch -u kremels 'hdr.message-id guid uid hdr.x-listname' mailbox "Archive" | sort| awk 'cnt[$1]++{if (cnt[$1]==2) print

Why can''t I use the RESTful route helpers in my specs? In my controller I''m doing a redirect: redirect_to list_path(:id => @item.list_id) Now when I write: controller.should_redirect_to list_path(:id => 2) I''m getting the following error: NoMethodError in ''POST on /lists/2/items should redirect to index on succesful POST'' You have a nil object

Ok, I''m sure this has to be something stupid that I''m doing (or not doing), but I can''t seem to get things to order by the specified column. class List < ActiveRecord::Base has_many :list_items, :order => "orderby" The error I get back when trying to save the link is: Unknown column ''position'' in ''order clause'':

Hi, I have two objects: Contacts Lists I want to be able to add multiple contacts to multiple lists. I''ve created a linking table and a form that allows me to select the contacts using checkboxes, but I''m having some problems with the controller and model. I receive the following error message when I submit the form: Mysql::Error: Cannot add or update a child row: a

Thanks! This is super-interesting. As I try to set up include, I get failures which may indicate a need for more coffee, but in /etc/dovecot/cond.f/90-sieve.conf I have: plugin { # Directory for :personal include scripts. The default is to use home directory. sieve_dir = %h/.sieve # Directory for :global include scripts (not to be confused with sieve_global_path). # If

Hi, I have another sieve question, this time about setting variables. I join a lot of mailing lists at ietf.org. I thought it'd be handy to filter these all into a common folder and then into individual folders, without having to configure each mailing list independently. So wrote this (this is just a part, obviously): require ["envelope", "variables",

Maybe this is normal operation, but this doesn''t seem right to me. I have models: - account -- has many listshares -- has many lists ( through listshares ) - list -- has many listshares -- has many accounts ( through listshares ) - listshare --belongs to account --belongs to list I would have expected that if I perform the action list.destroy, then any records in listshares with the

On August 4th (~9AM PDT, exact time TBD), all LLVM related mailing lists will move to a new mailing list server and will change to listname at lists.llvm.org. LLVMDev will probably change to LLVM-Dev to preserve consistency. This means a couple of things: 1) All mailing lists will be down on August 4th. We anticipated at least the full day of downtime (hopefully less if things go well). 2) SVN

Dear R helpers I am trying to convert a list into a data frame but when I try, I get a stack overflow error (Error: protect(): stack overflow). My list contains about 17000 rows and looks like shown at the bottom. The reason that I want to convert it in to a data frame is that I want to export it to a mysql database with the dbWriteTable function. The function that I use is

Apologies - I feel this is a very simple thing to do yet I am failing massively. I keep finding information about how to do much more complicated things (usually on this mailing list!), which then fail when I try to apply it to my simple task. Anyway, all I want to do is read in a series of key-value pairs from a file. I thought a list would be a good way to keep these, such that I could access

Dear All, I have been trying to install Xlsx package in R but i have been getting this error after the installation. Please can anyone help? > any(grepl("xlsx",installed.packages())) [1] TRUE > library("xlsx") Loading required package: rJava Error: package or namespace load failed for ?rJava?: .onLoad failed in loadNamespace() for 'rJava', details: call:

Hello, Dovecot. Is it possible to write one rule in sieve, which will: (1) Trigger on any message with "List-Id" header AND (2) Put this message to folder with name build from content of "List-Id" header, in such way, that message with List-Id List-Id: This is decription of list <list-name.host.org> will be put into folder "org.host.list-name" where

Hi, I have been using qmail-ldap for quite some time and now moved to postfix/dovecot. One feature that I miss is that provided by qmail-secretary. qmail-secretary basically is a mail list manager with following features: 1 no limit, just explode to all members 2 members only, as the name says; only members are allowed (based on envelope sender, so not very secure, everybody can fake

Hello All, I have Ubuntu 11-04, I would want to install ruby 1.9.2/1.9.1 and Rails 3.x. I need the least complicated way of doing this. Rgds, Janus -- *Satajanus Nig. Ltd * -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to