CFMX 7.02
----- Original Message ----- From: "Dina Hess" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Sunday, October 08, 2006 10:22 AM Subject: Re: database design revisted > 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:255925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
