On Tue, Aug 28, 2012 at 2:27 PM, Steven Elam <[email protected]>wrote:
> I’m using soci to write code to interact with a MySQL db. I’m trying to
> select from a table using a where clause that contains a reference to
> column that might be NULL. I’m trying to use a boost::optional in a use()
> to avoid having to write two separate statements:****
>
> ** **
>
> What I want to do:****
>
> ** **
>
> int function(session sql, optional<int> col2Val)****
>
> {****
>
> int col1Val;****
>
> sql << “select col1 from table1 where col2 = :col2Val”, into
> (col1Val), use(col2Val);****
>
> return col1Val;****
>
> }****
>
> ** **
>
> What I have to do instead:****
>
> ** **
>
> int function(session sql, optional<int> col2Val)****
>
> {****
>
> int col1Val;****
>
> if (col2Val)****
>
> sql << “select col1 from table1 where col2 = :col2Val”, into
> (col1Val), use(col2Val);****
>
> else****
>
> sql << “select col1 from table1 where col2 is null”, into
> (col1Val);****
>
> return col1Val;****
>
> }****
>
> ** **
>
> Is there a way to achieve this more concisely using the optional type?
> Thanks.
>
I don't think you can do this with SOCI, sorry. If someone knows otherwise
I'd be curious myself.
Thanks,
Aleksander
> ****
>
> ** **
>
> Steve****
>
> ** **
>
> ** **
>
> *Steven L. Elam*
>
> *Software Engineer*
>
> *Guided Wave Incorporated*
>
> 3033 Gold Canal Drive****
>
> Rancho Cordova, CA 95670****
>
> USA****
>
> Tel: +1-916-638 4944 ext 1301****
>
> Fax: +1-916-635 8458****
>
> Cell: +1-916-365 3148**
>
> Email: [email protected]****
>
> Web: www.guided-wave.com****
>
> *[image: cid:[email protected]]*****
>
> An Advanced Company****
>
> ** **
>
> [image: Logo 1 -without Wording]www.AdvancedHoldings.com****
>
> ****
>
> DISCLAIMER
> The information contained in this email, including any attachments, is
> confidential and proprietary information of the Advanced Group and intended
> solely for use by the addressee. If you are not the intended recipient,
> you are hereby notified that any dissemination, distribution or copying of
> the information contained in this email is prohibited. If you have
> received this email in error, please notify the sender immediately by
> return email and delete this email from your system. Any conclusions or
> opinions contained in this email are those of the author and do not
> necessarily represent those of the Advanced Group. It is the responsibility
> of the recipient of this email and its attachments to check for the
> presence of viruses. Advanced Group is not responsible for any damage
> caused by any virus transmitted by this email or its attachments.****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
>
>
<<image002.jpg>>
<<image001.png>>
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
