After searching the archives. I know no one likes the idea of images stored in databases.
BUT i have a database that is already created with images inside. It is from a program called Cumulus. It really appears that CFQUERY cannot handle a MS SQL Image field. If i query the MS SQL db and just try to display the contents of the Image field i get about 10 characters. Why isnt CFQUERY getting the binary data correct? It is almost like it is being truncated or translated. I played with ASP for a while and it displays the binary data fine. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists