: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
Try
select CONCAT(CONCAT(LTRIM(RTRIM(host)),'.'), LTRIM(RTRIM(domain))) from ...
The LTRIM and RTRIM will get rid of any white spaces you may have. If there
aren't any
then simply
select CONCAT(CONCAT(host,'.'), domain) from ...
---
Rob
**
Rob Cherry
mailto:[EMAIL PROT
