Thanks Matthews Yahoo's no longer letting me send via their SMTP servers so until recently I've not been able to actually communicate with the list - not that I've been able to help much recently anyway! I'm all fully moved to GMail now so that's one less thing to worry about.
Let me go over this so I know I've got it right in my head - you have a table detailing qualification data only, a table detailing course unit data only and then a third table that defines the lists of course units the qualifications have in them. Adding a course unit to a qualification would actually add a record to the third table, so even though the same course code may appear in a number of records, each record is only assigned to one qualification. Ah I get you - many-to-one and one-to-many relationships. Cool! Makes sense to me. I'll press on and get back to you - virtual beers on their way! MOU 2008/8/12 Matthew Macdonald-Wallace <[EMAIL PROTECTED]> > > 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. ____ � 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.
