Filemaker GetAs...How to display Container Field on webpage?

Question

I have an ASP.Net application that needs to display an image that is stored in a Filemaker Container field. My query statement looks like:

select GetAs(Image, 'JPG') from UA_Item_Pictures where "Stock Number"=33989 and ImageOrder=1

According to the documentation: The possible file types (case sensitive) you can retrieve from a container field in a FileMaker database file are: 'EMBO' OLE container data

'PDF ' Portable Document Format

'EMF+' Windows Enhanced Metafile Plus

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

'EPS ' Embedded PostScript

'PNGf' Bitmap image format

'FILE' Result of an Insert File command

'PNTG' MacPaint

'FPix' Flash (FPX)

'qtif' QuickTime image file

'FORK' Resource fork (Mac OS)

'.SGI' Generic bitmap format

'GIFf' Graphics Interchange Format

'snd ' Standard sound (Mac OS raw format)

'JPEG' Photographic images

'TIFF' Raster file format for digital images

'JP2 ' JPEG 2000

'TPIC' Targa

'META' Windows Metafile (enhanced)

'XMLO' Layout objects

'METO' Windows Metafile (original)

'8BPS' PhotoShop (PSD)

'moov' Old QuickTime format (Mac OS)

So with this information, my questions are:
1) How do I retrieve contents with multiple formats? 2) How do I render the BLOG into an image on the page?

Any suggestions would be much appreciated!

Answer 1

Buy a license of SuperContainer (shameless plug alert: I'm one of the authors) and a Mac Mini to host it on. Move the files out of your container fields and into SuperContainer, and let SuperContainer render image versions of your files by tapping into OS X's CoreImage libs.

Answer 2

Thanks, but I think I found out what was going on. If I did an inner join between an image table and another table, the image wasn't being returned (or being returned properly...not sure which). As soon as I ran a query against the image table directly, images were returned.

So this did not work: select * from biography_table b inner join image_table i on b.stocknumber = i.stocknumber where b.stocknumber = 12345

But this does: select * from image_table where stocknumber = 12345

This means I have to run 2 separate queries, but at least I'm seeing data!!

Answer 3

please visit http://fmoverflow.net for a site dedicated exclusively to filemaker