From: Warren Young
Date: March 15 2007 12:15am
Subject: Re: does 'AS' work?
List-Archive: http://lists.mysql.com/plusplus/6429
Message-Id: <45F8901E.40501@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Denis 'SciFi' Simonet wrote:
> 
> What's the problem now? 

Plainly MySQL doesn't return "showid" as one of the field names in its 
reply to your query.  MySQL++ just uses the field name list MySQL gives 
us, nothing more.

> Has MySQL++ got problems with AS? 

Not per se, no.  MySQL++ does not try to guess what form you want the 
data in, it just provides an interface to the data forms MySQL actually 
does return.

> Should it at all work like this?

I don't see how that would be practical.  If MySQL doesn't return it in 
the form you need, MySQL++ would have to have a SQL query parser in it 
to guess how to reformat the data to get the behavior you want.  That's 
not going to happen.

> And if no, what field name does it take for the att for example?

To debug this sort of problem, you need to dig into the underlying MySQL 
data structures.  Either build a MySQL C API test program to see what 
data you actually get back and then figure out how to recast that in 
MySQL++ terms, or use a debugger to step through the data structures 
MySQL++ builds from the query reply and refine your data access code 
accordingly.