I do it this way:

    = link_to image_tag( &#39;header.jpg&#39;), &#39;http://www.google.com&#39;

MS Access has a button to generate sql code for finding duplicated rows. I don&#39;t know if SQL Server 2005/2008 Managment Studio has this.

 1. If it has, please point where

 2. If it has not, please tell me how can I have a T-SQL helper for creating code like this.

How get the T-SQL code to find duplicates?

I have a bunch of high quality PNG files.  I want to use PHP to convert them to JPG because of it&#39;s smaller file sizes while maintaining quality.  I want to display the JPG files on the web.

Does PHP have functions/libraries to do this?    Is the quality/compression any good?

Use PHP to convert PNG to JPG with compression?

I have something like this in application.html.haml:

    #header
        = image_tag(&quot;header.jpg&quot;)

How do I make that link to www.google.com, for example?

Thanks

How do I make an image link tag using haml in Rails?

I have something like this in application.html.haml:
<pre><code class="hljs language-arduino">#header
 = image_tag("header.jpg")
</code></pre>
How do I make that link to <a href="http://www.google.com" target="_blank" rel="noopener noreferrer">www.google.com</a>, for example?
Thanks

I need to know the current route in a filter in Rails. How can I find out what it is?

I&#39;m doing REST resources, and see no named routes.


How can I find out the current route in Rails?

This is more of a &quot;why do things work this way&quot; question rather than a &quot;I don&#39;t know how to do this&quot; question...

So the gospel on pulling associated records that you know you&#39;re going to use is to use `:include` because you&#39;ll get a join and avoid a whole bunch of extra queries:

    Post.all(:include =&gt; :comments)

However when you look at the logs, there&#39;s no join happening:

    Post Load (3.7ms)   SELECT * FROM &quot;posts&quot;
    Comment Load (0.2ms)   SELECT &quot;comments.*&quot; FROM &quot;comments&quot; 
                           WHERE (&quot;comments&quot;.post_id IN (1,2,3,4)) 
                           ORDER BY created_at asc) 

It _is_ taking a shortcut because it pulls all of the comments at once, but it&#39;s still not a join (which is what all the documentation seems to say). The only way I can get a join is to use `:joins` instead of `:include`:

    Post.all(:joins =&gt; :comments)

And the logs show:

    Post Load (6.0ms)  SELECT &quot;posts&quot;.* FROM &quot;posts&quot; 
                       INNER JOIN &quot;comments&quot; ON &quot;posts&quot;.id = &quot;comments&quot;.post_id

Am I missing something? I have an app with half a dozen associations and on one screen I display data from all of them. Seems like it would be better to have one join-ed query instead of 6 individuals. I know that performance-wise it&#39;s not always better to do a join rather than individual queries (in fact if you&#39;re going by time spent, it looks like the two individual queries above are faster than the join), but after all the docs I&#39;ve been reading I&#39;m surprised to see `:include` not working as advertised.

Maybe Rails _is_ cognizant of the performance issue and doesn&#39;t join except in certain cases?

Rails :include vs. :joins

As of Rails 2.3, what&#39;s the right way to add a directory to the load path so that it hooks into Rails&#39; auto-reloading mechanisms?

The specific example I&#39;m thinking of is I have a class that has several sub-classes using STI and I thought it would be a good idea to put them in a sub-directory rather than clutter the top-level.  So I would have something like:

    
    #app/models/widget.rb
    class Widget &lt; ActiveRecord::Base
       add_to_load_path File.join(File.dirname(__FILE__), &quot;widgets&quot;)
    end
    
    #app/models/widgets/bar_widget.rb
    class BarWidget &lt; Widget
    end
    
    #app/models/widgets/foo_widget.rb
    class FooWidget &lt; Widget
    end

It&#39;s the `add_to_load_path` method that I&#39;m looking for.

Adding a directory to the load path in Rails?

