------_=_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--

Urscheler, Roger (COM Chantry CA) wrote:
Search the list: there is a thread about this giving a patch, and an
explanation of why you won't see it in the main distribution anytime
soon. (Short version: you have to break the ABI to fix this, so we
can't do it until v3.0, and there are many other things I want to get to
before that.)

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

You can use COALESCE( age, 0 ) as age to have it return 0 instead of
null in the query. =20

Since SQLSS doesn't support NULL, I never return them, even on outer
joins. Our DBA says NULLable columns are slower anyway in MySQL.=20

-----Original Message-----
From: Warren Young [mailto:mysqlpp (AT) etr-usa (DOT) com]=20
Sent: Thursday, September 28, 2006 3:09 PM
To: MySQL++ Mailing List
Subject: Re: Mysql++ list post

Urscheler, Roger (COM Chantry CA) wrote:
Search the list: there is a thread about this giving a patch, and an
explanation of why you won't see it in the main distribution anytime
soon. (Short version: you have to break the ABI to fix this, so we
can't do it until v3.0, and there are many other things I want to get to
before that.)

--=20
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsu...neva (DOT) com




--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw