similar to: How do I write this SQL the Rails way?

Displaying 20 results from an estimated 3000 matches similar to: "How do I write this SQL the Rails way?"

2006 Mar 18
5
How would I get the previous id from the database?
I''m trying to get the id of the previous row prior to what would be input and then rename an uploaded image to that row number. So say the previous row was 19 and the image in that row was named 19.jpg, I''m wanting to name the next uploaded image as 20.jpg since the row that would be added then would be 20. Right now I''ve just got: @new_tutorial =
2006 Apr 12
6
distinguishing mapped urls from ordinary action urls
I want to present different view depending on the url. example below: http://myapp/start/show?url=xZq http://myapp/xZq both addresses are controlled by a single controller and the same action. the second url is only mapped in routes.rb how can I distinguished the mapped url and present a slightly different view in it? Sabon -------------- next part -------------- An HTML attachment was
2006 Mar 24
4
validate if different?
Hi, I seem to remember seeing the equivalent of saving only if all attributes are different. I can''t seem to find that now in the API or the agile book. I''m using the acts_as_versioned and only want to save if the input is different. Thanks, Steve http://www.smarkets.net -------------- next part -------------- An HTML attachment was scrubbed... URL:
2006 Mar 18
16
fixrbconfig - does it work on intel macs?
I''m trying now to do "sudo fixrbconfig" in the terminal, and I get this: /usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h does not exist. This probably means you haven''t yet installed Xcode from the Tiger DVD. You won''t be able to compile Ruby extensions without it. Please install it then rerun this program. I''m on an intel mac. Am I unable to use
2006 Jan 30
3
Arrays of objects as parameters to webservices
I think I am missing something terribly obvious. Is it possible to have an :expects parameter for a webservice that is an array of objects? I want to have a single webservice that expects all my line items (for an order). Is this something that is possible? -- Posted via http://www.ruby-forum.com/.
2006 Mar 18
3
Weird stylesheet_link_tag issue after moving servers
Dear experts, I am in the process of switching servers for my application. Before the move everything was working properly. After the move <%= stylesheet_link_tag ''/stylesheets/styles.css'' %> generates <link href="//stylesheets/styles.css" media="screen" rel="Stylesheet" type="text/css" />
2006 Feb 23
1
HABTM testing - fixtures not loading?
Hi, I have a strange problem with testing classes which have a HABTM relation. It seems that while running my tests with rake the fixture for the association table is not loaded - as a result I get a failure on a test which simply checks the number of associated elements - it says it''s 0 although there should be one. The weird thing is that when I run the tests with rcov
2006 Apr 20
5
How to find the last SQL statement executed in ActiveRecord
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/.
2006 Mar 24
6
login forms , redirect_to and ajax-scaffold problems
Hi, I have a standard type authentication technique direct from AWDWR, so there is a before_filter :authorize_employee, :except => :login in my employees_controller.rb the authorize_employee is in application.rb def authorize_employee unless session[:employee_id] flash[:notice] = "Please log in" # save the URL the user requested so we can hop
2006 Mar 22
3
Something wrong with content_columns
I have a database with a couple of tables. One table called spares has foreign keys in another called equipment. When I create a new record, it is added to the spares table however the list action does not show all the columns in the table. It only shows those columns that are not foreign keys. I am using the default action generated by scaffold for list. Why is that so? Do i need to re-write my
2006 Mar 31
2
Backslash Escaping in View
Ok, I''m hoping this won''t be a forehead slapper, but take a look at this code: physician.name.sub(/''/, "\\''") I''m trying to substitute a single quote with a backslash and a single quote. This seems pretty simple right? Well, someone kick me and tell me why it''s not :) Here''s what I''m getting if the
2006 Apr 20
1
fit testing, FitNesse
Hello, this is a typical "how do you do it in Rails" question :) I would like to incorporate fit testing into a RoR app and I''d like to hear your recommendations on how to do it. In the ideal world I would like all the table test definitions and implementations stored in svn together with the app, ability to run the tests with a rake task + a hook to FitNesse, so that
2006 Mar 24
2
Return all rows, split then show uniques
I''m returning some rows from a tags database that look like this: ID WORDS 1. apple banana pear 2. banana melon 3. apple peach lime What I want to do with that data is use the .split method to divide them into separate values in an array, then use the .uniq method to return a unique list of the words like so: apple, banana, pear, melon, peach, lime So in my controller I
2006 Mar 22
9
render partial from withit mail template
Hi, I''m trying to include a partial in an email template but it throws me this: undefined method `controller_path'' for SupportMailer:Class Extracted source (around line #12): 11: 12: <%= render :partial => ''footer'' %> I guess email views are a little different from normal ones as they don''t seem to have a access to a proper controller (?)
2006 Apr 12
1
acts_as_list problem with records coming in and out
I have the model that acts as list acts_as_list :scope => ''featured=1'' As you can see, I only need to order the records that are featured. However, from time to time I switch some featured items off and mark others as featured. When this is done, I start getting dublicate numbers on the list and ordering starts getting problem... What would be the good approach to
2006 Mar 18
2
basic operations in rails
Hi all, This must be such a beginner''s problem, but I can''t figure it out. I''m pulling two integers out of a database, and i want to divide one value with the other, but i keep getting an error about operating on strings. Here''s the code - low_freq = unsorted.last.freq high_freq = unsorted.first.freq divider = high_freq / low_freq In my view, if i display
2006 Mar 16
3
ACLSystem and session variables
I am using the ACL System that is described on the Rails wiki and I have a quick question. I want to set the "role" as a session variable so that I can display certain navigation schemes and I was doing it like this: @session[:user][:role] = @user.roles When I print out this variable I get: #<Role:0x3262d80> How can I turn this into a readable value? I tried .to_i
2006 Nov 24
2
advanced search with ferret?
Hello, I''m a novice to ferret, so far only used it via acts_as_ferret. My question is about a recommended pattern for an ''advanced search'', which would be searching by all fields of a model and some fields from related models, with range search, expression search and wildcards. The kind of search in which a user is presented with a huge form that allows them to set
2006 Apr 21
4
link_to_function with submit
I looked everywhere but couldn''t find it. I don''t want a submit_tag or image_submit_tag but a normal link that submits my form. Normally I would do this with a javascript like function sendForm () { document.forms[0].submit(); } but this doesn''t work with form_remote_tag link_to_function( ''Send'' , "sendform();") So the question is:
2006 Mar 30
2
How do I format text before saving it?
I tried to use a before_save and use simple_format, it returns and undefined method error. Can I even use these methods within a model? I tried to use auto_link and it failed too. What am I doing wrong? Furthermore, would it be recommended I format text before saving it to the database? Advantages or disadvantages? -- Posted via http://www.ruby-forum.com/.