Hi Steve, I've only been playing with 70K images, which are pemanently stored in a windows folder. I only temporarily move a copy to an access db for reporting, and then destroy the access db afterwards.
I have adopted this approach because all the literature I found strongly discouraged images in db's. It's supposedly very unkind to internal db structures. If the only purpose you have is attempting to save disk storage, I would expect you would go backwards due to db overheads, plus cause yourself some maintenance headaches in the process. HTH, Phil. ----- Original Message ----- From: "Clifton Steve" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 10:58 AM Subject: [cfaussie] Re: Insert jpg into database > Hi, > > I've been watching this thread with interest, and was wondering whether > there are any filesize restrictions to storing files in a MSSQL db? > Also, if a 1mb image is added, does it mean that the database increases > in size proportionately (ie. by 1mb) or is it more efficient than that? > > Thanks for any info on this... I am really keen to try it out if it is > more efficient (HDD capacity-wise)! > > Steve c > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen > Bosworth > Sent: Tuesday, 9 March 2004 12:06 PM > To: CFAussie Mailing List > 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 > --- 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
