Hello.
Please can you send the complete query and table definition, because
I was unable to reproduce this weird behavior. What version of MySQL do
you use? What client do you use to execute queries? We can see below,
that there is no period before total_bandwidth:
mysql select (SELECT SUM(feed_usage.bandwidth) AS bandwidth FROM
feed_usage WHERE customerID IN (57) AND
DATE_FORMAT(feed_usage.stats_date,'%m%Y')=DATE_FORMAT(NOW(),'%m%Y') )AS
total_bandwidth ;
+-+
| total_bandwidth |
+-+
|NULL |
+-+
Dan Rossi [EMAIL PROTECTED] wrote:
Hi there somehow my AS field alias of a sub query is adding a dot at
the start therefore I cant use it in my application.
(SELECT SUM(feed_usage.bandwidth) AS bandwidth FROM feed_usage WHERE
customerID IN (57) AND
DATE_FORMAT(feed_usage.stats_date,'%m%Y')=DATE_FORMAT(NOW(),'%m%Y') )
AS total_bandwidth ,
comes up as .total_bandwidth in my resultset any ideas ?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]