Displaying 20 results from an estimated 700 matches similar to: "find by sql"
2008 Jun 14
0
does BackgrounDRB not "know" the rails environment it is running within/in parallel with?]
Hi,
it probably is a noob question but I''m confused by this error message:
active_support/dependencies.rb:478:in `const_missing'': uninitialized
constant Invoice::ApplicationController
Situation:
I have an InvoicesController with a create method that in turn calls
upon a MiddleMan.worker(:billing_worker), which in turn finds an Invoice
and calls upon @invoice.print_invoice
2005 Dec 16
4
Adding extra value to an object
Hello friends ,
I have a clear method here ::
def create
@invoiceitems = Invoiceitems.new(params[:invoiceitems])
@invoiceitems["invoice_id"] = params[:id]
if @invoiceitems.save
flash[:notice] = ''Invoiceitems was successfully created.''
redirect_to :action => ''new'',:id => params[:id]
else
render :action =>
2006 Jun 06
3
Invoice and invoice_lines
Hello People,
I have a possibly very lame question.
I am fairly new to RoR, and I want to make sure I do it "right".
I have a model called Invoice, and one called InvoiceLines. Usual story:
the table "invoice" has a 1:n relationship with "invoice_lines", which
includes invoice_id.
Now... the application will have a "new order" button, which will allow
2009 Jul 16
12
Find_all_by and find(:all) to only select certain values for a selection box
So....let''s have a look if I understood the issue:
-Find_all_by is actually the same like Find(:all), however Find_all_by
is much shorter and less complicated than the syntax of Find(:all)
-So in my CONTROLLER it says @files = find(:all) however I don''t want
to see all files displayed in my selection box, because I only want to
see the foles whose mandant_id is the same like
2005 Dec 16
3
Not able to put into a object variable
hello friends ,
I was trying to select all the invoice items from the table invoiceitems
with a condition.But I am getting a NULL array .Please help me in fixing
this ::
@oldinvoiceitems = Invoiceitems.find(:all, :conditions =>
[''invoice_id = :invoiceid'', { :invoiceid => ''params[:id]'' } ] )
Thanx and regards,
Naroor Rathish,
2006 Jul 05
2
get value from array.
hi,
Im running the following sql statment which returns 1 result.
pSql = "SELECT sum(amount)
FROM payments
WHERE expected_pay_date LIKE ''"+pWholeDate+"%''
AND invoice_id IS null "
aResult = Payment.find_by_sql(pSql)
how can I get the result of this?
(when doing @aResult.inspect it
2005 Dec 16
2
Is this possible?
Hello Friends,
def new
@invoiceitems = Invoiceitems.new
@oldinvoiceitems = Invoiceitems.find(:all, :conditions
=>[''invoice_id = :invoiceid'', { :invoiceid => params[:id] } ]
end
Error is being shown in the line number with ''end''.
This is for initialising a new invoiceItems object and also finding and
storing all the invoice items for a
2008 May 25
2
record will absolutely not save! so weird, please help.
I have a weird problem going on. All of sudden, records for a certain
model will not save with #save Please take a look at this:
>> p = Payment.new(:payment_reason_id => 1, :payment_method_id => 1, :date => Date.today, :amount => ''5.00'', :payable => Student.find(608))
=> #<Payment id: nil, school_id: nil, payment_reason_id: 1,
payment_method_id: 1,
2006 Nov 07
2
undefined local variable or method `invoices' for Provider:Class
I''m pretty new to Rails, and I think my app has progressed quicker than
my knowledge of Rails/Ruby has ...
I have the following models:
[ -- Begin -- ]
class Provider < ActiveRecord::Base
has_many :invoices
has_one :user
def self.get_invoices
invoices.find(:all)
end
end
class User < ActiveRecord::Base
belongs_to :Provider
belongs_to :Consumer
def
2005 Dec 30
3
Select SUM(?) Query
When using PHP, I was able to
enter a query against my list of invoices such as :
Select SUM(amount) from invoices where project="123"
This would give me the total amount of all invoices for project 123.
In rails, how would I do this? I tried using "find_by_sql," but
couldn''t figure out how to extract the results out of this. Thanks!
2003 Feb 24
5
XP irratic delay in opening files....
Hi all
I am fairly new to samba and XP. I have a client who we set up a samba
server for, they are complaining about documents taking about 30 secs
-2-3mins to open but only sometimes (it can be very frequent). I have
seen this and captured a piece of the log file I wonder if any one can
make any sense of it...
I have been looking on the net and trying various things all day but to
no avail...
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 31
1
beta2: strange assert
Hi,
My setup: Solaris 9, mbox format, mailboxes NFS mounted from
another S9 system, imap. I got the following assert yesterday:
Jan 30 19:57:15 emerald dovecot: [ID 107833 mail.error] imap(user):
file index-mail-headers.c: line 258 (index_mail_parse_header): assertion
failed: (part != NULL)
Jan 30 19:57:16 emerald dovecot: [ID 107833 mail.error] imap(user):
file index-mail-headers.c: line
2005 Dec 30
2
Beauty in Page Layout
Hi Railers,
I have a model with many associations (20+). I would like to display the
relative associations using AJAX, allowing the user to display the
association his/her is interesting at a particular time. Is there any
existing applications or sample code that I can look at to accomplish the
task?
Present I have one long page, with master (displaying current record
information) and many
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
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 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
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
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
2008 Oct 29
4
Current Open Source Billing Package
After spending a couple hours scanning for an open source (non-
commercial) billing package yesterday I am underwhelmed. Almost all of
the packages listed on the WIKI appear to be defunct, for several
years now. I will be happy to get a login and edit them out if that is
the proper method to do so.
My requirements are very minimal and at this point unless I have
missed something will