Return a single column

[Craig Snyder]

I am using the SSQLS macros and was wondering how to return a single column?
All of the examples show how to put a result into a row but not how to
handle a singe column.  I attempted to define a macro aql_create_1, but that
failed.

 

Code -

sql_create_4(User,

            1, 4,

            int, UID,

            string, GUID,

            string, AID,

            mysqlpp::DateTime, Date)

 

Query query = m_con->query();

query << "select * from User where GUID = " << quote << GUID;

 

Result res = query.store();

User row = res[0];

return row.UID;

 

I would prefer to do is this -

Query query = m_con->query();

query << "select UID from User where GUID = " << quote << GUID;

 

Result res = query.store();

 

then return just the column value

 

Thanks in advance for your help,

Craig