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
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
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
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:
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
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
#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
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
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
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
-
> 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
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
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
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
14 matches
Mail list logo