I have a table which holds information for a auction site and was wonder how to handle a couple of things. Sorry for the long drawn out question, but I am just a little baffeled on what the correct way of doing this may be. Hopefully I will not have too many questions after this, but the database is getting a little hairy.
[auction expire] Say a auction is listed for 7 days, and ends at a specified time. How would I go about ending the auction? I have the following fields in the table. Would I need to run a scheduled task every so often and check the ending time and mark the auction as being over? Or should I have the code that checks the auction status in application.cfm and run it everytime someone visits the site? listed_time ending_time [payment_method] When placing an item up for auction, the seller can choose what payment types they prefer (Paypal, certified check, personal check, money order) should I store this info in it's own table referencing the user_id of the users table as key? I looked at the way EBAY was handling it, and they are having the seller decide payment options with each auction. Would it be better to do that only when a user signs up as a seller, and just put their preferred payment options in their preferences, instead of making them choose every time they place an auction? IE: [user_preferences] user_id payement_preference shipto_preference etc etc etc Thanks for all the help folks Doug (CFNoob) ;-/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
