re[2]: Could we make this a web discussion forum?

2003-03-31 Thread Richard Morton
I am with you jeremy... Web based discussion boards are horrible. I never remember to go daily. I can write my responses to this on the train and send them when I get to my desk. Rich On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote: I really hate mailing lists - they

re: ERWin 4.1 not applicable for MySQL

2003-03-31 Thread Richard Morton
You could try: Datanamic's Dezign - www.datanamic.com or you could use MS Visio Professional HTH Richard Dear MySQL users developers and programmers, ERWin 4.1 not applicable for MySQL I'd like to model some logical databases in Entity Relationships diagrams From here I

MySQL v SAB DB

2003-02-25 Thread Richard Morton
Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than

Highly Reliable MySQL Installations

2003-02-20 Thread Richard Morton
Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the other server for all

re[2]: InterBase vs. Mysql

2003-02-18 Thread Richard Morton
Actually, I think you are not quite right in all respects. but feel free to correct me if I am wrong Somebody, or some entity still needs to hold the copyright of a product. How that entity chooses to sell or distribute that product is up to them. In this case MySQL AB is the copyright

re[2]: Can MySQL work on Windows XP?

2003-02-10 Thread Richard Morton
-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com

Off Topic - PHP/Mysql Development company

2003-02-03 Thread Richard Morton
Hi, I am sorry this is a bit off topic. I am looking for recommendations of MySQL / PHP / HTML / Javascript development companies. Companies which you have previously worked and found to be very good at what they do and good value. They need to be English speaking. I am especially looking

Off Topic - PHP/Mysql Development company

2003-02-03 Thread Richard Morton
Hi, I am sorry this is a bit off topic. I am looking for recommendations of MySQL / PHP / HTML / Javascript development companies. Companies which you have previously worked and found to be very good at what they do and good value. They need to be English speaking. I am especially looking

re[2]: Backups mechanism

2003-01-07 Thread Richard Morton
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL

re[2]: MySql 4.1 Sub Selects

2002-11-11 Thread Richard Morton
PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com - This email, its

re: Info on 4.0.x release date

2002-08-27 Thread Richard Morton
Hi Will, As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta as we speak and is likely to be released in the next month. V4.1 will most likely be released Early Sept in Src form and in Binaries two months later. 4.0.x branch will be allowed to stabalise from

Versions

2002-08-21 Thread Richard Morton
Hi, I am looking for dates for new versions and the bug fixes they will have contained. I am using 4.0.1... however I have a handles leak. I have been told by another source that this will be resolved in 4.1 My question is, using MyODBC(3.51.03)... Is this a problem with 3.x stable releases

re[2]: MySQL Errors -

2002-07-23 Thread Richard Morton
What instances can cause a Table to crash? Is this caused by a bug in itself, a power failure, or something else? Richard William_dw, Tuesday, July 23, 2002, 10:34:16 AM, you wrote: WS I'm hoping someone can give me a pointer as to what's going wrong that's WS crashing our

re: newbie SOUNDEX question

2002-06-07 Thread Richard Morton
Hi, You are doing everything fine, however, soundex is not a perfect system and does not always work. It does simplify some types of queries. But in the vast majority of cases I don't think that it is worth the bother. It doesn't actually link all the same sounding sirnames, if there were a

FWD: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

2002-05-17 Thread Richard Morton
please see below -- Forwarded Message -- FROM: euro.support [EMAIL PROTECTED] TO: Richard Morton [EMAIL PROTECTED] DATE: Fri, 17 May 2002 10:26:06 +0200 RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 Hi Richard, I have received

RE: backslash about MySQL++/Microsoft Visual C++ 6.0 (2)

2002-05-02 Thread Richard Morton
Hi, I have had a similar problem... This also occurs with ' or . in any field you expect this character use: REPLACE(c:\mysql\test,\,/) Returns the string str with all all occurrences of the string from_str replaced by the string to_str: mysql select REPLACE('www.mysql.com', 'w', 'Ww');

RE: Update

2002-04-25 Thread Richard Morton
, Duncan; 'Richard Morton'; MySQL List Subject: Re: Update I'd have to guess that MySQL is interpreting the set clause this way: Set events_ID = ( 512 AND ( term = 'changed' )) That is, a logical AND, so a zero result makes sense. Still, it seems a bit odd. - Original Message - From

Update

2002-04-23 Thread Richard Morton
mysql update contact set alternatepreference='C' and AltContactID='1' where con tactid=2; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 any ideas why the UPDATE did not perform an update? Thanks Rich

versions

2002-04-22 Thread Richard Morton
Hi, Has anybody heard how the next version of either MyODBC (3.51) or MySQL (4.0.1) are coming along and when they will be declared stable? I started developing with 4.0.1, and although I have had no failures to date, I was said that they would be declared stable in dec/jan. it is now several

RE: Mysqld as service

2002-04-10 Thread Richard Morton
mysqld --remove use mysqld --help for more info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:41 PM To: MySQL-Mailingliste Subject: Mysqld as service Hi How can i deinstall the mysqld as a service? Thx for help mfg

RE: NT service problem

2002-03-18 Thread Richard Morton
I am using MySQL4.02 as a service on W2Kpro. You need to install the service before you can start it. mysqld-nt --install Then try the net start, possibly after a reboot. Rich -Original Message- From: Tommy Claasens / QDC KZN [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002

4.0.1-max-nt - quick note

2002-02-12 Thread Richard Morton
I have installed the above as a service. The service seems to start ok, but trying to run mysql console fails. I am running this on Win2k Pro. I have now reverted to MySQL4.0.1-NT running as a service and this works fine. Just a warning. Richard

RE: Selecting the row with largest number in a column

2002-01-27 Thread Richard Morton
January 2002 20:04 To: DL Neil; Richard Morton; [EMAIL PROTECTED] Subject: RE: Selecting the row with largest number in a column The fastest way I found would be: SELECT MAX(age) FROM contacts good luck bb -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Saturday

Selecting the row with largest number in a column

2002-01-25 Thread Richard Morton
Hello, I have a simple query, and a problem countless people must have had, I just cannot work it out at the moment, I am new to MySQL; I hope you can help. My current statement looking at the manual. SELECT * FROM contacts WHERE age=MAX(age); I started with: mysql select * from contacts

RE: Nested Queries.

2001-12-21 Thread Richard Morton
Hi, In alot of cases you can use the following query structure (extract from MySQL 4.0.0alpha manual)to negotiate the need for Sub-Selects. I hope this helps. -Rich 1.4.4.1 Sub-selects MySQL currently only supports sub selects of the form INSERT ... SELECT ... and REPLACE ... SELECT