Dina,
Thanks for the reply. As for the first question, [auction_end] I understand how to set-up the table as far as that goes, but am not sure if I should simply run the code for checking the expire date/time in the application.cfm or another way. What would you do? ----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Sunday, October 08, 2006 9:34 AM Subject: Re: database design revisted > [auction expire] > > auction_start_date > days_listed > auction_end_date > > Maybe I'm missing something here, but it appears that when an auction is > initially configured, you can set the auction_end_date by > adding auction_start_date and days_listed. From there, all you need to do is > compare auction_end_date to the current date. > > [payment_method] > > I would set up master tables for payments options and shipping options for > use with separate preference tables for payment and shipping: > > (assume SQL Server database...untested) > > -- master table for payment options > create table payment_options ( > pmt_option_id int identity not null primary key, > pmt_option_desc varchar (50) > ); > > -- master table for shipping options > create table shipping_options ( > shp_option_id int identity not null primary key, > shp_option_desc varchar (50) > ); > > create table seller_pmt_preferences ( > user_id int not null > references user (user_id), > pmt_option_id int not null > references payment_options (pmt_option_id), > constraint pk_seller_pmt_pref > primary key clustered (user_id, pmt_option_id) > ); > > create table seller_shp_preferences ( > user_id int not null > references user (user_id), > shp_option_id int not null > references shipping_options (shp_option_id), > constraint pk_seller_shp_pref > primary key clustered (user_id, shp_option_id) > ); > > Then use the following query syntax to pull the seller options for display: > > <!--- get seller payment options ---> > select p.pmt_option_id, p.pmt_option_desc > from payment_options p inner join seller_pmt_preferences s > on s.pmt_option_id = p.pmt_option_id > where s.user_id = <cfqueryparam cfsqltype="cf_sql_integer" > value="#form.user_id#"> > > Dina > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