I want to get something like this to look nice:

    &gt;&gt; ProductColor.all
    =&gt; [#&lt;ProductColor id: 1, name: &quot;White&quot;, internal_name: &quot;White&quot;, created_at: &quot;2009-06-10 04:02:44&quot;, updated_at: &quot;2009-06-10 04:02:44&quot;&gt;, #&lt;ProductColor id: 2, name: &quot;Ivory&quot;, internal_name: &quot;Ivory&quot;, created_at: &quot;2009-06-10 04:02:44&quot;, updated_at: &quot;2009-06-10 04:02:44&quot;&gt;, #&lt;ProductColor id: 3, name: &quot;Blue&quot;, internal_name: &quot;Light Blue&quot;, created_at: &quot;2009-06-10 04:02:44&quot;, updated_at: &quot;2009-06-10 04:02:44&quot;&gt;, #&lt;ProductColor id: 4, name: &quot;Green&quot;, internal_name: &quot;Green&quot;, created_at: &quot;2009-06-10 04:02:44&quot;, updated_at: &quot;2009-06-10 04:02:44&quot;&gt;]

This doesn&#39;t work:

    &gt;&gt; ProductColor.all.inspect
    =&gt; &quot;[#&lt;ProductColor id: 1, name: \&quot;White\&quot;, internal_name: \&quot;White\&quot;, created_at: \&quot;2009-06-10 04:02:44\&quot;, updated_at: \&quot;2009-06-10 04:02:44\&quot;&gt;, #&lt;ProductColor id: 2, name: \&quot;Ivory\&quot;, internal_name: \&quot;Ivory\&quot;, created_at: \&quot;2009-06-10 04:02:44\&quot;, updated_at: \&quot;2009-06-10 04:02:44\&quot;&gt;, #&lt;ProductColor id: 3, name: \&quot;Blue\&quot;, internal_name: \&quot;Light Blue\&quot;, created_at: \&quot;2009-06-10 04:02:44\&quot;, updated_at: \&quot;2009-06-10 04:02:44\&quot;&gt;, #&lt;ProductColor id: 4, name: \&quot;Green\&quot;, internal_name: \&quot;Green\&quot;, created_at: \&quot;2009-06-10 04:02:44\&quot;, updated_at: \&quot;2009-06-10 04:02:44\&quot;&gt;]&quot;

And neither does this:

    &gt;&gt; ProductColor.all.to_yaml
    =&gt; &quot;--- \n- !ruby/object:ProductColor \n  attributes: \n    name: White\n    created_at: 2009-06-10 04:02:44\n    updated_at: 2009-06-10 04:02:44\n    id: \&quot;1\&quot;\n    internal_name: White\n  attributes_cache: {}\n\n- !ruby/object:ProductColor \n  attributes: \n    name: Ivory\n    created_at: 2009-06-10 04:02:44\n    updated_at: 2009-06-10 04:02:44\n    id: \&quot;2\&quot;\n    internal_name: Ivory\n  attributes_cache: {}\n\n- !ruby/object:ProductColor \n  attributes: \n    name: Blue\n    created_at: 2009-06-10 04:02:44\n    updated_at: 2009-06-10 04:02:44\n    id: \&quot;3\&quot;\n    internal_name: Light Blue\n  attributes_cache: {}\n\n- !ruby/object:ProductColor \n  attributes: \n    name: Green\n    created_at: 2009-06-10 04:02:44\n    updated_at: 2009-06-10 04:02:44\n    id: \&quot;4\&quot;\n    internal_name: Green\n  attributes_cache: {}\n\n&quot;

Thoughts?





How to get nice formatting in the Rails console

Are there any examples on the web of how to monitor delayed_job with [Monit][3]? 

Everything I can find uses [God][2], but I refuse to use God since long running processes in Ruby generally suck. (The most current post in the God mailing list? [God Memory Usage Grows Steadily][1].)

**Update:** delayed_job now comes with a [sample monit config][4] based on this question.


[1]: http://groups.google.com/group/god-rb/browse_thread/thread/836ccfdabfb7ec6c
[2]: http://god.rubyforge.org/
[3]: http://mmonit.com/monit/
[4]: http://github.com/collectiveidea/delayed_job/blob/master/contrib/delayed_job.monitrc

How to monitor delayed_job with monit

In my Rails template, I&#39;d like to accomplish final HTML to this effect using HAML:

    I will first &lt;a href=&quot;http://example.com&quot;&gt;link somewhere&lt;/a&gt;, then render this half of the sentence if a condition is met

The template that comes close:

    I will first
    = link_to &#39;link somewhere&#39;, &#39;http://example.com&#39;
    - if @condition
      , then render this half of the sentence if a condition is met

You may, however, note that this produces a space between the link and the comma. Is there any practical way to avoid this whitespace? I know there&#39;s syntax to remove whitespace around tags, but can this same syntax be applied to just text? I really don&#39;t like the solution of extra markup to accomplish this.

Haml: Control whitespace around text

    #item
creates a div with id=&quot;item&quot;

    .box#item
creates a div with class=&quot;box&quot; and id=&quot;item&quot;

    .box#=&quot;item &quot;+x
creates a div with class=&quot;box&quot; and a comment &#39;#=&quot;item&quot;+x&#39;

    .box#
      =&quot;item&quot;+x
throws &quot;Illegal element: classes and ids must have values.&quot;


How do I get set the id to a variable?

How do I make dynamic ids in Haml?

I have a jQuery script that adds a new field to a form, and this field contains dynamic information from an array. The problem is that I can&#39;t figure out how to add an array.each to populate the options of the select field within the javascript without breaking the HAML indentation and causing errors.

Here is my best attempt that does not work:

    %script(type=&quot;text/javascript&quot;)  
      $(&#39;#mylink&#39;).click(function() {  
      $(&#39;#mylink&#39;).after(&#39;&lt;select&gt;  
      - myarray.each do |options|  
         &lt;option value=&quot;#{options.id}&quot;&gt;#{options.name}&lt;/option&gt;  
      &lt;/select&gt;);  
      )};

Also tried it with the :javascript filter with no luck.

Ruby methods within Javascript within HAML

If `post.published?`

    .post
      / Post stuff

Otherwise

    .post.gray
      / Post stuff

I&#39;ve implemented this with rails helper and it seems ugly.

    = content_tag :div, :class =&gt; &quot;post&quot; + (&quot; gray&quot; unless post.published?).to_s do
      / Post stuff

Second variant:

    = content_tag :div, :class =&gt; &quot;post&quot; + (post.published? ? &quot;&quot; : &quot; gray&quot;) do
      / Post stuff

Is there a more simple and haml-specific way?

UPD. Haml-specific, but still not simple:

    %div{:class =&gt; &quot;post&quot; + (&quot; gray&quot; unless post.published?).to_s}
      / Post stuff

Haml: Append class if condition is true in Haml

I have the following function for using ZenDesk.  I&#39;d like to inject my current_user details into the form as follows. (this is my from html.haml template).  However I cannot figure out how to make this work.

    :javascript
        if (typeof(Zenbox) !== &quot;undefined&quot;) {
          Zenbox.init({
            dropboxID:   &quot;xxxxx&quot;,
            url:         &quot;xxxxx.zendesk.com&quot;,
            tabID:       &quot;support&quot;,
            tabColor:    &quot;black&quot;,
            tabPosition: &quot;Left&quot;,
            requester_name:  =current_user ? &quot;#{current_user.first_name} #{current_user.last_name}&quot; : &quot;&quot; ,
            requester_email: =current_user ? &quot;#{current_user.email}&quot; : &quot;&quot; ,
            hide_tab: true
            });
        }

In short, how does one inject rails variables into a :javascript element in haml.

Content Type	Original Author	Original Content on Stackoverflow
Question	Tony	View Question on Stackoverflow
Solution 1 - Ruby on-Rails	gdelfino	View Answer on Stackoverflow

How do I make an image link tag using haml in Rails?

Ruby on-Rails Problem Overview

Ruby on-Rails Solutions

Solution 1 - Ruby on-Rails

Use PHP to convert PNG to JPG with compression?

How get the T-SQL code to find duplicates?

Attributions