THanks for the quick response.
For the mime type, its not the database that is truncating the value, its PHP. If I do an echo $mime, I get the truncated value.
Second, I was just comparing the files in a HEX editor. It looks like when my files are being downloaded (or even uploaded) there is one extra blank space at the end. That is the only difference I can see from comparing hex values.
chrisindfw
Last Activity: Aug 28 '10, 01:31 PM
Joined: Feb 8 '08
Location:
-
Uploading xlsx file to mysql database?
I am uploading a file to a mysql database table. Now let me say that this works perfectly fine for PDF, XLS, and DOC files. However if I upload an XLSX (office 2007 file), it uploads fine, however when it is downloaded, it cannot be read.
I can open both the original uploaded file and the one I downloaded in wordpad and they look EXACTLY the same.
HELP!
Additionally I am noticing that with Office 2007... -
Let me see if I have this straight.
- Put a trigger on my main table that inserts into a temporary table.
- Put a trigger on the temp table that does the update on the main table?
Do I have that right?Leave a comment:
-
Help with Trigger Updating same row?
Hello all!
I have seen very wide discussions on this before on the web but I was wondering what your thoughts were.
I have a table where when a record is added, I want to update that row. Sounds simple. But I am getting the nasty error about mutating tables.
Here is a very generic summary.
TABLE_A
Field1 Number
Field2 Text
Insert into Table_A (Field1) Values...
No activity results to display
Leave a comment: