logo       
Google Custom Search
    AddThis Social Bookmark Button

Mysql++ list post: msg#00065

Subject: Mysql++ list post
Hi,
Can you please post this question:

I have a table 'Person' with column 'age' that allows NULL. How can I use
SSQLS to read that table and return '0' for age if age is 'NULL'? 

What type do I need to define in the SSQLS macro to have an integer
nullable. Do I define the SSQLS like this:

    typedef mysqlpp::Null<int, mysqlpp::NullisZero> MyIntNull;
    sql_create_c_order_2(Person, 1, 2,
        string,        name,     0,
        MyIntNull,   age,   1)

When defining age with type int and the age in the database is 'NULL', then
I get a runtime error in Query::storein 


Thanks,
Roger


Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>