EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / JPG inserted into MySQL

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: JPG inserted into MySQL

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

neonblue
02-18-2007 @ 11:53 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 3
Joined: Feb 2007

I've found many examples to insert JPG images into MYSQL using PHP, .NET, or CGI but I've been unsuccessful finding examples on how to put .JPG files into MYSQL using coldfusion.  Is anyone aware of any?

Thanks.

cf_yesno2smokin
03-11-2007 @ 4:51 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 3
Joined: Oct 2006

You need to include the following inside the cfquery tag.
<cfqueryparam cfsqltype="cf_sql_blob" value="#data#">.

The image obviously will have to be read in its binary form i.e.
<cffile action="readBinary" file="#filename#" variable="data">

TeamDesigner
03-11-2007 @ 11:38 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 160
Joined: Jan 2007

how far are you so far on this?


Website Designed and Developed by Pablo Varando.