|
Hey Ben!
Yeah, the image has no problem writing to the
filesystem. But I'm not sure that rules out WiTango, because writing to the
filesystem and outputting to and ODBC or OCI connection would be two very
different bits of code. However, I am beginning to wonder if there's some
setting for the field in Oracle, or even for the table or database that I need
to use to make this happen. Surely someone's made this work using Oracle or had
the same problem I'm having?
Cheers,
Jonah Simpson
----- Original Message -----
Sent: Wednesday, January 21, 2004 6:56
AM
Subject: RE: Witango-Talk: uploading
images from form into Oracle via different connections [possibly OT] [possibly
OT]
Ok, not doing
anything with Oracle, but here is way to rule out Witango.
The image is sent as
a postarg. So just do a file write action and save the data coming in directly
to a jpg and view the jpg. If it views ok then the image is coming over
correct.
-----Original
Message-----
From: Jonah
Simpson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 3:03
AM
To:
[EMAIL PROTECTED]
Subject: Witango-Talk: uploading images
from form into Oracle via different connections [possibly OT] [possibly
OT]
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
|
