Quoting Ross Clutterbuck <[EMAIL PROTECTED]>:
The main operation I need a hand with is deleting units from the units
table. Obviously, if I delete a unit I want it removed from all
qualifications that use it automatically. With that in mind, again, is
a comma-delimited list of unit IDs in qualifications records the best
way, and is there any easy way of updating all qualifications records
at once if I delete a unit record.
I missed this bit out!
If you use the previous email as a guide, when you delete a
unit/module, all you need to do is run a "delete from modules where
moduleid = $x" and "delete from course_modules where moduleid = $x"
and the chances of it being listed for any course have been removed.
Cheers,
M.
--
Matthew Macdonald-Wallace
[EMAIL PROTECTED]
http://www.truthisfreedom.org.uk/
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
