What version of ColdFusion are you using, Doug? On 10/8/06, Doug Brown <[EMAIL PROTECTED]> wrote: > > 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" <[email protected]> > 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:255923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
