:Putting
: links for each
: function under the categories might help with that. The
: links could go to
: the specific place on the big page (there would be no
: need for a separate
: page for each one). Of course, this is probably OT at this point.
Try http://www.
uncan
---
Duncan Salada
Titan Systems Corporation
301-925-3222 x375
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 9:45 AM
To: mysql users
Cc: Salada, Duncan; 'Rob'
Subject: Re: formatti
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Duncan & Rob, et al --
...and then Salada, Duncan said...
%
% Why 2 CONCATs? Why not simply:
%
% mysql -Be "select CONCAT(host,'.',domain) from easyadmin.vsites where
% adminuser="davidtg"
Hey, cool! That's *exactly* what I needed. Works perfect
From: Rob [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 8:20 AM
To: David T-G; mysql users
Subject: RE: formatting query output
Try
select CONCAT(CONCAT(LTRIM(RTRIM(host)),'.'), LTRIM(RTRIM(domain))) from ...
The LTRIM and RTRIM will get rid of any white spaces you may hav
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 3:06 PM
To: mysql users
Subject: formatting
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have a system info table:
bash-2.05a$ echo 'describe easyadmin.vsites;' | mysql ...
Field TypeNullKey Default Extra
sitenum int(11) PRI NULLauto_increment
host varchar(250)
