Hi all,

(Interbase, JRun, Windows NT, JBuilder 2.0)

I have a BLOB DB field type and I want to show it from a servlet but
I haven't found how to make it work (the JBuilder doc doesn't say anything
regarding to this)... here goes the snippet:

<snippet>
QueryDataSet  queryDataSet = new QueryDataSet();
StringBuffer  sqlQuery= new StringBuffer();
InputStream   value= null;

// TEXTDOC BLOB DB field
try
{
 sqlQuery.append("SELECT TEXTDOC");
 sqlQuery.append(" FROM VOLNR");
 sqlQuery.append(" WHERE NRDOC=" + nrdoc + " AND NRVOLNR=" + nrvolnr + ";");

 queryDataSet.setQuery(new QueryDescriptor (database,sqlQuery.toString()));
 queryDataSet.open();
 out.println(queryDataSet.getInputStream("TEXTDOC").toString()); // ???
doesn't work

// ...
</snippet>

Best Regards and Thanks in advance,
Giovanni

BSc. Giovanni Az�a Garc�a
Bachelor in Computer Science
Banking and Economic Information Center
Central Bank of Cuba
ICQ# 20725388
e-mail: [EMAIL PROTECTED]

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to