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 Gr

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 appe

RE: Some easy questins .. [i hope]

2002-07-11 Thread Tim Ward
ed an ODBC driver - 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 Par

RE: blob versus file

2002-07-03 Thread Tim Ward
Server database. 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:

RE: blob versus file

2002-07-02 Thread Tim Ward
rmance implications of lots of files in the same directory? - NT4 for example *will* handle half 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 r

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 War

RE: RE: MySQL does not always recognize \n as a field terminator while loading data from txt file

2002-06-21 Thread Tim Ward
#x27;t cope with both sorts of line endings really should consider a career change. Tim Ward Brett Ward Limited - www.brettward.co.uk sql,query --- This e-mail and the information it contains are confidential and may be privileged. If you have re

RE: ODBC Questions

2002-05-27 Thread Tim Ward
I had to read the MySQL documentation to find 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.my

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
data. How "slow" is slow? 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 -

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.bre

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

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

2002-03-11 Thread Tim Ward
uot; ... if you mean sort all 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 t

RE: [php_mysql] Creative solution with XML,PHP,MYSQL

2001-02-19 Thread Tim Ward
s you would html. Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html > -Original Message- > From: Tom Knight [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2