Displaying 20 results from an estimated 5000 matches similar to: "Select SUM(?) Query"
2006 Feb 10
1
Eager loading issue
I have three tables, Invoices, Projects, and Managers.
Each manager has many projects. Each project has many invoices.
When displaying a list of the invoices, I am using:
Invoice.find(:all, :include => [:project])
Since the list shows information from the project table. (For
example, a table showing Invoice Date, Project Name). However, I''d
also like to show the manager name.
2006 Jan 03
4
Would someone like to tell me why this code will not solve my problem? (it''s short)
I am building an invoicing system but cannot use the auto_increment
field to determine the invoice number (because they are running 3
different companies off the one system. I need to find the last
invoice number from any given company and then add 1 to it to get the
next invoice number. BUT, there is a unique case on the very first
invoice produced because there is no earlier invoice
2006 May 31
1
find by sql
Hi
I have the following code, which makes use of an sql statment to get the
results required.
However this just doesnt seem right for rails, as ive managed to develop
the whole project without using any other pure sql.
Is there a cleaner way of doing this, but gaining the same results.
thanks
scott
#sql to find all invoices
pSql = "SELECT DISTINCT invoices.id,
2006 Jan 07
8
Using find_by_sql to get the sum of a column
Hello,
I was wondering if there was a method in Rails that returns the sum of a
column. For example, I have a column called ''score'' and writing a SQL
statement such a ''select sum(score) from table_name'' does return the sum
of the values in the column. In the past (not too long ago being a
newbie), I defined all sorts of methods only to discover that Rails
2006 Feb 11
6
Rails Edge, has_many :through in searches
I have two tables, a Projects table and a Clients table.
It''s basically a HABTM relationship, but I have additional project/
client-specific information in the join table. I''m trying to use the
new has_many :through method to join these. It works fine when
displaying records, but when I try to search, I''m having this problem:
When I used a HABTM model to search
2018 Apr 10
3
Invoice numbering for customers
Just wanted to ask a quick question here. I am running GNUC 2.6.12 and
when I create a invoice for a customer I have to enter an invoice
number. I was thinking perhaps there is setting somewhere that I missed
to get it to automatically fill in a invoice number? Id hate to have
invoices with the same invoice number since I have to manually type them
in right now.
Thank you,
jdegraw
2006 Jan 09
7
Large select list, speed issues
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">I have a piece of code in my page
to generate
2006 Jan 06
3
Error Handling
Hi,
I am doing a project on invoice. For that I have to use a page both for
crating new invoices and for updation of existing invoices. The problem
is that when an error occures, I can''t maintain the same page for error
correction. How can I redirect it from the controller ? Or can I display
ruby errors before submit of the page in ruby?
Thanks..
Sainaba.
--
Posted via
2008 Apr 04
5
First call to worker method doesn''t work
I have a worker as follows:
class SampleWorker < BackgrounDRb::MetaWorker
set_worker_name :sample_worker
def create(args = nil)
# this method is called, when worker is loaded for the first time
end
def my_method
# Deliver test e-mail message
Notifications.deliver_message(1, "DM")
end
end
I have a rails controller that calls the following code:
worker =
2010 Aug 02
5
What do you use for Invoicing?
Hi Everyone,
Sorry, if it's not directly related to Asterisk. Some of people on this list
might have PBX deployed for their clients. What software do you use to
invoice them so the invoice looks like a proper telecom invoice maybe?
Prefer:
-opensource with Windows binary available.
-able to create .pdf invoices rather than printable ones.
Thanks
-------------- next part --------------
An
2006 Feb 03
3
Breakpointer not working
When I try to run script/breakpointer, I get the following error:
/usr/local/lib/ruby/1.8/drb/drb.rb:837:in `getaddrinfo'': getnameinfo:
Non-recoverable failure in name resolution (SocketError)
It''s Rails 1.0 on OSX 10.4.4. Any suggestions?
2006 Jan 03
3
What am I doing wrong!!!
Hi:
@x = Invoice.find(:first)
if @x
do one thing
else
do another
end
This ought to work but does not. I think that @x is nil but if I
test for existance or @x != nil or @x.attribute != nil - my code does
not respond correctly. What is the value of @x if there are no
records yet in the invoices table?
Thanks in advance.
bruce
2006 May 19
7
AR transactions and isolation levels
I''m trying to create a sequence with no gaps in my db (contrived
example, but should work out the same as my real one), and believe
db-managed transactions are the way to go about this.
It''s my first real ''go'' at transactions, so I may be mistaken about
how things really work.
Anyway.. Consider this example code:
Class Invoice < ActiveRecord::Base
def
2006 Feb 25
5
MySQL client ran out of memory
I''m getting the following error unexpectedly for my rails app. I just
exported the databae from dreamhost and imported it on textdrive for
my rails app.
Mysql::Error: MySQL client ran out of memory: SELECT COUNT(*) FROM
comments WHERE (comments.listing_id = 2666)
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in
2006 Jan 09
3
Custom flash[:notice]
For the most part, my
flash[:notice] messages fall into one of two categories: either a
message stating that something happened successfully (which is colored
green), or messages showing errors (which I would like to be red).
Is it possible to set some sort of flag on these messages to choose
which color I want to show, or would I need to base it on CSS and set
the class in the text, i.e.
2006 Feb 28
5
Getting number of days in a month
In PHP, there was an argument you could pass to the Date function to
get the number of days in the current month:
echo date("t"); // Outputs "28" for February
I don''t see anything like this in Ruby/Rails. Right now, I''m using a
very ugly line to pull the last day of the month:
@number_of_days = (Date.strptime(Date.today.strftime("%Y-%m-01"))
2006 Jun 20
1
ActiveRecord saving madness?
Hello,
First of all, I love RoR. I am studying it, and I am finally "getting
there".
However, I do have a bit of a problem with ActiveRecord''s saving
behaviour.
Imagine to have Orders (id, name) {has_one:invoice} and Invoices (id,
order_id) {belongs_to :order} .
If you type:
invoice = Invoice.new(...whatever...)
an_order.invoice = invoice
if invoice fails to save, you
2006 Mar 30
4
ActionMailer e-mails getting tagged as junk in Outlook 2003
Whenever an email is sent via ActionMailer, and the recipient is using
Outlook 2003 (with SP2 installed), the e-mail is getting put in the junk
e-mail folder. Since Outlook doesn''t give a reason it was tagged as
junk, it''s hard to determine what to change.
I''ve compared the message headers of the "junk" mail and a valid email
sent through Outlook, and the
2006 Jan 21
4
Single quotes in parameters
I have a "search" action for my "projects" controller, which defines a
set of projects as follows
@projects = Project.find(:all, :include => [:user,:clients], :conditions
=> "name like ''%" + params[:query] + "%''",:order => ''number'')
This works fine, until I type an entry into my search box that has a
single
2008 Jan 06
8
n00b question/issue
i know this is n00b but i have searched and i can not figure it out.
i am running instantrails on windows. i downloaded ajax_scaffold and
installed using script/generate in a new rails project. after
configing the db i can the following error when trying to access
http://localhost:3001/invoices/list (invoices is the controller/table
i built ajax_scaffold on)...
NameError in