| Author |
display another record within db result set
|
Farakh khan
Ranch Hand
Joined: Mar 22, 2008
Posts: 672
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26144
|
|
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.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: display another record within db result set
|
|
|
0
