03-27-2008 04:05 AM
04-22-2008 06:17 AM
I am wokring on a conversion project and I am stuck on attachments and where they are located / how they are stored. I know the tbl_attachment is the table it is stored in. Attachment ID, File Name, etc. I am looking for the document itself. I thought it would reside in the database table as some binary object but I can not find it.
Are the attachments stored on the box itself?
(All attached files are located in the subfolder databasename-database files folder/attachments.)
If so, how do you go about actually extracting the attachments? Do a simple loop through the tbl_attachment table and then look in the appropriate folder based on the 'filename'?