Please could anyone at least explain how to show a BLOB field?
out.println(queryDataSet.Format("TEXTDOC"));
doesn't work...
Best Regards,
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]
> -----Original Message-----
> From: Giovanni Az�a Garc�a [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 17, 2000 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: Interbase BLOB data type
>
>
> 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
___________________________________________________________________________
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
