How to Store Many Files in only ONE blob field (sql db)

[Nicolas]

How to store multiple files in only one sql blod field in sql database
Like I got a record for a house:
ID
Name
addresss
price
attachments
The field "attachments" may contains documents (pictures, word file for
specification, autocad file for the plan etc.) We don't know in advance on
many attachments will be uploaded. I should be able to Insert, Update,
Delete part of it.

Any help will be great
Thanks.

 

[Jay B. Harlow [MVP - Outlook]]

Nicolas,

The field "attachments" may contains documents (pictures, word file for
specification, autocad file for the plan etc.)

So you don't know how many documents nor the size of those documents but you
want to save every thing in a single blob?

That does not sound very effective or efficient.

I would consider having an attachments table that is owned by the house
table. Each row of the attachments table would be a single document.

The row would either store the document directly as a blob or I would store
a link to the document, where the document itself is stored in the FS,
possible under a Win32 ACL so as to avoid being inadvertently deleted.

Hope this helps
Jay

 

[Nicolas]

Actually you're right, I was most probably asleep when I thought about it.
thanks