On 2/7/08, Ali <[EMAIL PROTECTED]> wrote: > > Hi: > Sorry if it's a very basic question. I wonder how I can set a query record > to be displayed for a period of time? For example an advertisement stays > visible for 10 day in the site and inactivates automaticly afterward? I > thought maybe I use a "bit" entry in my database and somehow write a code > in > CF that changes it from 1/YES to 0/No when 10 days later come but how I > really have no idea. Please help me. > Plus I wonder what is the name of such site/applications which show such > advertisement? Are they Auction sites or they have another name? > Thanks > Ali
You would be better off relying on two fields. first Date field is the Start Date of the Add, the secend field also being a date field with the end date. then structure your SQL statement to select the Ad where the date is EQ or GT the start date and LT or EQ to end date. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
