On 4/20/2015 6:33 PM, stinas...@yahoo.com [flexcoders] wrote:
Below is my code. is there something am doing wrong? Please help.
well first off you don't need the query-of-query, you can get what you want in
one query.
WHERE datePaid = cfqueryparam cfsqltype=cf_sql_timestamp
when i try to hard code the date i get the correct result somewhat only that it
misses a record. here is what i mean by hard coding
cfquery name=qBal datasource=bond100
SELECT ID_biodata, quater, datePaid, amountPaid, manFees
FROM collections
WHERE datePaid = DateValue('4/20/2015 0:00:00
Hello Guys, i am using a cfquery and am trying to return results based on date.
the idea is to return entries that are less than or equal to date but am not
getting any results but when i change to greater than or equal to i get the all
results in databse which is wrong.
Below is my code.
3 matches
Mail list logo