Displaying 20 results from an estimated 100000 matches similar to: "one item in a return list"
2007 Jan 20
2
find_by_sql with named parameterized sql
I tried to use named parameters in my SQL query , using find_by_sql
Order.find_by_sql ([select * from orders where amount > ? and quantity >
?", [ @amount, @quantity ] works;..
but
Order.find_by_sql ([select * from orders where amount > :amount and
quantity > :quantity ", [ :amount => @amt, :quantity => @qty ] is not
working
a I wrong or should I use a plain select
2009 Apr 11
6
Inserting data from 1 table to another by using find_by_sql
Hi All,
I am inserting data from one table to another by using following method
@data=RoyaltyReportFiles.find_by_sql("insert into royalty_reports
(artist_name, album_name) select artist_name, album_name from
temp_royalty_reports where id=328417")
it saves the data into royalty_reports table but it gives following
error and application crashes. i am using rails 1.2.5
You have a nil
2007 Nov 02
3
Date Issues + Oracle + RoR
Hi Experts
I''ve a product like this
ID -> 1
Name -> Xyz
Price -> 30
Created_at -> 02-NOV-07
from_date = Date.new(2, 10, 07)
to_date = Date.new(2, 10, 07)
@product = Product.find_by_sql("select * from products where
created_at between from_date and to_date")
code works perfectly, buy my issue is i dont get any data. always says
no record found
but if i use
2008 Jun 23
1
Find_by_sql Doesn't Return Attributes?
My find_by_sql is not returning attributes of the calling model class.
Thermo.find_by_sql("SELECT COUNT(*) FROM thermo WHERE thermo_loc =
''back'' GROUP BY DAYOFWEEK(time_on) ASC")
# ==> [#<Thermo >, #<Thermo >, #<Thermo >, #<Thermo >, #<Thermo >,
#<Thermo >, #<Thermo >]
The sql is fine and when I checked it in a mysql
2008 Jun 26
9
find_by_sql + Join + Rails 2
Hello
I have write a code to select data from two tables (T1,T2) but the
problem is
@tables= T1.find_by_sql("select T1.*,T2.* from T1inner join T2on
T1.followup_id = T2.id where followups.userid = ''41'' ")
THe problem all values that is returned from running only T1
variables,why?
Where are T2 variables??
--
Posted via http://www.ruby-forum.com/.
2007 May 02
2
WHERE NOT syntax with ActiveRecord
I need to run a sql statement along the lines of SELECT * FROM items
WHERE NOT ... But I would like to run this in the ActiveRecord syntax. I
like using :conditions => [...] but obviously where it renders ''WHERE
NOT'' and not simply ''WHERE''. I''d rather not use find_by_sql if at all
possible for security reasons. Anyone know how to do this?
Thanks,
2008 Sep 17
13
Capturing the sql from a statement without executing it?
Hi guys,
Is there an elegant way to capture the sql that would have been
executed by an ActiveRecord statement, without actually executing
it? :)
I''m imagining something like
sql = User.find(1).groups.to_sql
or perhaps
sql = ActiveRecord::Base.capture_sql { User.find(1).groups }
resulting in sql = ''SELECT * FROM groups INNER JOIN memberships....
WHERE users.id =
2008 May 21
3
Test returned value by sql statement
Hello people,
just wanted to know how to actually test returned value from sql
statement like :
@alreadyused = Promotioncodes.find_by_sql [ "select alreadyused from
promotioncodes where id = ?", @codeid ]
I would like to check whether @alreadyused has value 1 or 0
It doesn''t seem a simple if @alreadyused would word ...
Regards
Joel
2007 Nov 30
2
find_by_sql preformance problems when ordering data
Hi,
I am bumping into a small problem I was hoping someone could send me in
the right direction on.
I''m counting votes from a votes table to try to find the top ten videos.
The following works really well, until I try to order it. It would seem
that the order by is adding a 26 second delay, which surprised me since
it was all done in sql. I revised the process to sort and publish on
2007 Jul 29
3
capistrano problems
I installed capistrano and have tried several things. Can''t seem to get
it working.
This is what i am getting.
C:\ruby\radrails\modernfossil>cap deploy
* executing `deploy''
* executing `deploy:update''
** transaction: start
* executing `deploy:update_code''
svn: Can''t create tunnel: The system cannot find the file specified.
***
2006 Sep 01
3
find_by_sql with :include?
When you use find, you can include related objects with include so that
both objects get instantiated in the results, e.g. Foo.find(:all,
:include => :bar).
But when you use find_by_sql, is there a way to do this? You could
definitely write the find_by_sql SQL to join Foo and Bar tables:
Foo.find_by_sql("SELECT foo.*, bar.* from foo, bar where foo.bar_id =
bar.id")
But is there a
2008 May 30
9
find_by_sql without a model? how to do this?
Hi,
I''d like to do a "find_by_sql" without a model (e.g. <model
name>.find_by_sql("...")) as the results I get back are a once off special,
and I''m happy to handle them as an array. How do I do this?
"ActiveRecord::Base.find_by_sql(...)" does not seem to work?
Background - At the moment I''m doing within a model <model_name>,
2006 Dec 14
3
Problem with ActiveRecord and Associations
Hi,
I''m having what I believe to be a typecast problem with ActiveRecord and
Associations. In the code below, I need to flag a contact record for
deletion if the contact doesn''t have any addresses or books records:
sql = "select id, delete_flag from contacts where id = #{params[:id]}"
contact = Contact.find_by_sql(sql)
if (contact[0].addresses.count +
2006 Oct 02
2
when to use find_by_sql
I have a bunch of queries to compute some counters, like
find_by_sql(<<-SQL
SELECT p.*, c.nfavourites
FROM people p, (
SELECT fp.person_id, COUNT(fp.user_id) as nfavourites
FROM favourite_people fp, users u
WHERE fp.user_id = u.id
AND u.cluster = ''#{in_cluster_of_user.cluster}''
GROUP BY fp.person_id
) as c
WHERE
2007 Oct 16
11
how to arrange the field in excel by using to_csv
Hi all,
i am exporting the file by using to_csv, but its coming as unordered
rather than my expected output, if i check in the database, its working
fine, but in the excel sheet it shows in the unordered,so please let me
knoe, how to show orderly in the excel sheet by using to_csv.
@report_data=EdiaUserContact.find_by_sql(
"SELECT '''' as ''Title'',
2007 Aug 14
1
find_by_sql vs connection.select_all
I was trying to do SUM based mySQL query simliar to the following:
SELECT SUM(updated_on - created_on) AS total from signups
If I were to run this command in the mySQL console I would get a
result. However, if I were to run it using the following command in
Rails:
Signup.find_by_sql("SELECT SUM(updated_on - created_on) AS total from
signups")
The query that is written to the log is:
2007 Sep 18
3
html to pdf in rails
I''ve been searching for a way to easily convert an html page into a pdf
in my rails app and I haven''t found anything worth calling home about.
Has anyone found something good out there?
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails:
2006 Nov 21
2
Accessing scopes
If with_scope has been called previously, how do I access the find
conditions dynamically?
I am asking because I am using a find_by_sql call (which clobbers the
with_scope). How can I access the method scoping so that I can read it
and incorporate it into my query manually?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
2006 Sep 28
5
Eager loading using find_by_sql
Here''s the problem I have the following models
User - is a person
Team - is a team
Wherenote - snipet of info about a user''s whereabouts on a certain day
Team has_and_belongs_to_many :users
User has_and_belongs_to_many :teams
has_many :wherenotes
Wherenote belongs_to :user
each Wherenote has a note_date
On one page I want to pull back all the Users from a particular Team
2008 Feb 25
4
Using group in with find in an ActiveRecord appropriately
I''m playing around with the Practical Rails Projects code, and was
attempting to make a change for graphing data differently using
groupings.
Basically the code went from:
total_weight = @exercise.activities.collect {|e| e.repetitions
* e.resistance}
workout_dates = @exercise.activities.collect {|e|
e.workout.date.to_s}
To:
total_weight =