-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Big man are you using cf5 or cfmx ? For cf5 use the image datatype for the blob also you should look at cfx_getimage (see - HYPERLINK "HYPERLINK "http://www.sys-con.com/story/?storyid=41829&DE=1"http://www.sys-con.c om/story/?storyid=41829&DE=1"http://www.sys-con.c om/story/?storyid=41829&DE=1 ) watch the wrap :-) hth mate - -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 29 September 2004 14:58 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CF anf B:-(oBs Hi Steve this is the way I usually do it however its not my code or DB I am dealing with someoneelses great idea :P and its MSSQ:-( Thanks - ----- Original Message ----- From: HYPER:-(IN:-| "mailto:[EMAIL PROTECTED]"Steve & :-|aren :-|ahn To: HYPER:-(IN:-| "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 3:30 PM Subject: RE: [ cf-dev ] CF anf B:-(oBs Matt First of all what type of database are you using? If its Microsoft SQ:-( than make the field that is to store the image a “varchar”. Now when you input the data, do not put the file in. Instead put the server path To the file. “web/images/picture_blob.jpg”. Now when you want to show it on a page. Use a standard <CFQuery name=bubba> select * from myfield </cfquery> Then Use a <cfoutput query=blob>#bubba#</cfoutput> Hope that helps. Steve - -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 29, 2004 6:56 AM To: [EMAIL PROTECTED] Subject: [ cf-dev ] CF anf B:-(oBs Hi I am having to deal with images stored as B:-(oBs in a DB how in gods name do I query the DB for the blob and display the image? I tried query it out .. use cfcontent to display with correct mime type .. no good any ideas? thanks |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: HYPER:-(IN:-| "http://www.matt-horn.org"http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|
- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004 - --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004 -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.5.3 iQA/AwUBQVw8TAFTjgrZW80AEQLjbACdG7aQd8Se8w16lxcVOnd6JkFdEegAnRDW eLPrWJNYy2Nki5XDV1xlUgU4 =SAi9 -----END PGP SIGNATURE----- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]