We developed an Oracle/Java routine to work with BLOBs and it works well. We use it to collect any sort of binary files required (word docs, excel, images etc) to feed into a corporate system that also has a client/sever interface.
You can use a Java class and do the same thing with MS SQL Server if JDBC is installed on the DB. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Stephen Bosworth Application Development and Integration Communication and Information Services The University of Newcastle, Australia Phone: 02 4921 6574 Fax: 02 4921 7087 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> [EMAIL PROTECTED] 17/10/2003 3:03:14 pm >>> This is not a database that I created.. it's simply the way I have to do it as this database integrates with client software which expects the images to be in the DB. >>> [EMAIL PROTECTED] 10/17/03 01:53pm >>> Inserting a large number of images into sql server (or most db's?) is not kind on the internal database structures. I avoid doing it if possible. Is it an option to store the filename of the image in the db, and use it that way? I've used CFX_PUTIMAGE with success, going into an access db. It's part of a report run, and the temporary access database is deleted and recreated regularly to ensure the internal db structures are not trashed. I haven't had to use CFX_GETIMAGE. HTH Phil. ----- Original Message ----- From: "Brian Gilbert" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 1:42 PM Subject: [cfaussie] Working with BLOB's via CF - anyone had any luck? > Has anyone done anything with writing and reading images to a blob field > on MS SQL server via CF? > > I've tried CFX_getimage and CFX_putimage.. but they've been pretty > flaky so far. > > Looking for something reliable. > > Brian Gilbert > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
