[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:255921
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
