Hi Steve, Thanks for the followup.
I finally convinced the client to reboot the shared server, and the problem with the CFX_PUTIMAGE tag resolved itself. It was running low on some resource, but I could not identify what. The tag had been functioning quite happily for over 2 years, so I am hoping this was a one off anomoly that will not reoccur. The tag inserts into a temporary access db, so your oracle version probably isn't an option for me. At this stage I'll continue to run with cfx_putimage unless the tag starts misbehaving again. Cheers, Phil. ----- Original Message ----- From: "Stephen Bosworth" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, March 09, 2004 12:06 PM Subject: [cfaussie] Re: Insert jpg into database > Hi Phil, > > What database are you using? I've written a java cfx tag that supports oracle for use with BLOB data that I could send you. > > You can also look at this product, its available for different Databases: - > > http://web4w3.com/jblob.html > > Hth, > Steve > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Stephen Bosworth > Application Development and Integration > Communication and Information Services > The University of Newcastle, Australia > Phone: 02 4921 6574 > Fax: 02 4921 7087 > Mobile: 0438 492518 > Email: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > >>> [EMAIL PROTECTED] 9/03/2004 11:47:37 am >>> > Hi All, > > I know that you are NOT supposed to insert images into a database, however I > really do need to. > > I have a CF app that reports via Crystal Reports. One report requires the > printing of an image. > > To date, the approach I have taken is to > > a) store the image file in a folder > b) when this particular report is required, load the necessary images into a > temporary access db and retrieve them via crystal. > > The methodology used to load the images has been to use the CFX_PUTIMAGE tag > that I grabbed off the developer exchange some time ago. > > This tag has now decided to fail at one site for reasons not obvious - am > still investigating that. > > I am also chasing alternative methods. Can anyone advise on how to load an > image into an access db? > > I have seen some posts advising using tobase64 when storing, and tobinary > when retrieving. This won't work in my situation as crystal does not have an > equivalent of the CF tobinary function. > > Any thoughts appreciated. > > Thanks, > Phil. > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
