The Portlet Factory wiki now has an entry and sample application demonstrating an approach to handling (retrieving and inserting) BLOB data using the SQL builders. A similar approach can be used for handling CLOB, STRUCT, and other database types.
This topic has been locked.
2 replies Latest Post - 2010-02-08T04:19:33Z by ic3
Pinned topic FYI: Handling BLOB data with the SQL builders
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-02-08T04:19:33Z at 2010-02-08T04:19:33Z by ic3
ic3 270001D1BU4 PostsACCEPTED ANSWER
Re: FYI: Handling BLOB data with the SQL builders2010-02-08T04:19:33Z in response to SystemAdminHi,
I tried this, but couldn't quite get it working for files other than images. We have some pdf, doc and txt files in our blob and I can't quite work out a way to download them.
I have attached my test model to get it working, if someone can help it would be greatly appreciated.