Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

display another record within db result set

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am storing articles in oracleXE db as clob. I want that after 10 lines or 250 words I may be able to show some pictures and videos related to this article.

I tried a lot by using the split() method by splitting the 250 words but result set shows all data and at the end pictures/videos appears. Any suggestions please

Best regards
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your article is a combination of text and pictures. I can think of two approaches:
1) Store the article in multiple fields - clob for text, blob for images. Then add another column for "order" within an articleId.
2) Store the whole thing in a BLOB using some encoding for the text. Not sure how to do this as it seems like a hack.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic