search for: date_cr

I was recently having problems accessing attributes in an object. Can somebody explain to me why this is, and if it is a bug? I have the following code: @archives = RapturePost.find_by_sql "select distinct date_format(rapture_posts.date_created,''%Y-%m'') date_created from rapture_posts where rapture_posts.site_id = 1 order by rapture_posts.date_created desc" I wish to loop through the contents of the object with the following: for archive in archives #do something with the contents of archive end Whenever I...

When I dump an instance variable to the web browser using object.inspect I get the following: This: <%= debug archive.inspect %> Yields this: #<RapturePost:0x2aaaacada118 @attributes={\"date_created\"=>\"2006-02\"}>" How do I access that date created value? Neither of the following work. The don''t give me the actual date value, only nil or blank. archive.date_created archive.attributes.date_created Any suggestions? michael -- Posted via http://ww...

...llpaper] StudioController: missing default helper path studio_helper Processing StudioController#create_wallpaper (for 64.166.12.169 at 2006-01-18 23:20:34) [POST] Parameters: {"commit"=>"Create", "wallpaper"=>{"downloads"=>"0", "date_created"=>"Wed Jan 18 23:20:12 PST 2006", "price"=>"0.0", "title"=>"test logger4", "date_available(1i)"=>"2006", "image_temp"=>"", "date_available(2i)"=>"1", "descr...

I know this has got to be a really dumb question, but here goes anyway. I''ve got a model with an associated table. One of the columns in the table is ''date_created'', which I want to be set to the date/time each row was added to the table. Seems to me that setting this in the initialize method for the model would be the right thing to do,... class MyThing < ActiveRecord::Base def initialize @date_created = DateTime.now end ... But t...

I''m having trouble finding then displaying all items in my "posts" table that match a certain search string. I have a from field: <%= start_form_tag :action=> "search" %> <div title="Search" id="searchform" class="form"> <h3>Search</h3> <%= error_messages_for ''post''

...g this error. ActiveRecord::StatementInvalid in ProjectsController#create Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' , , , , )'' at line 1: INSERT INTO projects (`name`, `date_created`, `quote_id`, `client_id`, `description`, `user_id`) VALUES(, , , , , ) all seem sto go wrong when I call if @project.save however when I change belongs_to :quote to belongs_to :quotes (extra s on the end) Everything seems to work here as expected. any suggestions why thi sis happening?...

...function(name, fullpath = FALSE, keep.old = FALSE, verbose = FALSE){ if(!file.exists(name)){ MESSG <- paste("file", name, "does not exist. No backup created.") warning(MESSG) return(NULL) } dir.source <- dirname(normalizePath(name)) date_cr <- base::format(base::file.info(name)$mtime, "%Y%m%d-%H%M") ext_name <- tools::file_ext(name) noext_name <- tools::file_path_sans_ext(name) new_name <- paste0(noext_name, "-", date_cr, if(!ext_name == "") {paste0( ".&...

Right, I'm baffled. I have: exten => s,1,MYSQL(Connect DB1 127.0.0.1 geraint xxx amis2) exten => s,n,MYSQL(Query NORESULT ${DB1} INSERT\ INTO\ recordings\ (caller_number\,called_number\,date_created\,date_started\,in_use\,server_id)\ VALUES\ (\'${CALLERID(number)}\'\,\'${ARG1}\'\,NOW()\,NOW()\,\'Yes\'\,12)) exten => s,n,MYSQL(Query RESULT1 ${DB1} SELECT\ LAST_INSERT_ID()) exten => s,n,MYSQL(Fetch FOUND1 ${RESULT1} VALUE1) exten => s,n,MYSQL(Clear ${RESULT1...

...an exception when I try and update a column with a duplicate foreign key. Inside the unit test, charge.time_logs << time_logs(:first) will generate ActiveRecord::StatementInvalid: Mysql::Error: #23000Duplicate entry ''20'' for key 2: UPDATE time_logs SET `task_id` = 1, `date_created` = NULL, `time_charge_id` = 20, `hours` = 2.0, `log_entry` = NULL WHERE id = 2 However, assert_raise ActiveRecord::StatementInvalid do charge.time_logs << time_logs(:first) end will generate <ActiveRecord::StatementInvalid> exception expected but none was throw...

...mple I am still a bit confused on how slotno actually works and what it actually is. I think the main thing is showing, in php (or C++ in the official docs), how to index a complex document of say: { "_id": string "text": string "tags": multivalue "date_created": timestamp } And sorting it via the different ways and showing exactly how to define that date_created is a timestamp and sort on that time stamp and also showing how to query tags field. This would really break the ice for anyone wanting to learn Xapian in PHP. Especially if they are...

I''ve been reading up on Berkeley DB and I''ve been refelcting on the Rails philosophy and it just seemed to me like the two should go together hand in glove. Rails seeks to abstract the programer from squirrely database coding which is great. My only problem is that you''re still left with a large component, namely the databsase server (MySQL, PostgreSQL..etc) which