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
