Displaying 2 results from an estimated 2 matches for "trandat".
Did you mean:
trandt
2009 Jul 28
1
complex find
...9;
and
class Debtortranstaxes < ActiveRecord::Base
belongs_to :debtortrans, :foreign_key => ''debtortransid''
Now I want to find Debtortrans records but only those with specific
Debtortranstaxes values...
@debtor = Debtortrans.find(:all,
:conditions => ["trandate > ? and trandate < ? AND
debtortranstaxes.taxauthid = ?", @per1, @per.lastdate_in_period, "24"],
:include => ''debtortranstaxes'',
:select => ''debtorno, trandate, transno, ovamount'')
but this gives me an error...
NameError: undefin...
2009 Jul 29
9
partials...
...ic...
<% # City of Scottsdale
@taxauthids = [ "32", "40" ]
@report_title = "Scottsdale Sales Tax Detail Report for the Period
Ending " + @period.lastdate_in_period.strftime("%m-%d-%Y")
@taxes = Debtortranstaxes.find(:all, :conditions => ["trandate
BETWEEN :begin AND :end AND taxauthid IN (:ids)", {:begin => @per1, :end
=> @per2, :ids => @taxauthids}],
:joins => ''LEFT JOIN debtortrans ON debtortrans.id=debtortransid'',
:include => ''debtortrans'',
:select => ''deb...