Any help guys? i don't understand what is happening but am getting a record
short that is the query seems to be working only that its not returning the
record of the datePaid, only records less than the datepaid. here is my query
again
<cfquery name="qBal" datasource="bond100">
SELECT ID_biodata, quater, datePaid, amountPaid, manFees
FROM collections
WHERE datePaid <= <cfqueryparam cfsqltype="cf_sql_date"
value="#arguments.datePaid#">
AND ID_biodata = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#arguments.ID_biodata#">
AND quater = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#arguments.quater#">
ORDER BY datePaid
</cfquery>
<cfquery dbtype="query" name="results">
SELECT SUM(CAST(amountPaid as INTEGER) + CAST(manFees as INTEGER)) AS
totalPaid
FROM qBal
</cfquery>
