Hi..
Real quick question..
Why does this give an error?
<CFQUERY name="GetExpiredBids" datasource="#DSN#">
Select close_date,bidid From tblBids
WHERE datediff('d',close_date, now()) > = 5
</CFQUERY>
The error is
Error resolving parameter CLOSE_DATE
Yes, Close_Date is within tblBids.
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
