On Wed, 2006-10-11 at 16:03 -0700, ADAM CZECH wrote: > Does anyone know why a mysql alias would not display in the return a > result? > > When I try to access say the first name with it's alias f_name, it is > blank? , but it works for its column name first_name? This becomes > more of a problem with subselects because how does one alias it?
> Servlet sql: > > sql = "SELECT " + > "u.id as user_id, " + > "u.first_name as fname, " + You're aliasing it as fname, not f_name. -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
