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]
