similar to: How do you Convert a Time or Date to SQL formatted date?

Hey there all, Is there some way to tell rails or sql server to ignore the time in a datetime field when doing a comparison? For example, if I do something like select * from users where registration_date = ?, @date where @date might equal some user input like ''03/14/2006'' The result is nothing returned, because in my tables the datetime field looks like this: 3/14/2006

@products["car"] is not being recognized in my tests: class ProductsControllerTest < Test::Unit::TestCase fixtures :products def test_view_product post :view_product, :id=>@products["car"].id assert_template "view_product" ... end end products.yml : car: id:1 name:test Does anyone have any idea why its not working? Im having to do

Question for all: Right now i have a Table in a mySQL DB that has a row called Ingredients. When the data is entered into the DB its enter like so from a text area: 1 1/2 lbs. beef top sirloin, thinly sliced 1/3 cup white sugar 1/3 cup rice wine vinegar 2 tablespoons frozen OJ concentrate 1 teaspoon salt 1 tablespoon soy sauce 1 cup long grain rice 2 cups water 1/4 cup cornstarch 2 teaspoons

I''m having a great deal of trouble getting rake to run migrations on our staging server. Everything works fine on my dev box, but trying to run the following on staging results in errors. ----- > rake db:migrate (in /var/www/apps/acadtech2/app) rake aborted! Don''t know how to build task ''db:migrate'' (See full trace by running task with --trace) ---- The

Is there a method for retrieving the last SQL statement executed by ActiveRecord? I realize I can open the log file, but I''m looking for a programmatic way. -- Posted via http://www.ruby-forum.com/.

Hi all, I am using InstantRails with MySQL-Front. Date is stored in format yyyy-mm-dd in database. I want to retrieve and show date in dd-mm-yyyy in my view.rhtml. How can I change it to dd-mm-yyyy form. Please help me out. Thanks -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google

When I convert a datetime to a string, it prints out something like this Jan 20 12:00:00 EST 2006 I want to trim off the last twelve characters, i.e. :00 EST 2006 I tried to do it like so: @date = @meeting.date.to_s.chomp.chomp.chomp.chomp.chomp.chomp.chomp.chomp.chomp.chomp.chomp.chomp but the chomps seem to do nothing. I''d love to use regex, but I don''t know which

Hi, I''ve read that Dr. Dobbs Journal''s last issue has a cover article about Rails titled "Ruby On Rails - Java''s Successor?". Can''t find anything about it in http://www.ddj.com Does someone have the paper edition and can confirm that, and tell how the article looks like, and so on. Thanks, -- Jean-Fran?ois. -- ? la renverse.

Hi, Is this possible ive got layout "loggedout_layout", :only => [:login, :logout] but I also want to do somthing like layout "loggedin_layout", :except => [:login, :logout] When the second one is introduced it seems to cancel out the first request, any suggestions how to get around this? Scott -- Posted via http://www.ruby-forum.com/.

In trying to use as.Date(), I've come across the conversion of POSIXlt to POSIXct when a POSIXlt variable is included in a data frame: my_POSIX <- strptime(c("11-09-2006", "11-10-2006", "11-11-2006", "11-12-2006", "11-13-2006"), "%m-%d-%Y") str(my_POSIX) my_Date <- as.Date(my_POSIX) str(my_Date) data <- format(my_Date)

Hi- Is it possible to use search parameters with will_paginate? For example, something like this: @var = Model.paginate :per_page => 20, :page => params[:page], :order => ''my_date DESC'', :conditions =>["my_date >= ? AND my_date <=?",@start,@end] I am getting some errors with this, but will this generally work?

Greetings, I''m trying to convert a HABTM w/attributes join table in my database into a join model table in order to utilize the new has_many :through functionality introduced in Rails 1.1. Here''s the current table definition: licenses_user_groups: license_id, user_group_id, usage_notes Perhaps it was a mistake, but I made (license_id, user_group_id) the primary key. Now,

This seems like it must have been asked before - I really _did_ try to find it in the archives, so my apologies if it''s already out there. Utilizing ActiveRecord, I would like to specify a prefix for the column names in my table. For example, in ''Recipe 16 Integrating with Legacy Databases'' (Rails Recipes, from PragProg, by Fowler) they deal with integration with a

I have set up some fixtures in test/fixtures/users.xml: # Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html admin: id: 1 username: admin password: admin pbarry: id: 2 username: pbarry I have a unit test for my user model: require File.dirname(__FILE__) + ''/../test_helper'' class UserTest < Test::Unit::TestCase fixtures :users def

I love the routes feature for RoR...until now. I''m trying to write tests to make sure my urls are correctly mapping to the routes I expect them to map to. This is driving me nuts because I simply can''t get any of my tests to pass. I have thus concluded that routes must work differently than I thought. If someone could possibly point me in the right direction, I would really

Some blog sites and others (ticketmaster, for example) require you to read a graphical representation of a word or number to prevent a form from being submitted programmatically. I''d like to do something similar on a new site I''m building. Two quick questions: 1. Is there a standard term for these graphical representations? i.e. how would I do a google search for this

I''ve got a publications table that contains an author_id foreign key and a pubrole_id foreign key. What I want to do is query the DB using AR so that I can get a list of all publications that belong_to a particular author, and group the results by the pubrole.role_name (Author, Joint Author, Editor, etc.) so that the results look something like: Author book1 info book2 info etc.

After reading: <http://www.loudthinking.com/arc/000572.html> I''m trying to experiment with respond_to in order to not repeat myself and create atom feeds out of a "browse" view. In application controller I created a before filter that checks for the extension of the current url and changes the accept header: [code] def check_headers @headers["Accept"]

Hello there, I have something odd happening to my image tags when displaying an image. Here''s what my ''<img src>'' tags are looking like: <img alt="2-thumb" src="/images/public/uploaded_images/2-thumb.jpg?" /> Notice the question mark at the end of the string. I have no idea where this coming from. Here are the important parts of my

I was wondering if there is a Rails method that does something similar to the "About your application?s environment" link on the "Welcome Aboard" page you get when you first install Rails. What the link does is make and AJAX call, then blind down and up using AJAX. Thanks. -- Posted via http://www.ruby-forum.com/.