[wdvltalk] Re: swf file
Now you're trying to frighten me :-o. It is supposed to be a shockwave file, but even though I have downloaded shockwave player 8something it refuses to play. (and yes my anti-virus is up-to-date and the sender is known to me) I can only think it might be that it won't work with IE 5.0? Should I update IE - or are there more hazards with the update? Joseph From: Brewnetty (AuntySpam) [EMAIL PROTECTED] viruses can be disguised as .swf files. I hope your anti-virus software is up to date - Original Message - From: Joseph Harris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:30 AM Subject: [wdvltalk] swf file Someone has sent me an .swf file.It wouldn't play. I have downloaded uninstall then flash player version 6 from Macromedia and followed all instructions. The file still won't play; I am asked for an association but neither flash nor macromedia appear to be in the list. Has anyone any advice? Joseph The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Hi Joseph, I can only think it might be that it won't work with IE 5.0? Have you tried selecting Internet Explorer in the Open With... dialog box? The Flash player doesn't show up as a separate application, it's a plug-in for IE. Cheers Jon The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Actually the flash player is a separate application as well as a plug-in. Installing Flash will give you all the necessary plug-ins/players you need. On the other hand, you could try embedding the swf file in an html page and see if it shows up. Paul -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:20 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Re: swf file Hi Joseph, I can only think it might be that it won't work with IE 5.0? Have you tried selecting Internet Explorer in the Open With... dialog box? The Flash player doesn't show up as a separate application, it's a plug-in for IE. Cheers Jon The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP
Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, grp_name CHAR(50) NOT NULL, grp_overtime_paid BOOL NOT NULL, PRIMARY KEY (grp_id), INDEX (grp_name)) TYPE=InnoDB COMMENT=Stores group names and their properties == The field employee_groups.grp_name is 'mapped' to employees.emp_group and the referential integrity is set all the associated fileds to NULL when the parent record is DLETED and to CASCADE when the parent record is UPDATED. Creating the tables is fine. Inserting data in the tables is fine too. But when I try to update a record in employee_groups, MySQL returns the following error mysql UPDATE employee_groups SET grp_name = FOO WHERE grp_id = 1; ERROR 1217: Cannot delete a parent row: a foreign key constraint fails Why is it telling me that I'm trying to delete the record when I'm only doing a simple update? Deleting the records is ok, MySQl sets the associated fields to NULL. But the update WON'T work... Any clue? Thanks in advance Paul The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Hi Paul, I can only think it might be that it won't work with IE 5.0? Have you tried selecting Internet Explorer in the Open With... dialog box? The Flash player doesn't show up as a separate application, it's a plug-in for IE. Actually the flash player is a separate application as well as a plug-in. Installing Flash will give you all the necessary plug-ins/ players you need. Oops, sorry for the misinformation! I don't have full Flash here, just the player, and it doesn't show up in Open With... That'll teach me to extrapolate from my situation to everyone else's :-) On the other hand, you could try embedding the swf file in an html page and see if it shows up. You could, although that's a lot more work than just opening it... Cheers Jon The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Do you think it is legal to send the flash player to somebody by email? It weighs only 800k Paul -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:40 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] Re: swf file Hi Paul, I can only think it might be that it won't work with IE 5.0? Have you tried selecting Internet Explorer in the Open With... dialog box? The Flash player doesn't show up as a separate application, it's a plug-in for IE. Actually the flash player is a separate application as well as a plug-in. Installing Flash will give you all the necessary plug-ins/ players you need. Oops, sorry for the misinformation! I don't have full Flash here, just the player, and it doesn't show up in Open With... That'll teach me to extrapolate from my situation to everyone else's :-) On the other hand, you could try embedding the swf file in an html page and see if it shows up. You could, although that's a lot more work than just opening it... Cheers Jon The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Joseph Harris wrote: I can only think it might be that it won't work with IE 5.0? Should I update IE - or are there more hazards with the update? Joseph Right off the bat you hazard getting a much better, more standards compliant browser. You also hazard having pages display better and having closer display properties between M$ and every other browser out there. Though, I would hazard a guess that this is not your problem with the .swf file. -Stephen The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP
Hi Paul, I hope I understand correctly (little sleep can make you see things)... In MSSQL when a record gets updated it deletes it first and then it inserts the new information. To us it looks like it just updated the information. So I assume it will happen the same in MySQL. The reason you cant update the record is becuase you mapped (setting up primary and secondary key contraints - employees.emp_group and employee_groups.grp_name). I suggest you rather set up your constraints using employees.emp_group (make it an INTEGER) and employee_groups.grp_id. That way if you want to update the group name you only have to do it in employee_groups.grp_name. While you are updating your employees table with the group information you can drop the constraints and then activating it again when you are finished. Im not quite sure what the MySQl commands for that will be. I hope this helps. Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 02:29 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, grp_name CHAR(50) NOT NULL, grp_overtime_paid BOOL NOT NULL, PRIMARY KEY (grp_id), INDEX (grp_name)) TYPE=InnoDB COMMENT=Stores group names and their properties == The field employee_groups.grp_name is 'mapped' to employees.emp_group and the referential integrity is set all the associated fileds to NULL when the parent record is DLETED and to CASCADE when the parent record is UPDATED. Creating the tables is fine. Inserting data in the tables is fine too. But when I try to update a record in employee_groups, MySQL returns the following error mysql UPDATE employee_groups SET grp_name = FOO WHERE grp_id = 1; ERROR 1217: Cannot delete a parent row: a foreign key constraint fails Why is it telling me that I'm trying to delete the record when I'm only doing a simple update? Deleting the records is ok, MySQl sets the associated fields to NULL. But the update WON'T work... Any clue? Thanks in advance Paul * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% ___ The views expressed in this email are, unless otherwise stated, those of the author and not those of the FirstRand Banking Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data
[wdvltalk] RE: [DTS] Access 97 to MSSQL 2000 headache
Forgot to mention...in the stored procedure you might want to wrap all the update/insert/delete code inside a transaction. That way if for some reason it fails, it will roll the SQL table back to the way it was before and all you'll need to clean up is the temp table. Tim ___ Tim Furry Web Developer Foulston Siefkin LLP The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP
Sonja, I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would have to make a UNION select on the 2 tables to get the associated employee_groups.grp_name since employees.emp_group only contains the ID of the group name. So only to avoid that, I would prefer to keep the actual pk/fk mapping. Your solution is somehow interesting since updating employee_groups.grp_name DOES NOT affect the employees table. What do you think is better? Keep the existing setup and bang my head against the wall to find out why it won't work or change to the one you proposed? Taking into consideration the issue I pointed out above (the UNION stuff). Thanks Paul -Original Message- From: Van Der Westhuizen, Sonja [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 5:35 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Hi Paul, I hope I understand correctly (little sleep can make you see things)... In MSSQL when a record gets updated it deletes it first and then it inserts the new information. To us it looks like it just updated the information. So I assume it will happen the same in MySQL. The reason you cant update the record is becuase you mapped (setting up primary and secondary key contraints - employees.emp_group and employee_groups.grp_name). I suggest you rather set up your constraints using employees.emp_group (make it an INTEGER) and employee_groups.grp_id. That way if you want to update the group name you only have to do it in employee_groups.grp_name. While you are updating your employees table with the group information you can drop the constraints and then activating it again when you are finished. Im not quite sure what the MySQl commands for that will be. I hope this helps. Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 02:29 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, grp_name CHAR(50) NOT NULL, grp_overtime_paid BOOL NOT NULL, PRIMARY KEY (grp_id), INDEX (grp_name)) TYPE=InnoDB COMMENT=Stores group names and their properties == The field employee_groups.grp_name is 'mapped' to employees.emp_group and the referential integrity is set all the associated fileds to NULL when the parent record is DLETED and to CASCADE when the parent record is UPDATED. Creating the tables is fine. Inserting data in the tables is fine too. But when I try to update a record in employee_groups, MySQL returns the following error mysql UPDATE employee_groups SET grp_name = FOO WHERE grp_id = 1; ERROR 1217: Cannot delete a parent row: a foreign key constraint fails Why is it telling me that I'm trying to delete the record when I'm only doing a simple update? Deleting the records is ok, MySQl sets the associated fields to NULL. But the update WON'T work... Any clue? Thanks in advance Paul * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To:
[wdvltalk] Re: swf file
Not trying to frighten, just trying to caution. I think we all know that headers can be forged by a virus. I would probably try creating a simple html page for it and open the page with your browser. AuntySpam (Norma) http://www.geocities.com/brewnetty/ http://coastline.cccd.edu/~spcprgms/about.htm http://brewnetty.0catch.com http://www.getrealresults.com Don't be afraid of living ~the alternative is too final. - Original Message - From: Joseph Harris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 3:24 AM Subject: [wdvltalk] Re: swf file Now you're trying to frighten me :-o. It is supposed to be a shockwave file, but even though I have downloaded shockwave player 8something it refuses to play. (and yes my anti-virus is up-to-date and the sender is known to me) I can only think it might be that it won't work with IE 5.0? Should I update IE - or are there more hazards with the update? Joseph From: Brewnetty (AuntySpam) [EMAIL PROTECTED] viruses can be disguised as .swf files. I hope your anti-virus software is up to date - Original Message - From: Joseph Harris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:30 AM Subject: [wdvltalk] swf file Someone has sent me an .swf file.It wouldn't play. I have downloaded uninstall then flash player version 6 from Macromedia and followed all instructions. The file still won't play; I am asked for an association but neither flash nor macromedia appear to be in the list. Has anyone any advice? Joseph . The WDVL Discussion List from WDVL.COM . To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] swf file
Joseph Do you know the person who sent you the .swf file? Why don't you have your anti virus program scan it? Go ahead and email it to my personal email address, and I'll take a look at it. Jan -- http://www.jdvisions.com Web Development and Design The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
Thanks to everybody who is offering advice on this. You have advanced my education about plug-ins and the files they may relate to. Jon, associating with IE proved the answer. Paul, I didn't test the embedding in an html page idea, but I'll keep that behind my ear should such a problem arise with another file. The file, I now find came from here http://members.aol.com/bushnbin2/blush.htm - funnyish, but the words are a little indistinct to my ear; Stephen, I did have 5.5 before I reinstalled and I do keep thinking about updating, but then there are those patches, too! Norma, You are right about caution; but I had already contacted the sender, so knew it was ok (or should be - and is). Jan, Thanks for your kind offer; but all is well. Joseph Joseph Harris Smile Poetry Weekly (fortnightly) www.smilepoetryweekly.com Batty Balls and other Wicket Wit www.ah-mah-son.com From: Jan Major [EMAIL PROTECTED] Joseph Do you know the person who sent you the .swf file? Why don't you have your anti virus program scan it? Go ahead and email it to my personal email address, and I'll take a look at it. Jan -- http://www.jdvisions.com Web Development and Design . The WDVL Discussion List from WDVL.COM . To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: swf file
The Riverdance swf at that URL is well worth the wait for it to load (not often you'll hear me say that about a swf). Thanks for this ,Joseph - Love Bin Laden's Muttley impersonation... Franni Thanks to everybody who is offering advice on this. You have advanced my education about plug-ins and the files they may relate to. Jon, associating with IE proved the answer. Paul, I didn't test the embedding in an html page idea, but I'll keep that behind my ear should such a problem arise with another file. The file, I now find came from here http://members.aol.com/bushnbin2/blush.htm - funnyish, but the words are a little indistinct to my ear; Stephen, I did have 5.5 before I reinstalled and I do keep thinking about updating, but then there are those patches, too! Norma, You are right about caution; but I had already contacted the sender, so knew it was ok (or should be - and is). Jan, Thanks for your kind offer; but all is well. Joseph Joseph Harris Smile Poetry Weekly (fortnightly) www.smilepoetryweekly.com Batty Balls and other Wicket Wit www.ah-mah-son.com The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [DTS] Access 97 to MSSQL 2000 headache
In a message dated 3/14/2003 11:06:58 AM Eastern Standard Time, [EMAIL PROTECTED] writes: %%email.unsub%% The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP
Hi Paul, You can't update or delete any information in a column if there is a pk/fk mapping. SQL needs to maintain the integrity of the information and this is one of the ways it does it. If you want to keep the group name in the employees table why do you have the employees group at all. You need to normalize your database as this is the way databases should be designed (meaning splitting the employee information and the employee group information with links to the id's). Therefore you need to set it up like the example I gave you. Why do you want to avoid a union select? If it is the same as MSSQL you would use a LEFT JOIN employees.emp_groupid ON employee_groups.grp_id to get your information (this basically says include all the records from employees to all the groups/id's that referenced in employee_groups) Just a note. I find this easier to work with. If you have employee_group.grp_id as the column name, use the same grp_id name in your employees table. Therefore if you go back at a later stage you know exactly where what links to. I hope this is clear Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 04:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Sonja, I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would have to make a UNION select on the 2 tables to get the associated employee_groups.grp_name since employees.emp_group only contains the ID of the group name. So only to avoid that, I would prefer to keep the actual pk/fk mapping. Your solution is somehow interesting since updating employee_groups.grp_name DOES NOT affect the employees table. What do you think is better? Keep the existing setup and bang my head against the wall to find out why it won't work or change to the one you proposed? Taking into consideration the issue I pointed out above (the UNION stuff). Thanks Paul -Original Message- From: Van Der Westhuizen, Sonja [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 5:35 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Hi Paul, I hope I understand correctly (little sleep can make you see things)... In MSSQL when a record gets updated it deletes it first and then it inserts the new information. To us it looks like it just updated the information. So I assume it will happen the same in MySQL. The reason you cant update the record is becuase you mapped (setting up primary and secondary key contraints - employees.emp_group and employee_groups.grp_name). I suggest you rather set up your constraints using employees.emp_group (make it an INTEGER) and employee_groups.grp_id. That way if you want to update the group name you only have to do it in employee_groups.grp_name. While you are updating your employees table with the group information you can drop the constraints and then activating it again when you are finished. Im not quite sure what the MySQl commands for that will be. I hope this helps. Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 02:29 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, grp_name CHAR(50) NOT NULL, grp_overtime_paid BOOL NOT NULL, PRIMARY KEY (grp_id), INDEX (grp_name)) TYPE=InnoDB COMMENT=Stores group names and their properties == The field employee_groups.grp_name is
[wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP
Hi Sonja, Thanks for the advice. I think I'll stick to it. Regards Paul -Original Message- From: Van Der Westhuizen, Sonja [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:39 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Hi Paul, You can't update or delete any information in a column if there is a pk/fk mapping. SQL needs to maintain the integrity of the information and this is one of the ways it does it. If you want to keep the group name in the employees table why do you have the employees group at all. You need to normalize your database as this is the way databases should be designed (meaning splitting the employee information and the employee group information with links to the id's). Therefore you need to set it up like the example I gave you. Why do you want to avoid a union select? If it is the same as MSSQL you would use a LEFT JOIN employees.emp_groupid ON employee_groups.grp_id to get your information (this basically says include all the records from employees to all the groups/id's that referenced in employee_groups) Just a note. I find this easier to work with. If you have employee_group.grp_id as the column name, use the same grp_id name in your employees table. Therefore if you go back at a later stage you know exactly where what links to. I hope this is clear Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 04:13 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Sonja, I thought about that one but the result will be that if I want to have, let's say, a list of employees and their associated groups, I would have to make a UNION select on the 2 tables to get the associated employee_groups.grp_name since employees.emp_group only contains the ID of the group name. So only to avoid that, I would prefer to keep the actual pk/fk mapping. Your solution is somehow interesting since updating employee_groups.grp_name DOES NOT affect the employees table. What do you think is better? Keep the existing setup and bang my head against the wall to find out why it won't work or change to the one you proposed? Taking into consideration the issue I pointed out above (the UNION stuff). Thanks Paul -Original Message- From: Van Der Westhuizen, Sonja [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 5:35 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Hi Paul, I hope I understand correctly (little sleep can make you see things)... In MSSQL when a record gets updated it deletes it first and then it inserts the new information. To us it looks like it just updated the information. So I assume it will happen the same in MySQL. The reason you cant update the record is becuase you mapped (setting up primary and secondary key contraints - employees.emp_group and employee_groups.grp_name). I suggest you rather set up your constraints using employees.emp_group (make it an INTEGER) and employee_groups.grp_id. That way if you want to update the group name you only have to do it in employee_groups.grp_name. While you are updating your employees table with the group information you can drop the constraints and then activating it again when you are finished. Im not quite sure what the MySQl commands for that will be. I hope this helps. Sonja -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 02:29 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [MySQL] InnoDB - Updating a parent table won't update the child table - HELP Me again, Anybody can help? Paul -Original Message- From: Paul Larue [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] [MySQL] InnoDB - Updating a parent table won't update the child table Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups (
