I believe there is a datecompare cf tag that may help also
Sincerely,
Shane Witbeck
Webmaster
[EMAIL PROTECTED]
www.digitalsanctum.com
-----Original Message-----
From: Marco Gil [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 27, 2000 12:29 AM
To: ColdFusion
Subject: Listing Items That Expire Today? Help!
I'm trying to get it so that one of my web pages lists only items that are
going to expire today. Here's my query:
<CFQUERY NAME="Expiring" DATASOURCE="#application.ds#">
SELECT EntryDate, Items.RetailerID, Items.CategoryID, Items.ListingID,
CouponText, CouponURL, CouponDesc, Retailer, RetailerIMG, Category, Listing,
Items.ItemID
FROM Items, Retailers, Categories, Listings, Coupons
WHERE Coupons.ExpiryDate <= #CreateODBCDateTime(Now())# AND
Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1 AND
Items.RetailerID = Retailers.RetailerID AND
Items.CategoryID = Categories.CategoryID AND
Items.ListingID = Listings.ListingID
ORDER BY Retailer
</CFQUERY>
However, it lists every single item. Can anyone please help me with this?
Thanks so much!
Marco
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
