We're using Filemaker Server 11.  With ODBC/JDBC enabled.

 

Over the years files have been embedded in the records in containers.  I need to be able to pull these into our website so i've connected via JDBC and am pulling files in.

 

http://www.filemaker.com/support/product/docs/11/fmp/fm11_odbc_jdbc_guide_en.pdf using this document as my reference.

 

.ai .zip .psd all come out fine with GetAs(field, 'FILE')  

.png files come out fine GetAs(field, 'PNGf')

 

But when I try to pull out .pdf files with GetAs(field, 'PDF') like the documentation indicates I should be able to, it throws 'PDF' is not a valid stream name.

Of course i've tried 'FILE', 'PNGf', 'EMBO'

 

Also appears most jpg's fail to download too with GetAs(field, 'JPEG').  Tried 'JP2' but it claims its not a valid type either.

 

The list shows:

 

'EMF+' Windows Enhanced Metafile Plus

'PDF ' Portable Document Format

'EPS ' Embedded PostScript

'PICT' Mac OS (does not have 512-byte file-based header)

'FPix' Flash (FPX)

'PNGf' Bitmap image format

'FORK' Resource fork (Mac OS)

'PNTG' MacPaint

'GIFf' Graphics Interchange Format

'qtif' QuickTime image file

'JPEG' Photographic images

'.SGI' Generic bitmap format

'JP2 ' JPEG 2000

'TIFF' Raster file format for digital images

'META' Windows Metafile (enhanced)

'TPIC' Targa

'METO' Windows Metafile (original)

'XMLO' Layout objects

'moov' Old QuickTime format (Mac OS)

'8BPS' PhotoShop (PSD)

 

Is there a way to retrieve the 'stream' type?

Ok so I ended up using the ROWID plugging it into the XML API and downloading the files that way.  Now i've got all of the files out.  But for a legacy layout I need to put some files back in.  Hopefully this can be done via the xml api?