search for: createdate

Hi, i am struck up with solr''s date range search. I have used acts_as_solr plugin in my rails project. My model looks like acts_as_solr :fields => [:title,{:createdate=>:date}] No problem,if i used following date range search format => model.find_by_solr("createdate:[NOW-1DAY TO NOW+1DAY"] if i used following format => model.find_by_solr("createdate:[2010-07-02T00:00:00.000Z TO 2010-08-02T00:00:00.000Z]") i got err...

...NULL DEFAULT '', `quota` varchar(16) NOT NULL DEFAULT '0', `netdiskquota` varchar(16) NOT NULL DEFAULT '0', `domain` varchar(255) NOT NULL DEFAULT '', `uidnumber` int(6) NOT NULL DEFAULT '1000', `gidnumber` int(6) NOT NULL DEFAULT '1000', `createdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expiredate` date NOT NULL DEFAULT '0000-00-00', `active` smallint(1) NOT NULL DEFAULT '1', `disablepwdchange` smallint(1) DEFAULT NULL, `disablesmtpd` smallint(1) DEFAULT NULL, `disablesmtp` smallint(1) DEFAULT NUL...

Hello all, I recently discovered the "comment" command. I see it can only hold a vector of characters. Is there a way (or an alternative), to make it possible to have it keep a list? (for example, to keep different pieces of information like date of creation, information of each variable and so on) The closest solution I can think of is using 'names' on the vector, like this: