[Put the optional parts between parenthesis][1]:

    map.show_book &quot;/show_book/:name(/year/:year)&quot;, :controller =&gt; &quot;book&quot;, :action =&gt; &quot;show_version&quot;

and remove the second route.

**Update**

The above answer is only for rails 3 and above. Inverting the two routes definitions fixed the problem (see Alessandro&#39;s comment below).


  [1]: http://guides.rubyonrails.org/routing.html#bound-parameters &quot;Rails Guides - Routing - bound parameters&quot;

Is there is a way to get the query string in a passed URL string in Rails?

I want to pass a URL string:

    http://www.foo.com?id=4&amp;empid=6

How can I get `id` and `empid`? 


How to get a query string from a URL in Rails

Let&#39;s say I have a utility class DateUtil (see below). To use this method
a caller method uses DateUtils.getDateAsString(aDate). Would it be better to remove
the static modifier and make DateUtil a spring bean (see DateUtilsBean) and inject it into calling classes
or just leave it as is?

One disadvantage I can see with using static is issues around mocking, see https://stackoverflow.com/questions/153048/how-to-mock-with-static-methods

    public class DateUtils {
    
    	public static String getDateAsString(Date date) {		
    		String retValue =  &quot;&quot; // do something here using date parameter
    		return retValue;
    	}
    }

Spring Bean version

    @Component
    public class DateUtilsBean {
    
    	public String getDateAsString(Date date) {		
    		String retValue =  &quot;&quot; // do something here using date parameter
    		return retValue;
    	}
    }

Utility class in Spring application - should I use static methods or not?

I added in the route file:

    map.show_book &quot;/show_book/:name/year/:year&quot;, :controller =&gt; &quot;book&quot;, :action =&gt; &quot;show_version&quot;

I also added:

    map.show_book &quot;/show_book/:name&quot;, :controller =&gt; &quot;book&quot;, :action =&gt; &quot;show_version&quot;

to show the latest book without specifying the year.

But it doesn&#39;t work, it cannot find the route in &quot;show_book/NAME&quot; if I don&#39;t pass the year.

Do you have some ideas why it doesn&#39;t work ?

THANKS !

PS.
I know that I can use year as parameter with &quot;?year=XXXX&quot;, but I want to use the year as a part of the URL

Routing with an optional parameter

I added in the route file:
<pre><code class="hljs language-javascript">map.show_book "/show_book/:name/year/:year", :controller => "book", :action => "show_version"
</code></pre>
I also added:
<pre><code class="hljs language-javascript">map.show_book "/show_book/:name", :controller => "book", :action => "show_version"
</code></pre>
to show the latest book without specifying the year.
But it doesn't work, it cannot find the route in "show_book/NAME" if I don't pass the year.
Do you have some ideas why it doesn't work ?
THANKS !
PS.
I know that I can use year as parameter with "?year=XXXX", but I want to use the year as a part of the URL

Is there a way to run rake commands for db:migrate and db:rollback on the console? 

It sucks to wait for the rails environment to load! 


Run migrations from rails console

I am getting the following error when I try to use gems in windows, and I also referred to 
[this stackoverflow post][1] and updated rubygems and rails. But nothing could solve the problem.

The following is the complete error,

&lt;pre&gt;
    D:\&gt;gem env
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/tilt-1.3.3.gemspec]: invalid date format in specification: &quot;2011-08-25 00:00:00
.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/execjs-1.2.4.gemspec]: invalid date format in specification: &quot;2011-08-03 00:00:
00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/temple-0.3.3.gemspec]: invalid date format in specification: &quot;2011-08-26 00:00:
00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/guard-0.6.3.gemspec]: invalid date format in specification: &quot;2011-09-01 00:00:0
0.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/guard-livereload-0.3.1.gemspec]: invalid date format in specification: &quot;2011-09
-01 00:00:00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/rack-cache-1.0.3.gemspec]: invalid date format in specification: &quot;2011-08-27 00
:00:00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/tilt-1.3.3.gemspec]: invalid date format in specification: &quot;2011-08-25 00:00:00
.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/execjs-1.2.4.gemspec]: invalid date format in specification: &quot;2011-08-03 00:00:
00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/temple-0.3.3.gemspec]: invalid date format in specification: &quot;2011-08-26 00:00:
00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/guard-0.6.3.gemspec]: invalid date format in specification: &quot;2011-09-01 00:00:0
0.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/guard-livereload-0.3.1.gemspec]: invalid date format in specification: &quot;2011-09
-01 00:00:00.000000000Z&quot;
Invalid gemspec in [D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8/specifications
/rack-cache-1.0.3.gemspec]: invalid date format in specification: &quot;2011-08-27 00
:00:00.000000000Z&quot;
RubyGems Environment:
  - RUBYGEMS VERSION: 1.7.2
  - RUBY VERSION: 1.8.7 (2011-06-30 patchlevel 352) [i386-mingw32]
  - INSTALLATION DIRECTORY: D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8
  - RUBY EXECUTABLE: D:/RailsInstaller/Ruby1.8.7/bin/ruby.exe
  - EXECUTABLE DIRECTORY: D:/RailsInstaller/Ruby1.8.7/bin
  - RUBYGEMS PLATFORMS:
    - ruby
    - x86-mingw32
  - GEM PATHS:
     - D:/RailsInstaller/Ruby1.8.7/lib/ruby/gems/1.8
     - C:/Documents and Settings/jeygokul/.gem/ruby/1.8
  - GEM CONFIGURATION:
     - :update_sources =&gt; true
     - :verbose =&gt; true
     - :benchmark =&gt; false
     - :backtrace =&gt; false
     - :bulk_threshold =&gt; 1000
  - REMOTE SOURCES:
     - http://rubygems.org/
