Witango-Talk: uploading images from form into Oracle via different connections [possibly OT] [possibly OT]

[Jonah Simpson]

Hey All! In an issue I hate revisiting, I've got a problem uploading images (jpg) from a form into an Oracle database. This time I've done a bit more experimentation on the code but I still don't have a solution to get it work. Basically, what I'm trying to do is take a file submitted with <input type="file"....> via <form encytype="multipart/form-data" ...> and store it in a BLOB field in Oracle 8.2 using OCI. I'm using Windows 2000, Apache 2.0, Witango 5.0. The code I'm working on had previously been run on a Sun box, with Witango2000 and prior and Apache (not sure of version). During an upgrade of either Apache or WiTango the code stopped working. There are images in the database from when the routine worked, and I can download them and display them using <img src="" ...> without a problem. Here's where it gets weird. I was concerned that it was an Apache upgrade that broke the routine. So I tried moving the information over to a MySQL database figuring I'd get the same problem. But it worked fine! So now I began thinking that this problem was maybe related to the database connection method. So I tried using the Oracle ODBC and the Microsoft Oracle ODBC. The MS Oracle ODBC didn't work at all. However, the Oracle ODBC did, kind of. The problem is it looks like its corrupting the data about a quarterway through the images (Firebird displays the image out of focus, IE gives red x). I've got itembuffersize set to 5mb, and the files I'm sampling are like 40kb. Based on the process of elimination, I'm left with two culprits that could be causing the problems, Oracle or WiTango. Is anybody doing something similar (with Oracle, Apache 2.0, Windows, and WiTango 5.0) and have it working perfectly, even if its not necessarily jpegs, but some other binary data? Or any insight? I really need to make this code work... (we're migrating to storing the images in the filesystem, but we can't do that yet because of factors outside our power). Thanks! Jonah Simpson ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf