how to store many files in one database field

lyealain

how to store many files in one database fields?? i manage to store one file into database field.. but fail to store many files.....

how should i do that>> one database field for many files name.. is this way correct???

or each field for one filename?? 10 fields for 10 files??

Jul 21 '07 #1

christopherpond

Sounds like you should create association table

Jul 24 '07 #2

lyealain

is this how all people do for this problem?? how do u all insert multiple files into database>>> ???

Jul 24 '07 #3

lyealain

is this how all people do for this problem?? how do u all insert multiple files into database>>> ???

waht is association tables.

Jul 24 '07 #4

christopherpond

Well I don't have your schema but I would keep your existing Table A and create another table call it documents that has a foreign key to Table A's ID column.

For example,
Table A
ID = 1

Table B (2 columns (or 3 if you don't want composite key)
Columns
Filename
Table A ID

Then you can have a single record in Table A but many filenames in Table B.

Jul 24 '07 #5