Hi,
We are currently using the Easysoft ODBC driver for Interbase 6 version 1.00.01.62.
However we still have not figured out how to retrieve or update BLOB fields properly
with ColdFusion. We have tried sending queries using UDFs for BLOB handling, however
they are all limited as we can only write or read 32K blocks of content to/from a BLOB
field at a time.
Does the Easysoft ODBC driver support SQL variable binding? Again we tried this with
no success:
<cfset String="blah bla blah.... veeeery long string.....(...)">
<CFQUERY DATASOURCE="DB">
UPDATE CACHEPAGINA
SET CACHEPAGINA.CONTENIDOCACHE='<cfqueryparam value="#String#"
cfsqltype="CF_SQL_LONGVARCHAR">'
WHERE ID = 4
</CFQUERY>
I hope we do not have to deal with segmented insertions/updates/retrievals as they
will require more than one operation against the database just to deal with a BLOB.
Anybody got a solution to this problem?
Thanks a lot in advance
Francisco J. Montes
Spain on Line
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
