Hello, For using blob, I can do this
----------- sql << "insert into blobtest(id, img) values(7,lo_creat(-1) )"; sql << "select img from blobtest where id=7",into(b); b.write(0,(char *)ptr,stbuf.st_size); ----------- but not this ----------- sql << "select lo_creat(-1)",into(b); b.write(0,(char *)ptr,stbuf.st_size); sql << "insert into blobtest(id, img) values(7,:b)",use(b); ----------- The insert statement fails with error "Use element used with non-supported type." The first form makes a trip to the table for no reason IMO. Is it possible to support second form? -- Shridhar ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Soci-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/soci-users
