We have used it with date-time as well as optional, although there is a bug
using
odbc backend with boost::optional and std::string as the type. When it is
not a null,
it does not allocate the memory properly. We had to workaround this not
using
boost::optional with std::string but checking before we bind whether we
have a null
or not then choosing to bind.

There are several other fixes we made to odbc backend. We got it to work
with stored
procedures (which it says it does not support) but using the statement
class rather than
the procedure class.

I had to put in a fix to get it describe the columns from the result set
after SQLExecute()
as it often doesn't have them before.

I also put in a fix such that, once you have described the columns, you can
remove your
bound soci::row() and replace it with "into" data types instead (usually
vectors).

The issue is not that we don't know what types we are going to get, but we
want to verify
the column positions by string.

In addition moved find_column from private to public. We want to call it.

We are thinking whether to enhance the backend to allow output parameters
too. The obvious
way to do this would be to accept a pointer type to use, so use( int * )
would mean an outbound
integer parameter.


2011/11/17 Mateusz Łoskot <[email protected]>

> Folks,
>
> Another quick survey, I'm wondering who uses SOCI built with features from
> Boost C++ Libraries enabled (Fusion, Tuple, DateTime...)?
>
> Best regards,
> --
> Mateusz Loskot, http://mateusz.loskot.net
> Charter Member of OSGeo, http://osgeo.org
> Member of ACCU, http://accu.org
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to