File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes display another record within db result set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "display another record within db result set" Watch "display another record within db result set" New topic
Author

display another record within db result set

Farakh khan
Ranch Hand

Joined: Mar 22, 2008
Posts: 732
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: 30123
    
150

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: display another record within db result set
 
Similar Threads
Trouble with Jenny
Suggestion on Cameras
Can't get a result set!
com folders everywhere......
The one person that I know of......