[Cppcms-users] C++DB question regarding "IN"

[Jon F. <jon...@jf...>]

I've skimmed over the C++DB docs a couple of times and I don't see anything 
about the best way to build queries using the "in" operator. My use case is 
doing a bulk "UPDATE" command using "in" to target the set of records I 
want by a list of integer IDs.  Example query:

    UPDATE my_table SET field_1="my val" WHERE id IN (1,3,9);

Right now I'm scrubbing strings coming back from an HTML form (via C++CMS) 
and then building them direct into query string. Seems like C++DB probably 
already has better way. It seems to be well thought out.

TIA - Jon

-- 
Sent from my Devuan Linux workstation -- https://devuan.org/
"Init Freedom", Yeah!

Jon Foster
JF Possibilities, Inc.
jo...@jf...