Scare away spammers?
Spam Research Tool -- SpamVampire
December 30, 2004
December 29, 2004
Want a free gmail account?
I thought about doing something like this but looks like this guy cornered the market.
isnoop.net gmail invite spooler
isnoop.net gmail invite spooler
December 22, 2004
December 16, 2004
December 6, 2004
Using ColdFusion to work with SQL binary data
<CFSET FileName = "HotDogVendor.jpg">
<CFFILE ACTION="readbinary" FILE="D:\WebFiles\MyWebsite\Images\Postcards\#FileName#" VARIABLE="NEWDATA">
<cfset NewObject = toBinary(NEWDATA)>
<cfquery name="insertImage" datasource="MyDatasource" username="myusername" password="mypassword">
update images
set content = <CFQUERYPARAM VALUE="#NewObject#" CFSQLType="CF_SQL_BLOB">
where NAME = '#FileName#'
</cfquery>
...And now, how to output an image, which is stored in a SQL Server table as an image data type? Here is code which I found on another forum that appears to work (but still not the perfect solution):
<cfquery name="GetImage" datasource="MyDatasource" username="myusername" password="mypassword">
select content
from Images
where NAME = '#FileName#'
</cfquery>
<cfcontent type="image/gif; charset=8859_1">
<CFSCRIPT>
writeOutput(toString(GetImage.Content));
</cfscript>
<CFFILE ACTION="readbinary" FILE="D:\WebFiles\MyWebsite\Images\Postcards\#FileName#" VARIABLE="NEWDATA">
<cfset NewObject = toBinary(NEWDATA)>
<cfquery name="insertImage" datasource="MyDatasource" username="myusername" password="mypassword">
update images
set content = <CFQUERYPARAM VALUE="#NewObject#" CFSQLType="CF_SQL_BLOB">
where NAME = '#FileName#'
</cfquery>
...And now, how to output an image, which is stored in a SQL Server table as an image data type? Here is code which I found on another forum that appears to work (but still not the perfect solution):
<cfquery name="GetImage" datasource="MyDatasource" username="myusername" password="mypassword">
select content
from Images
where NAME = '#FileName#'
</cfquery>
<cfcontent type="image/gif; charset=8859_1">
<CFSCRIPT>
writeOutput(toString(GetImage.Content));
</cfscript>
Subscribe to:
Posts (Atom)