Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-02-21 : 21:23:05
|
| Hello,I am creating a simple CMS for a web site.The web site will hold many documents and for that I created Documents table which holds information on each document such as:Title, Description, Author, Url, ...I would need to create the following functionalities:1. Create a document and upload its file2. Edit a document information and maybe change the file associated with it.3. Delete a document record (info) and the file associated to it.How should I do this?Should I separate the create a document and upload a document (file)?Maybe I should have a table with all files and every time I upload a file I would add a record to that table.And then when I create a document I would insert its information and select one of the uploaded files.Anyway, what is usually the best way to do this?I think that having everything integrating would be better but I am not sure the way to go. Thanks,Miguel |
|
|
|
|
|
CMS > Files