From: Roger (COM Chantry CA) Urscheler
Date: September 28 2006 4:21pm
Subject: Mysql++ list post
List-Archive: http://lists.mysql.com/plusplus/5981
Message-Id: <1652EBA28502ED4393B9BC9B8A4B60130113BAA6@mism121a.toronto.chantrynetworks.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C6E31A.361762F8"

------_=_NextPart_001_01C6E31A.361762F8
Content-Type: text/plain

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


------_=_NextPart_001_01C6E31A.361762F8--