create virtual field variable and then use
I wish to create a virtual field that can be used in another location. My existing query is below......
=======BEGIN=======
<cfquery name = "student_loan" datasource = "#application.datasource#">
select loan.*, loan.DELQ, bank.bank, bank.bphone, bank.website, coll.sch, coll.SCHNAME, coll.SCHADDR, coll.SCHCSZ, coll.SCHPH, coll.FAA , coll.FAAEMAIL
from (loanstat inner join (coll inner join (bank right join loan on bank.banknum = loan.banknum) on coll.schnum = loan.schnum) on loanstat.statnum = loan.statnum) inner join guar on loan.guarnum = guar.guarnum
where loan.ssn = '#emailSSN#'
order by loannum desc
</cfquery>
======END=========
....I want to create a variable called (DELQDAYS) which takes today's dayte now() and subtracts a date field [loan].[lastpymt].
what is the syntax I need to add inside the above query?
Subject
Written By
Posted
create virtual field variable and then use
November 27, 2013 11:44PM
November 28, 2013 06:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.