Incomplete Image created from SQL Image type using cfimage

[Krogman]

Hello

Has anyone run into this problem? I have an SQL 2005 database with a column in a table of type image (created from a commercial product). When I use the CFIMAGE tag to create or write the image to a browser (or disk) the image is nearly always truncated (see below). The dimensions of the image are correct, but most of image data is missing. Here is an example:

I've tried using the cfsetting with a large timeout value, but it makes no differnce. Nearly 90% of the images created from the database are truncated like this when created using the cfimage tag. When viewed or exported from the original application (and database) it's fine. Does anyone have any ideas I can try to figure this out or work around the problem?

Thanks, Joe

[ilssac · Accepted solution]

That is stored in a BLOB field I presume.

When working with BLOB and CLOB data, there are default paramters in the DSN settings that can control how much data is allowed to pass through the database driver.

That is the first thing I would look at.

[Guest]

From what Ian's said, check in your Datasource.

If you're using BLOB (which I expect you are), make sure you've checked the "Enable binary large object retrieval (BLOB)." option as this makes it able to return more than 64kb via the JDBC connection.

This is in place to ensure that it doesn't send huge amounts of data when it doesn't need to, but can cause problems like this when you first look at it.

[Krogman]

Thank You Ian & Phil

Now I know why there's an advanced tab in the datasource setting

Thanks for your excellent reply!