Re: Install MySQL on Windows XP
Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what to do,Can someone help me? My english is not well.Do i speak clearly? thanks reply No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.5/1619 - Release Date: 2008/08/18 05:39 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Granting users localhost access
Hi there Pam, This should do the trick: update mysql.user set host = 'locahost' where user = 'username' Regards, Schalk Pam Astor wrote: How do I grant users, who already have a password, localhost access? I don’t want to change their passwords at this time. _ Use video conversation to talk face-to-face with Windows Live Messenger. http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008 No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.2/1386 - Release Date: 2008/04/18 05:24 PM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Granting users localhost access
Hi Pam, If you want to grant a specific user remote access i.e. from a shell or from an application that resides on a different machine then you will have to adjust the query I sent earlier: update mysql.user set host = '%' where user = 'AUserName'; FLUSH PRIVILEGES; The above two queries will firstly update the mysql database to allow the user specified to connect from any host and will then force the MySQL server to reload the privileges, essentially meaning refresh so that the next time this user tries to connect to the database MySQL will be aware of the change made to the users account and allow them to access the database from a remote host. If you do not want to allow access from any host but for example localhost and a specific IP then you can do: update mysql.user set host = 'localhost, 69.89.2.231' where user = 'AUserName'; FLUSH PRIVILEGES; Regards, Schalk Sebastian Mendel wrote: Pam Astor schrieb: OK I tried running:update mysql.user set host = 'locahost' where user = 'AUserName'; Substituting AUserName for a real username,got the return:Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0and I tried to login and could not log in remotely via a remote terminal, which is what I am trying to do. FLUSH PRIVILEGES; I am sorry I do not understand you. If I Flush privilages, will this flush all privilages for the user? If so, I can not do that because these users are already used to log into an existing database via a functioning php script and have privilages to edit tables, etc, and this database is already attached to a live shopping cart php script which is fully functional. When you say flush privilages, don't I also need to include the username for the privilages I am flusing in the command syntax? FLUSH PRIVILEGES tell MySQL to reload the privilege tables, the one you edited above, but if you say this user is used to connect from a PHP script too, not only from shell, than you have removed thier privileges to do so, with replacing the HOST field as Schalk suggested Do you mean to directly edit the table? How would I do that? if you do not even know how to edit a table in MySQL you really should not mess with mysql tables or privileges at all! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tips for migration
HI All, Can anyone give me some pointers, help, point me to articles with regards to transfering a MSSQL database to MySQL? Thanks! Schalk Neethling -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating Password Username with phpMyAdmin
Hi David, Actually the way to do this would be as follows: When you have created a new database, click on the SQL tab and the use the following to create the user and password: GRANT ALL PRIVILEGES ON databasename.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hit the submit button and you are set. HTH Schalk Neethling AlliedBridge (code.google.com/p/alliedbridge) David Blomstrom wrote: Sorry for the beginner's question, but I'm confused. I can easily create passwords and usernames for my online databases by going into my C-Panel and clicking a MySQL icon. It fetches a page that allows me to easily create and delete databases, add and change passwords, etc. But I can't remember how I created my password and username for the database on my PC. I'm now trying to duplicate that database on a MacBook Pro running MySQL 5 and the current version of phpMyAdmin. But I'm not sure about creating a password and username with phpMyAdmin. Suppose I have a database named World, and I want to give it the password Global and the username Citizen. I created the database, then clicked the Privileges tab, which took me to the page User 'root'@'localhost' : Edit PrivilegesAm I correct in ignoring everything (Global Privileges, Database-Specific Privileges, etc.) except the section?... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query returns to many results
Peter Brawley wrote: /Now this query is run over two tables and the ab_members table contains around 302 rows. Around 1/3 of these will be where cup=kids. However, when this query is run it returns 20,700 results / That's because your ... FROM ab_leader_board ablb, ab_members abm calls for a cross join--it asks for every logically possible combination of ablb and abm rows. From the rest of your query, it appears you need something like ... FROM ab_leader_board ablb INNER JOIN ab_members abm USING (name_of_joining_column) Also, do you really mean to sum all those ablb column values after having already called for all ablb column values with ablb.* ? PB - Schalk wrote: Greetings All, Please have a look at the following query: SELECT abm.mem_number, abm.first_name, abm.last_name, abm.area_represented, abm.age, abm.sex, abm.cup, ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly + ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc + ablb.lmgp + ablb.saff + ablb.gmgp + ablb.safy + ablb.mmw + ablb.lc + ablb.mmc + ablb.nwmc + ablb.ncc + ablb.samp + ablb.gsc + ablb.wcmgp + ablb.sapm + ablb.kznc + ablb.npc + ablb.smc + ablb.ecc + ablb.mgp + ablb.samo + ablb.cofc + ablb.cs + ablb.ncmgp + ablb.fsc + ablb.ggp + ablb.tmc + ablb.gc + ablb.yotm AS total_points FROM ab_leader_board ablb, ab_members abm WHERE abm.sex = 'Female' AND abm.cup = 'kids' ORDER BY total_points DESC Now this query is run over two tables and the ab_members table contains around 302 rows. Around 1/3 of these will be where cup=kids. However, when this query is run it returns 20,700 results :0 Any idea why this is? Also, any help or pointers as to how I can optimize this query will be much appreciated. Thank you! Greetings Peter, Well, with regards to the ablb.*, I need access to each individual column as well as to the sum of all of those columns, so I think I need to do both, or don't I? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query returns to many results
Greetings All, Please have a look at the following query: SELECT abm.mem_number, abm.first_name, abm.last_name, abm.area_represented, abm.age, abm.sex, abm.cup, ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly + ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc + ablb.lmgp + ablb.saff + ablb.gmgp + ablb.safy + ablb.mmw + ablb.lc + ablb.mmc + ablb.nwmc + ablb.ncc + ablb.samp + ablb.gsc + ablb.wcmgp + ablb.sapm + ablb.kznc + ablb.npc + ablb.smc + ablb.ecc + ablb.mgp + ablb.samo + ablb.cofc + ablb.cs + ablb.ncmgp + ablb.fsc + ablb.ggp + ablb.tmc + ablb.gc + ablb.yotm AS total_points FROM ab_leader_board ablb, ab_members abm WHERE abm.sex = 'Female' AND abm.cup = 'kids' ORDER BY total_points DESC Now this query is run over two tables and the ab_members table contains around 302 rows. Around 1/3 of these will be where cup=kids. However, when this query is run it returns 20,700 results :0 Any idea why this is? Also, any help or pointers as to how I can optimize this query will be much appreciated. Thank you! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query returns to many results
George Law wrote: Schalk , You need to specify the unifying column between your ablb and abm tables. ie - in your where, and ablb.id=abm.id Once you get this so it returns expected results, you can run the query, prefaced with explain and it will give you an idea on the way mysql is running the query. This has helped me determine some additional indexes that greatly speed up my queries. -- George - Original Message - From: Schalk [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, February 23, 2006 6:59 AM Subject: Query returns to many results Greetings All, Please have a look at the following query: SELECT abm.mem_number, abm.first_name, abm.last_name, abm.area_represented, abm.age, abm.sex, abm.cup, ablb.*, ablb.jp + ablb.rc + ablb.fsmgp + ablb.gmc + ablb.saly + ablb.nwgp + ablb.ecgp + ablb.sams + ablb.wcc + ablb.kzngp + ablb.emc + ablb.lmgp + ablb.saff + ablb.gmgp + ablb.safy + ablb.mmw + ablb.lc + ablb.mmc + ablb.nwmc + ablb.ncc + ablb.samp + ablb.gsc + ablb.wcmgp + ablb.sapm + ablb.kznc + ablb.npc + ablb.smc + ablb.ecc + ablb.mgp + ablb.samo + ablb.cofc + ablb.cs + ablb.ncmgp + ablb.fsc + ablb.ggp + ablb.tmc + ablb.gc + ablb.yotm AS total_points FROM ab_leader_board ablb, ab_members abm WHERE abm.sex = 'Female' AND abm.cup = 'kids' ORDER BY total_points DESC Now this query is run over two tables and the ab_members table contains around 302 rows. Around 1/3 of these will be where cup=kids. However, when this query is run it returns 20,700 results :0 Any idea why this is? Also, any help or pointers as to how I can optimize this query will be much appreciated. Thank you! Thanks George! It works perfectly. Now to optimize this bugger. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1064 error
Thanks Roger, I wondered whether it was the spaces that caused the problem. Roger Baklund wrote: Schalk Neethling wrote: Greetings What might be causing the 1064 error in the following query? SELECT mem_number, first_name, last_name, area_represented, joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge + Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga GP + Glam Slam Model Challenge + Model Man Woman + SA Look of the Year + SA Face of the Year + KZN Classic + Eastern Cape GP + Western Cape Classic + Free State Classic + North West GP + Northern Province Classic + SA Model Open + Cover Search + Champion of Champions + Northern Cape Classic + Goldfields Model GP + Limpopo Classic + SA Model Portfolio + Top Model Challenge + Gauteng Model Classic + Year of the Model AS total_points FROM modelcup.ab_leader_board All of the rows does exist in the table and all row names are correct. row names ? You seem to be selecting data from a table called ab_leader_board in a database called modelcup. Some of the fields/columns in the table seems to be mem_number, first_name, last_name, area_represented and joining_points, but then it gets unclear... what does the next part mean: joining_points + E-Model Challenge + MySQL will interpret this as ...joining_points pluss E minus Model AS Challenge pluss... and give a syntax error. (The 'AS' alias keyword is optional.) You can't use + for concatination, if that is what you are trying to do. If you have columns named E-Model Challenge, SA Pro Model and so on, and you want to add the numeric value of all these columns into one column named total_points, you must use `backticks` because of the spaces in the names: joining_points + `E-Model Challenge` + `SA Pro Model` + ... URL: http://dev.mysql.com/doc/mysql/en/legal-names.html -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1064 error
Greetings What might be causing the 1064 error in the following query? SELECT mem_number, first_name, last_name, area_represented, joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge + Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpumalanga GP + Glam Slam Model Challenge + Model Man Woman + SA Look of the Year + SA Face of the Year + KZN Classic + Eastern Cape GP + Western Cape Classic + Free State Classic + North West GP + Northern Province Classic + SA Model Open + Cover Search + Champion of Champions + Northern Cape Classic + Goldfields Model GP + Limpopo Classic + SA Model Portfolio + Top Model Challenge + Gauteng Model Classic + Year of the Model AS total_points FROM modelcup.ab_leader_board All of the rows does exist in the table and all row names are correct. TYIA! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error, please contact the sender and please delete all traces of this material from all devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Last Update
Greetings Is there a way to get the last update date for an entire table not just a single row? More specifically, is there a way to do this with Java? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SCO issue
You guys should subscribe to the Planet MySQL RSS feed. The entire issue was cleared up there by a member of the MySQL AB staff. http://www.planetmysql.org/ Rich Allen wrote: On Sep 5, 2005, at 3:10 PM, Daniel Kasak wrote: This is the part that gets me: As part of the agreement, the companies will work together on a range of joint marketing, sales, training, business development and support programs that will benefit customers throughout the Americas, Europe and Asia. I suppose it depends on how much 'joint work' is actually involved. As another poster pointed out, this could just be SCO up to their usual spin. But I agree with you - if this is some kind of special business relationship, then Postgres is looking all the more inviting. MySQL AB doing work for SCO is one thing, partnership would be much a different matter which would then lead me to agree that looking at Pg would be a good idea. Hopefully MySQL AB will make all this clear one way or the other ... Rich Allen Dare Do -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error, please contact the sender and please delete all traces of this material from all devices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Creating virtual rows question
Greetings Please have a look at the following code and let me know if this is the correct way to create a virtual row. Also, after having run this MySQL returns the error that the row total_points, does not exist. Where am I going wrong? Thank you in advance. SELECT mem_number, first_name, last_name, joining_points + emc + sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc + ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points FROM modelcup.ab_leader_board WHERE sex = 'Female' AND cup = 'kids' AND current_pos 0 ORDER BY total_points ASC -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating virtual rows question
Jacques Thank you, I will give it a try. Jacques Marneweck wrote: Schalk Neethling wrote: Greetings Please have a look at the following code and let me know if this is the correct way to create a virtual row. Also, after having run this MySQL returns the error that the row total_points, does not exist. Where am I going wrong? Thank you in advance. SELECT mem_number, first_name, last_name, joining_points + emc + sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc + ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points FROM modelcup.ab_leader_board WHERE sex = 'Female' AND cup = 'kids' AND current_pos 0 ORDER BY total_points ASC Hi Schalk, Try: SELECT mem_number, first_name, last_name, joining_points + emc + sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc + ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf AS total_points FROM modelcup.ab_leader_board WHERE sex = 'Female' AND cup = 'kids' AND current_pos 0 ORDER BY total_points ASC Regards --jm -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Creating virtual rows question
Thanks to all! The AS keyword did the trick. Philippe Poelvoorde wrote: SELECT mem_number, first_name, last_name, joining_points + emc + sapmc + starmc + ecmclassic + sams + kznmgp + mmgp + gsmc + mmw + saloty + safoty + kznmc + ecmgp + wcmc + fsmc + nwmgp + npmc + samo + csf + coc + ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf = total_points ncmc + gmgp + nlmc + samp + tmc + gmc + yotmf AS total_points Use the AS keyword, not the equal/assignment operator FROM modelcup.ab_leader_board WHERE sex = 'Female' AND cup = 'kids' AND current_pos 0 ORDER BY total_points ASC -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not sure about Error
Greetings! I run the following query against MySQL: SELECT demographic_no, first_name, last_name, chart_no, sex, year_of_birth, month_of_birth, date_of_birth, family_doctor, roster_status, patient_status, phone FROM demographic JOIN demographic ON allergies.demographic_no = demographic.demographic_no JOIN drugs ON demographic.demographic_no = drugs.demographic_no JOIN dxresearch ON drugs.demographic_no = dxresearch.demographic_no JOIN echart ON dxresearch.demographic_no = echart.demographicNo JOIN ichppccode ON dxresearch.dxresearch_no = ichppccode.ichppccode WHERE allergies.description LIKE '%CARBACHOL%' MySQL returns the following error: Not unique table/alias: 'demographic' What exactly is meant by this statement :( Thank you in advance! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Not sure about Error
Dan Yes, I completely overlooked that. Thanks! Dan Nelson wrote: In the last episode (Jun 23), Schalk Neethling said: I run the following query against MySQL: SELECT demographic_no, first_name, last_name, chart_no, sex, year_of_birth, month_of_birth, date_of_birth, family_doctor, roster_status, patient_status, phone FROM demographic JOIN demographic ON allergies.demographic_no = demographic.demographic_no Do you maybe mean FROM allergies JOIN demographic ON allergies.demographic_no ... ? JOIN drugs ON demographic.demographic_no = drugs.demographic_no JOIN dxresearch ON drugs.demographic_no = dxresearch.demographic_no JOIN echart ON dxresearch.demographic_no = echart.demographicNo JOIN ichppccode ON dxresearch.dxresearch_no = ichppccode.ichppccode WHERE allergies.description LIKE '%CARBACHOL%' -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Can you sign -in as root user i.e. Administrator? Using: mysql -u username -p password? Dwayne Hottinger wrote: That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper [EMAIL PROTECTED]: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
order by confusion
Greetings! This might be a stupid question but here goes: I have a table that contains a column entitled current_pos. I want to search this table and then order the results by current_pos. Now I am running the following SQL query on the table: SELECT * FROM ab_leader_board WHERE sex = 'F' and cup = 'Kids' ORDER BY current_pos DESC; After running this the results are returned but as 2, 1, 0 , 0 etc. If I use: SELECT * FROM ab_leader_board WHERE sex = 'F' and cup = 'Kids' ORDER BY current_pos ASC; It returns 0, 1, 2 How do I go about getting this to return the results as 1,2,3,4 etc.? Any help would be appreciated. Thank you! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: joining six tables by mutual column
Mathias/Everyone on the list I am running the following query against the database: SELECT demographic.demographic_no, demographic.first_name, demographic.last_name, demographic.chart_no, demographic.sex, demographic.year_of_birth, demographic.month_of_birth, demographic.date_of_birth, demographic.family_doctor, demographic.roster_status, demographic.patient_status, demographic.phone FROM allergies, demographic, drugs, echart, dxresearch, ichppccode WHERE demographic.demographic_no = '1' AND demographic.last_name LIKE 'TES' AND allergies.demographic_no = demographic.demographic_no AND demographic.demographic_no = drugs.demographic_no AND drugs.demographic_no = dxresearch.demographic_no AND dxresearch.demographic_no = echart.demographicNo AND allergies.demographic_no = echart.demographicNo AND dxresearch.dxresearch_code = ichppccode.ichppccode Is the string at the end from, 'AND allergies.demographic_no = demographic.demographic_no...', the correct way to create the JOIN I require by demographic_no on five of the tables and then a JOIN of the dxresearch and ichppccode tables by dxresearch_code and ichppccode respectively? Any help or pointers would be much appreciated. Thank you! mathias fatene wrote: Hi, Select * from table1 T1, table2 T2, table3 T3, table4 T4, table5 T5, table6 T6 Where T1.col=T2.col and T2.col=T3.col and T3.col=T4.col and T4.col=T5.col and T5.col=T6.col and T1.col=T6.col [and col='val'] Doesn't this work ? Have you an example ? Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Schalk Neethling [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 00:52 To: mysql@lists.mysql.com Subject: joining six tables by mutual column Greetings everyone. Hope someone can give me some pointers here. I have six tables in the database and I need to JOIN them on a row that appears in all of the tables. How do I do this? I have so far done the normal 'cross-join' saying SELECT * FROM table1, table2, table3, table4, table5, table6 WHERE something = something; I have also added STRAIGHT_JOIN to force the order but, how do I JOIN six tables to/by one column? I have done some google searches as well as looked at MySQL 2nd edition by Paul DuBois, sorry if I missed something here Paul, and so far I have not found an answer. Any help or pointers will be appreciated. Thank you. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
joining six tables by mutual column
Greetings everyone. Hope someone can give me some pointers here. I have six tables in the database and I need to JOIN them on a row that appears in all of the tables. How do I do this? I have so far done the normal 'cross-join' saying SELECT * FROM table1, table2, table3, table4, table5, table6 WHERE something = something; I have also added STRAIGHT_JOIN to force the order but, how do I JOIN six tables to/by one column? I have done some google searches as well as looked at MySQL 2nd edition by Paul DuBois, sorry if I missed something here Paul, and so far I have not found an answer. Any help or pointers will be appreciated. Thank you. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Windows Installer
Greetings Has anyone been able to successfully upgrade from 4.0.22, for example, to 4.1.9 using the windows installer and server instance wizard? For me, every time the wizard hits the 'Apply security settings' part of the config it freezes. I am now trying a manual install but wanted to know whether there is a known bug. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Database Designer
Have you tried DBDesigner4 by fabForce? Andreas Ahlenstorf wrote: Hi! I'm looking for a good graphical database designer, supporting the latest stable release of MySQL, MyISAM and InnoDB tables and foreign keys. So far there are a lot of products. But I need one, which runs on Windows and MacOS X. Do you have a good suggestion? Regards, Andreas -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem connecting to MySQL server
Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24:28 InnoDB: Started MySQL: ready for connections. Version: '4.0.22-debug' socket: '' port: 3306 Source distribution When I stop the server using NET STOP MySQL the server stops without any problems and the following is written to the log: 041108 14:25:43 MySQL: Normal shutdown 041108 14:25:43 InnoDB: Starting shutdown... 041108 14:25:46 InnoDB: Shutdown completed 041108 14:25:46 MySQL: Shutdown Complete Now, here is the problem. When I have started the MySQL server and it is running I then go to c:\mysql\bin\ and execute the command: mysql The following message is then returned: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Any ideas why this is happening? Any help on pointers to where I may find more answers will be appreciated. Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade - Downgrade problems
Since installing the latest 4.1 version of MySQL I have not been able to run phpMyAdmin. I have since gathered that the current version of phpMyAdmin is not compatible. I therefore ran Add/Remove programs on Windows and installed 4.0.22 but nothing is working correctly, the server starts as a service using NET START MySQL but, phpMyAdmin continues to say: | #2003 - The server is not responding|. First, how can I detect, on localhost, which port MySQL is using? And second, how can I ensure that everything related to MySQL, including the app itself, is removed before making a clean install of MySQL 4.0.22. I would appreciate any help or pointers. I am on WindowsXP as the development machine. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpMyAdmin and MySQL 4.1
Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. I get this whether I am using cconfig, http or cookie based authentication. Any ideas why this is happening? Is there a config setting in MySQL I should set to support the protocol? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Design.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: LIKE question
If I search a field for 'doone' and one of the fields contains 'Lorna Doone' what is the best comparator to use as LIKE is skipping this one and I imagine '=' will do the same? -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cannot be null problem
When sending form data via a form I get the following SQL error ERROR:-- SQLException - Message: The url cannot be null SQLState: 08001 ErrorCode :0 What does this mean? The row url, is not set to be not null. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Query problem
Hey there I have the following table structure: CREATE TABLE documents ( id int(11) NOT NULL auto_increment, user varchar(50) NOT NULL default '', olduser varchar(50) NOT NULL default '', username varchar(100) NOT NULL default '', uploaddate timestamp(14) NOT NULL, docdate varchar(100) NOT NULL default '', docno varchar(255) NOT NULL default '', title varchar(150) NOT NULL default '', summary varchar(255) NOT NULL default '', content text NOT NULL, doctype varchar(80) NOT NULL default '', docuri varchar(255) NOT NULL default '', vjudge varchar(100) NOT NULL default '', vexpert varchar(100) NOT NULL default '', vspeciality varchar(150) NOT NULL default '', didiversity varchar(100) NOT NULL default '', dicity varchar(80) NOT NULL default '', didiversitybar varchar(80) NOT NULL default '', dilawfirm varchar(200) NOT NULL default '', jstate varchar(100) NOT NULL default '', jdistrict varchar(100) NOT NULL default '', jappellate varchar(100) NOT NULL default '', keywords varchar(255) NOT NULL default '', PRIMARY KEY (id), FULLTEXT KEY content (content) ) TYPE=MyISAM; I run the following type of query against it: SELECT * FROM documents WHERE MATCH (content) AGAINST ('demyer Padgham robinson') AND doctype = 'Motion' AND jstate = 'California: State Court' OR jdistrict = 'Circuit Court: Federal, California' For some reason even when doctype is not equal to Motion it still returns these documents. Can someone please let me know where I am going wrong? The most important thing about the query is that first only documents that match the doctype should be returned so I suppose before even bothering to check the rest of the query only those documents should be found. How do I go about ensuring that only documents that matches the doctype is returned and no other documents. Thanks for any help on this. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL book
Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois http://www.informit.com/safari/author_bio.asp?ISBN=0735709211 - New Riders Publishing -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FULLTEXT search
When doing a MATCH() AGAINST() search. Does a result get returned only when all of the words in the AGAINST() 'tag' matches a document or if any words match. Basically is this an AND or OR type of result that is returned? Thanks! -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL and Point of Sale
Hey there! Does anyone know where I can find information regarding connecting MySQL and a Point of Sale device? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.
RE: Query on large text field
Hey there everyone I have tried a couple of things but would like to know what suggestions people on the list may have. What would be the best query term or string is to use when searching a field, using a keyword(s), in the database that contains a large amount of text, for example an article's content? Any pointers and suggestions will be welcomed. Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.
RE: No suitable driver
Try changing driver to Driver Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.
FULLTEXT
I am using the following command on MySQL 4.0.18 ALTER TABLE tablename MODIFY columnname FULLTEXT; I keep getting an error regarding FULLTEXT. Where am I going wrong? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.
RE: Query problem
Why is the following query retuning doctypes different to what is asked for? SELECT * FROM documents WHERE jstate = 'California: State Court' AND doctype = 'Verdict' Any ideas? As far as I can see it should only return a document if it is a Verdict and matches the state California: State Court. Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question
Why is the following query retuning doctype's different to what is asked for? SELECT * FROM documents WHERE jstate = 'California: State Court' AND doctype = 'Verdict' Any ideas? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.
RE: MySQL statements
Hi there Can someone tell me what process MySQL follows to process SQL statements/queries? Is it top down or bottom up? Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.com This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you.