&lt;/pre&gt;

  [1]: https://stackoverflow.com/questions/5771758/invalid-gemspec-because-of-the-date-format-in-specification

Invalid date format specification in gemspec

    class Agents &lt;&lt; ActiveRecord::Base
      belongs_to :customer
      belongs_to :house
    end

    class Customer &lt;&lt; ActiveRecord::Base
      has_many :agents
      has_many :houses, through: :agents
    end
    
    class House &lt;&lt; ActiveRecord::Base
      has_many :agents
      has_many :customers, through: :agents
    end


How do I add to the `Agents` model for `Customer`?

Is this the best way?

    Customer.find(1).agents.create(customer_id: 1, house_id: 1)

The above works fine from the console however, I don&#39;t know how to achieve this in the actual application. 

Imagine a form is filled for the customer that also takes `house_id` as input. Then do I do the following in my controller?

    def create 
      @customer = Customer.new(params[:customer])
      @customer.agents.create(customer_id: @customer.id, house_id: params[:house_id])
      @customer.save
    end

Overall I&#39;m confused as to how to add records in the `has_many :through` table?





how to add records to has_many :through association in rails

I have a rails application running on localhost:3000. I wish to access it from another computer on the same network. I feel like i&#39;ve done this before with ease, but it&#39;s giving me some grief. I can ping the IP of the computer just fine, but hitting ip:3000 in the browser doesnt work. I tried launching `rails s -b ipaddress` as well, and no luck.

Suggestions?

Access webrick/rails from another computer on local network

I have a route on my Express app that looks like this:

    app.get(&#39;/:id&#39;, function (request, response) {
      …
    });

The ID will always be a number. However, at the moment this route is matching other things, such as `/login`. 

I think I want two things from this: 

1. to only use this route if the ID is a number, and 
2. only if there isn&#39;t a route for that specific paramater already defined (such as the clash with `/login`).

Can this be done?

Express routes parameter conditions

I&#39;ve just started learning the Laravel framework and I&#39;m having an issue with routing.

The only route that&#39;s working is the default home route that&#39;s attached to Laravel out of the box.

I&#39;m using WAMP on Windows and it uses PHP 5.4.3, and Apache 2.2.22, and I also have mod_rewrite enabled, and have removed the &#39;index.php&#39; from the application.php config file to leave an empty string.

