Forums
This topic is locked
Disable / Enable Content
Posted 18 Jun 2002 13:09:34
1
has voted
18 Jun 2002 13:09:34 david bloomfield posted:
Hello I was wondering if anyone knows how to disable/enable content.
A customer has course details that are available while there are places on the course to be booked. When all the places are filled they want to disable these course details until it is due to run again.
Anyone have any ideas or can point me in the right direction?
thanks
david
Replies
Replied 18 Jun 2002 14:24:54
18 Jun 2002 14:24:54 Julio Taylor replied:
David, the best way to do it is to create a single binary (yes/no, 1,0 database field) which you can use as a flag to determine that content item's status. Later on you can filter your data checking for this flag, such as:
SELECT * FROM <table> WHERE flag_disable = 0
where 'flag_disable' is the new database field we have specified.
This will return all the recors which have *not* been disabled, let me know if you need help implementing this, i'll be glad to help you
-- Julio
SELECT * FROM <table> WHERE flag_disable = 0
where 'flag_disable' is the new database field we have specified.
This will return all the recors which have *not* been disabled, let me know if you need help implementing this, i'll be glad to help you
-- Julio
Replied 18 Jun 2002 15:05:42
18 Jun 2002 15:05:42 david bloomfield replied:
Thanks Ill post back on here if I have any problems <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>