Displaying 20 results from an estimated 30000 matches similar to: "What page is an item on?"
2006 Apr 13
7
Complex SQL in paginate command?
Hi all,
Is there a way to create pagination with a complex SQL, more complex
than the :conditions option will support?
I have two databases, houses and images. Houses has_many images, and
each Image belongs_to house.
I''m creating a search engine for the house records and I''d like to be
able to filter out all the houses without any associated images.
So far I''m
2006 Aug 14
5
Tutorial for Queries
Hi! I''m looking for a good tutorial that explains the main points of
performing queries with Rails. I do have AWDWR and have read the
section on ''find'' but I''m looking for something that goes into more
detail on how to perform queries across tables.
Abstracted from my current application, this is an example:
* person has_many sites
* site has_one room
*
2006 Feb 21
6
Select articles from group with id ''1'' and id ''2''
I have to tables: "articles" and "groups". Between I have
article_groups as a jointable. Now I want to select every article who
is a member of group with id ''1'' and id ''2''. Whats best way to get
that?
Extract from schemas:
CREATE TABLE articles (
id int auto_increment,
ingress text NOT NULL,
story_text longtext,
constraint fk_items_users
2006 Apr 07
2
Re: Re: page.replace_html "#{var_containing_id_name}", :partial
> you mean like this?
>
> def do_some_ajax_thing
> <at> element_id = "content_div"
> end
>
> do_some_ajax_thing.rjs
>
> page.replace_html <at> element_id, :partial => "edit"
>
> remember, the view templates have access to the attributes defined
> in the controller
Actually, its more like this: I have a list page. Each row
2006 Jan 03
5
Pagination Question
Hi -
I''ve just started working with Rails, having come from a Cold Fusion
background. I''m curious how best to deal with a huge result set. For
example, I''m building an app that contains users. I''ve used
scaffolding to setup my initial pages for CRUD operations on users.
All that is great. The problem is, I''m going to end up with 1000+
users in
2006 Jan 03
2
Scaffolding - changing number of records per page
People,
This is probably simple but I couldn''t find where to change the default
10 records per page for scaffolding . .
Thanks,
Phil.
--
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:(0)411-185-652
Fax: +61:(0)2-8221-9599
E-mail: phil@pricom.com.au
2006 Apr 18
3
Join Queries? - find() or find_by_sql()
Hi All,
Is there a way to do join queries with find() or is it best to use
find_by_sql() instead?
I''m looking to do something like:
SELECT winery_name, wine_name FROM winery, wine
WHERE wine.winery_id = winery.winery_id
AND winery.winery_name LIKE ''Borg%'';
Thanks!
: )
Jason
2006 Apr 07
2
Re: page.replace_html "#{var_containing_id_name}", :partial
Jeff Coleman <progressions@...> writes:
>
> Jason Tuttle wrote:
> > The subject line says it all. -- Is there a way to do something
like:
> >
> > page.replace_html "#{var_containing_id_name}", :partial => ''edit''
> >
> > That line of code does not work, but I would like to pass the
name of
> > a variable to
2006 Apr 07
2
page.replace_html "#{var_containing_id_name}", :partial => ''edit''
The subject line says it all. -- Is there a way to do something like:
page.replace_html "#{var_containing_id_name}", :partial => ''edit''
That line of code does not work, but I would like to pass the name of
a variable to page.replace_html. This variable would contain the id
of the div I want to update.
Anyone know if/how I could do that?
Thanks!
: )
Jason
2006 Aug 04
8
I need an idea !
Hello here, I need to find an idea to solve a problem
I manage Events which are of kind :arrival or :departure
At first the two kind of events was unrelated but my client want to see
the :departure belonging to the :arrival and vice versa.
I''m searching for a solution to implement this ''link''. I''ve thought
about an integer column containing an uniq id for
2006 Jul 29
3
Engines question
I would like to get at all models in a rails application to be able to
add a field to every one of them as part of a migration. Something
like the following:
Appmodels.each { |x| add_column x.table_name.to_s, :foo, :text }
I understand I can get the table name using
ActiveRecord::Base#table_name, but how do I get all the models into an
array that I can use in the above manner?
--
Cheers,
Hasan
2006 Jan 18
2
Migration?
I just installed ruby, lighttpd, and mysql from darwinports on me
laptop in lieu of the Apple version of ruby. Now when I fire up my
rails application, it''s not running lighttpd anymore -- it''s running
webrick. It also exits immediately. MySQL is running, the database
and tables are restored from the backup. What step am I missing?
Thanks for the help!
Cheers,
Hasan
2006 Aug 13
3
escape block using red cloth
Hi all,
Is it possible to configure red cloth to escape a block such as:
------------------------------------------------------------------
Hello, _this_ works *beautifull*
[code lang="ruby"]
def foo
bar
end
[/code]
------------------------------------------------------------------
The text in the [code] block should not be parsed by Red Cloth''s to_html
method.
I cannot
2006 Jan 02
5
How to use MySQL sum() to get total of column?
Easy one: Let''s say I have a table called ''employees'' with a column
called salaries, how can I add Employee.salaries_total to the model?
Thanks!
--
Posted via http://www.ruby-forum.com/.
2006 Feb 01
2
Uninitialized constant ApplicationController?
Hello list,
I''m trying to start my Rails server after doing a long complex switch
from Postgres to MySQL, and I''m getting the following error:
=> Booting WEBrick...
/usr/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/active_support/dependencies.rb:200:in
`const_missing'': uninitialized constant ApplicationController
(NameError)
from
2005 Dec 14
3
Geocode for Ruby
Hey,
Does anybody know of a good Geocode library for Ruby, similar to Perl''s
Geocode::Postal, that i could use in my rail app? I need to do some "within
5 miles" calculations of zipcodes and i dont have a nice ruby (or gem)
utility to do it.
any help would be appreciated.
thanks
adam
_______________________________________________
Rails mailing list
2006 Aug 05
4
file_column just will not work...
Hello,
I have been trying for some time to get a file to upload using the
file_column plugin.
My code is here: http://pastie.caboo.se/7304
But my code is not the issue. I cannot even pass the unit test that
come with the file_column plugin.
If I run ruby file_column_test.rb i get:
1) Error:
test_store_dir_callback(FileColumnTest):
TypeError: can''t convert Fixnum into String
2006 Aug 04
3
forms and relationships
i''m still pretty new to rails, and while i''ve been able to hack my way
into having it do what i want so far, i''m not happy with the way my code
looks. on top of that, i''m sure that what i''m doing prlly isn''t the most
efficient either.
one of my biggest problems is probably to do with using relationships
and forms together. i''ve
2006 Jan 10
1
Ferret -- Search Partial?
I''d like to implement the search capabilities of Ferret and am
looking for sample code to see how it''s done. I''m thinking my
controller creates the index when "Search" is clicked and a partial
is rendered. What is this partial supposed to look like? Is it built
in to rails/Ferret? Thanks for the help!
Cheers,
Hasan Diwan <hasan.diwan@gmail.com>
2006 Aug 01
2
Active Merchant or Payment module?
Which do you guys prefer for credit card processing?
Both look like they get the job done. -- Is there any consensus on which
one is better? Are there other credit card processing solutions I''m not
aware of? Any thoughts or suggestions would be most welcome.
Thanks!
: )
Jason
--
Posted via http://www.ruby-forum.com/.