Re: How to retrieve ENUM values by INDEX

From: Zeddy Chirombe <zeddy.chirombe(at)gmail.com>
Date: Thu Jul 19 2007 - 11:39:40 EDT

> I doubt there's a mysql++-specific solution for this (although others
>know far more than me), because mysql++ isn't given any information
>about the mappings between ENUM names and numbers.

Andrew,                 that is correct according to Warren, that mysql++

has not insight regarding the translations whatsoever. However, I was hoping that Warren, since he is the authority here, could liaise with MySQL fellows to expose this info, so from MySQL++ perspective, we could then choose to make a call like raw_enum(int), inplace for raw_data(int), or vice-vesa.

--Thanks for helping out,
--Zeddy

On 7/18/07, Andrew Sayers <andrew-mysqlpp@pileofstuff.org> wrote:
>
> From http://dev.mysql.com/doc/refman/4.1/en/enum.html:
>
> If you retrieve an ENUM value in a numeric context, the column
> value's index is returned. For example, you can retrieve numeric
> values from an ENUM column like this:
>
> mysql> SELECT enum_col+0 FROM tbl_name;
>
> So the easiest solution is to change your query to
> "SELECT StudentID, StudentClub+0 FROM students" (note: the trailing ";"
> isn't necessary either).
>
> I doubt there's a mysql++-specific solution for this (although others
> know far more than me), because mysql++ isn't given any information
> about the mappings between ENUM names and numbers.
>
> - Andrew
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
> http://lists.mysql.com/plusplus?unsub=zeddy.chirombe@gmail.com
>
>
Received on Thu Jul 19 11:40:47 2007