Get ready for BLACK FRIDAY shopping starting in

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
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>

Reply to this topic