:15 PM
To: cf-talk
Subject: Re: Convert Image to Binary
Managing images on disk is a better way but if you must use the data base
make sure you are using
cfqueryparam scfqltype=CF_SQL_BLOB
vale=#toBase64(FinalMergedDisclosure)# /
Which should work for you.
On Thu, Feb 26, 2009 at 11:14 AM, Priya
Now I can sucessfully store the Binary data to thedatabase but unable to
retreive it. Again it is giving me with the same error.
I used cfcontent but sometimes its display and sometimes its not. Also
tried sing toString,tobase64 etc but no results.
Any ideas?
On Thu, Feb 26, 2009 at
Now I can sucessfully store the Binary data to thedatabase but unable to
retreive it. Again it is giving me with the same error.
I used cfcontent but sometimes its display and sometimes its not. Also tried
sing toString,tobase64 etc but no results.
Any ideas?
Agree... store image
, 2009 9:54 AM
To: cf-talk
Subject: Re: Convert Image to Binary
Now I can sucessfully store the Binary data to thedatabase but unable to
retreive it. Again it is giving me with the same error.
I used cfcontent but sometimes its display and sometimes its not. Also
tried sing toString,tobase64 etc
. We had
plenty of images to test it out... ;-)
-Original Message-
From: Paul Kukiel [mailto:pkuk...@gmail.com]
Sent: Thursday, February 26, 2009 12:15 PM
To: cf-talk
Subject: Re: Convert Image to Binary
Managing images on disk is a better way but if you must use the data base
make
To: cf-talk
Subject: Re: Convert Image to Binary
Managing images on disk is a better way but if you must use the data base
make sure you are using
cfqueryparam scfqltype=CF_SQL_BLOB
vale=#toBase64(FinalMergedDisclosure)# /
Which should work for you.
On Thu, Feb 26, 2009 at 11
it adds extra load on the webserver and database and fills the
database.
Another point is that, with a standard image stored on the server and
requested by the browser,
the server can reply No the image has not changed and the browser can
get it from its cache.
If the image is produced from
cfset thisDir = expandPath(.)
cffile action=upload fileField=image destination=#thisDir#
result=fileUpload
nameconflict=overwrite
cfdump var=#thisDir#
cfimage action=read source=#fileUpload.serverfile#
name=myImage
cffile
Hi All,
I am trying to store the image file into sql database in a binary form. I can
sucessfully browse image, read it and display in the browser but unable to
convert it into binary.
This is wat I did
cfset thisDir = expandPath(.)
cffile action=upload fileField=image
Any sugestions
Yes, store only the image characteristics like file name, size, title,
etc in the database,
and use the system file management to handle the image storage.
It is generally more efficient than increasing the size of the database
for nothing.
Managing images on disk is a better way but if you must use the data base
make sure you are using
cfqueryparam scfqltype=CF_SQL_BLOB
vale=#toBase64(FinalMergedDisclosure)# /
Which should work for you.
On Thu, Feb 26, 2009 at 11:14 AM, Priya Koya priya23...@gmail.com wrote:
cfset thisDir =
That would mean you're entering base64 text into a binary field.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/2/27 Paul Kukiel pkuk...@gmail.com:
Managing images on disk is a better way but if you must use the data base
make sure you are using
cffile action=readbinary file=/store/image.jpg variable=fileContents
cfqueryparam cfsqltype=cf_sql_blob value=#fileContents# /
Is all you need when the datatype is image or varbinary on MSSQL you
don't need the tobase64 that will teach me for responding to fast.
Thanks james
You also need to
13 matches
Mail list logo