Displaying 4 results from an estimated 4 matches for "caught_on".
Did you mean:
caughron
2006 Jan 19
2
NOOB: Using locals to pass data to a SQL query
...r ="0" CELLSPACING="0">
<tr class="<%= alternate %>">
<td><%=h entry.name %> - </td>
<td><%=h entry.length %> Inches - </td>
<td><%=h entry.score %> Points - </td>
<td><%=h entry.caught_on.strftime("%m-%d-%Y") %></td>
<td><%= link_to ''Show'', :action => ''show'', :id => entry %></td>
<td><%= link_to ''Delete'', { :action => ''destroy'', :id =>
entry }, :c...
2006 Jan 10
0
find_by_sql + partials question
Ok now that I have find_by_sql love working for my "Top 10 List" I
want to make them a bit more DRY. Tis is what I have so far:
Model:
def self.topfish
find_by_sql["select species.name,
length,species.multiplier*length as score,caught_on from entries join
species on species_id = species.id where species_id = ? order by
score DESC LIMIT 10", species]
end
This data is spit out as part of a partial:
Partial:
<% for ling in @topfish %>
<table border ="0" CELLSPACING="0">
<tr class=&qu...
2006 Jan 19
8
I can''t figure out how to solve this one
...+---------------------
+----------------+
| id | int(11) | | PRI | NULL |
auto_increment |
| species_id | int(11) | | | 0
| |
| location_id | int(11) | | | 0
| |
| caught_on | datetime | | | 0000-00-00 00:00:00
| |
| user_id | int(11) | | | 0
| |
| length | int(3) | | | 0
| |
| image | varchar(100) | YES | | NULL...
2006 Jan 12
0
[file_column] Problem displaying images after upload
...d(:first).image_relative_path
=> "1/testpic.jpg"
>>
I think this might have todo with the way I am building @entry via a
find_by_sql:
def self.mine
find_by_sql("select entries.id,entries.image,
species.name, length,species.multiplier*length as score,caught_on
from entries join species on species_id = species.id order by score
DESC")
end
Any ideas what I am doing wrong?
- Bill