I&#39;ve created a new controller called **User**:

    class User_Controller extends Base_Controller {
    
        public $restful = true;
    
        public function get_index() 
        {
            return View::make(&#39;user.index&#39;);
        }
    }

I&#39;ve created a view file in application/views/user/ called **index.php** with some basic HTML code, and in routes.php I&#39;ve added the following:

    Route::get(&#39;/&#39;, function () {
        return View::make(&#39;home.index&#39;);
    });
    
    Route::get(&#39;user&#39;, function () {
        return View::make(&#39;user.index&#39;);
    });

The first route works fine when visiting the root (`http://localhost/mysite/public`) in my web browser, but when I try to go to my second route with `http://localhost/mysite/public/user` I get a 404 Not Found error. Why would this be happening?

My Routes are Returning a 404, How can I Fix Them?

I&#39;m using the default template generated by Asp.net Web Api. I&#39;m working with the Get() Part:

            // GET api/values
        public IEnumerable&lt;string&gt; Get()
        {
            return new string[] { &quot;value1&quot;, &quot;value2&quot; };
        }

For some reason the i thought the only thing you had to do to access to query string was just to create an input string variable. So i created one more function (the only change i made) to the default controller generated:

            public IEnumerable&lt;string&gt; Get(string queryString)
        {
            return new string[] { &quot;value3&quot;, &quot;value4&quot; };
        }


I put a break point in both methods but even if i add a query string it always goes to the function with no parameters. So if i go to `http://mybaseurl/api/values?foo=f`
 it still is going to Get() instead of get(string queryString). Does it not work the way i thought? I know i can access the query string in the Get() function using `Request.RequestUri.ParseQueryString();` but i prefer to have it separated like this if possible.

Accessing the query string in ASP.Net Web Api?

My route is correctly configured, and my methods have the decorated tag.  I still get &quot;The requested resource does not support HTTP method &#39;GET&#39;&quot; message?

    [System.Web.Mvc.AcceptVerbs(&quot;GET&quot;, &quot;POST&quot;)]
    [System.Web.Mvc.HttpGet]
    public string Auth(string username, string password)
    {
      // D&#233;coder les param&#232;tres re&#231;ue.
      string decodedUsername = username.DecodeFromBase64();
      string decodedPassword = password.DecodeFromBase64();
                
      return &quot;value&quot;;
    }

Here are my routes:

    config.Routes.MapHttpRoute(
    	name: &quot;AuthentificateRoute&quot;,
    	routeTemplate: &quot;api/game/authentificate;{username};{password}&quot;,
    	defaults: new { controller = &quot;Game&quot;,
    					action = &quot;Auth&quot;, 
    					username = RouteParameter.Optional, 
    					password = RouteParameter.Optional },
    	constraints: new { httpMethod = new HttpMethodConstraint(HttpMethod.Get) }
    );
    
    config.Routes.MapHttpRoute(
    	name: &quot;DefaultApi&quot;,
    	routeTemplate: &quot;api/{controller}/{id}&quot;,
    	defaults: new { controller = &quot;Home&quot;, id = RouteParameter.Optional }
    );

The requested resource does not support HTTP method &#39;GET&#39;

I installed Laravel 4 using Composer and also set up a virtual host. Currently, only the root route is working:

&lt;!-- language: php --&gt;

    &lt;?php

    Route::get(&#39;/&#39;, function()
    {
    	return View::make(&#39;hello&#39;);
    });

This is not:

    Route::get(&#39;/hello&#39;, function()
    {
    	return View::make(&#39;hello&#39;);
    });

What I&#39;m trying to hit is `TasksController` at `/tasks`:

    Route::resource(&#39;tasks&#39;, &#39;TasksController&#39;);

This is giving me 404 error as well. What could I be doing wrong? I have a default .htaccess file at the root of my project:

    &lt;IfModule mod_rewrite.c&gt;
        Options -MultiViews
        RewriteEngine On
        RewriteCond %{REQUEST_FILENAME} !-f
        RewriteRule ^ index.php [L]
    &lt;/IfModule&gt;

I am using localhost on a Mac.

Laravel 4 All Routes Except Home Result in 404 Error

I have the following developement section of my `development.yml` file:

    development:
      adapter: postgresql
      host: localhost
      database: testtb
      username: app_user
      password: ENV[&#39;APP_USER_POSTGRES_PASSWORD&#39;]     &lt;= Troublesome line

When I open a rails console via `bundle exec rails console` and type `ENV[&#39;APP_USER_POSTGRES_PASSWORD&#39;]` I get back the DB password I&#39;ve specified in my local profile. However, when I start my rails server, it can&#39;t connect to the DB, failing with 

    PGError FATAL:  password authentication failed for user &quot;app_user&quot;

This was previously working when I had the DB password actually typed out in plain text, rather than trying to access it via `ENV[&#39;...&#39;]`, but for obvious reasons I want to keep the actual password out of this file entirely (and therefore out of the code repository) while still being able to commit other, non-secure changes to the `database.yml` file.

**Is there something special about the syntax I&#39;m missing**, or are the environment variables for some reason not available when the `database.yml` file is being loaded?

Failing to access environment variables within `database.yml` file

I want to check when my object `@objectname` is not equal to null to show the values of the `@objectname` else to show that no values found. 

I tried this:

    &lt;% if (@objectname != null) then %&gt;

but I&#39;m getting an error.

How I can check if an object is null in ruby on rails 2?

I&#39;m running a Rails 2.3.5 application and upon running script/server I am shown the following:

    ./script/../config/../vendor/rails/railties/lib/rails/gem_dependency.rb:21:in `add_frozen_gem_path&#39;: undefined method `source_index&#39; for Gem:Module (NoMethodError)
    	from ./script/../config/boot.rb:60:in `load_initializer&#39;
    	from ./script/../config/boot.rb:44:in `run&#39;
    	from ./script/../config/boot.rb:17:in `boot!&#39;
    	from ./script/../config/boot.rb:123
    	from script/server:2:in `require&#39;
    	from script/server:2

If I comment out line 60 in boot.rb (Rails::GemDependency.add_frozen_gem_path) and run script/server, I get this:

    =&gt; Booting WEBrick
    =&gt; Rails 2.3.5 application starting on http://0.0.0.0:3000
    ./script/../config/../vendor/rails/railties/lib/rails/gem_dependency.rb:21:in `add_frozen_gem_path&#39;: undefined method `source_index&#39; for Gem:Module (NoMethodError)
    	from ./script/../config/../vendor/rails/railties/lib/initializer.rb:298:in `add_gem_load_paths&#39;
    	from ./script/../config/../vendor/rails/railties/lib/initializer.rb:132:in `process&#39;
    	from ./script/../config/../vendor/rails/railties/lib/initializer.rb:113:in `send&#39;
    	from ./script/../config/../vendor/rails/railties/lib/initializer.rb:113:in `run&#39;
    	from /home/developer/bigpink/config/environment.rb:13
    	from /home/developer/bigpink/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require&#39;
    	from /home/developer/bigpink/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require&#39;
    	from /home/developer/bigpink/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in&#39;
    	from /home/developer/bigpink/vendor/rails/activesupport/lib/active_support/dependencies.rb:156:in `require&#39;
    	from /home/developer/bigpink/vendor/rails/railties/lib/commands/server.rb:84
    	from script/server:3:in `require&#39;
    	from script/server:3

So, not really sure what to do. Hoping I can get some quick help. Thanks!

Content Type	Original Author	Original Content on Stackoverflow
Question	Alessandro De Simone	View Question on Stackoverflow
Solution 1 - Ruby on-Rails	Benoit Garret	View Answer on Stackoverflow

Routing with an optional parameter

Ruby on-Rails Problem Overview

Ruby on-Rails Solutions

Solution 1 - Ruby on-Rails

Utility class in Spring application - should I use static methods or not?

How to get a query string from a URL in Rails

Attributions