RE: a newserver would be better than this mailing list

2002-07-30 Thread Tim Ward
That URL doesn't seem to me to be saying anything about a news server. If we are supposed to follow one of the links on that page perhaps you could give us a clue as to which one please? Tim Ward Brett Ward Limited - www.brettward.co.uk -Original Message- From: Simon Green [mailto

RE: RE: SELECT performance

2002-07-12 Thread Tim Ward
Tim Ward Brett Ward Limited - www.brettward.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 July 2002 11:17 To: Tim Ward Subject: Re: RE: SELECT performance Your message cannot be posted because it appears to be either spam or simply

RE: Some easy questins .. [i hope]

2002-07-11 Thread Tim Ward
- MyODBC works fine for me, then link the tables you want. Tim Ward Brett Ward Limited - www.brettward.co.uk --- On August 5th ip.access will be moving to: CPC1 Telephone: +44 (0) 1223 219000 Capital Park Fax

RE: blob versus file

2002-07-03 Thread Tim Ward
. The database won hands down on all counts. Tim Ward Brett Ward Limited - www.brettward.co.uk --- On August 5th ip.access will be moving to: CPC1 Telephone: +44 (0) 1223 219000 Capital Park Fax: +44 (0) 1223 219099

RE: blob versus file

2002-07-02 Thread Tim Ward
a million files in the same directory, 'cos I've tried it, but it's not terribly practical as some operations start taking tens of minutes instead of tens of milliseconds. Really one of the reasons for using a DBMS is to handle all this storage management crap for you, no? Tim Ward Brett Ward Limited

RE: Speed issue

2002-07-01 Thread Tim Ward
From: Simon Ashby [mailto:[EMAIL PROTECTED]] Sent: 01 July 2002 10:58 To: MYSQL Subject: Speed issue Any pointers on how to get rid of the disk churning and get a normal response in this set up would be much appreciated. Turn off OBDC logging. Tim Ward Brett Ward Limited

RE: ODBC Questions

2002-05-27 Thread Tim Ward
the different way I had to do things I was used to doing in Access. Tim Ward Brett Ward Limited - www.brettward.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: in and not in

2002-05-22 Thread Tim Ward
SELECT table1.col_name FROM table1 LEFT JOIN tablse2 ON table1.col_name = tablse2.col_nmae WHERE tablse2.col_nmae IS NOT NULL ? Tim Ward Brett Ward Limited - www.brettward.co.uk -Original Message- From: Inbal Ovadia [mailto:[EMAIL PROTECTED]] Sent: 22 May 2002 16:00 To: [EMAIL

RE: sql question

2002-05-14 Thread Tim Ward
? With proper indexes and so on the whole thing should surely be under a second? (Of course if you've got more than four or five levels it could be your organisation structure that's broken:-).) Tim Ward Brett Ward Limited - www.brettward.co.uk -Original Message- From: Hathaway, Scott L [mailto

RE: Good color coded SQL editor for MySQL?

2002-04-30 Thread Tim Ward
From: Jerry [mailto:[EMAIL PROTECTED]] Does anyone know of a good color coded SQL editor for MySQL that works in Windows? Visual Studio? You get keywords in blue, anyway. Tim Ward Brett Ward Limited - www.brettward.co.uk

RE: Invalid Argument ??? Not sure how to debug this

2002-03-18 Thread Tim Ward
Try ... If ($result = ...) { ... ... } else echo(mysql_error()); I always do querying like this anyway (without the error echo in live stuff obviously) Tim Ward Internet Chess www.chessish.com http://www.chessish.com -- From: Daniel Negron/KBE [SMTP

RE: [PHP] Re: A stupid question...

2002-03-11 Thread Tim Ward
records but don't sort past the first letter then SELECT ..., LEFT(lastname, 1) AS lastname_first ... ORDER BY lastname_first or you might even be able to do ... ORDER BY LEFT(lastname, 1) you'll have to experiment with that one. Tim Ward Internet chess www.chessish.com http://www.chessish.com