469,317 Members | 1,940 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

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

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.
Nov 20 '05 #1
2 3229
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" <nl*****@hotmail.com> wrote in message
news:et*************@TK2MSFTNGP12.phx.gbl... 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.

Nov 20 '05 #2
Actually you're right, I was most probably asleep when I thought about it.
thanks

"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in message
news:Oz**************@TK2MSFTNGP09.phx.gbl...
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" <nl*****@hotmail.com> wrote in message
news:et*************@TK2MSFTNGP12.phx.gbl...
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.


Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by David Stockwell | last post: by
3 posts views Thread by Steve | last post: by
4 posts views Thread by clark | last post: by
1 post views Thread by Selen | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.