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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-10 : 13:30:41
|
Erhan writes "Hi,
I've been looking for two answers for weeks from many sites, friends and got nothing yet.
Question1:
I want to design table(s) which will contain info about the articles we published in our newspaper or magazine. To achieve this I've a table for authors. Fields are: name, surname, email, company etc....
Main table about articles has fields: title, volume number, content and AUTHOR (combo menu from author table)...
Problem is; some articles has more then one author. Is it only way to add fields like author1, author2, author3 ....to database?
Is there a way to store multiple values to a field like dynamic array field or a field like combo box in a html form? Because you can select many option by ctrl+click.
Question2:
I want to store these articles in a database and publish them to internet. To do this, I design a web page about this article, copy the html source code and paste it to content field in database. Do you know any worse way? :)
In other words which way is the best to store an article to a database preserving formation? (Article may contain picture, table, subtitle ...)
Thanks," |
|
|
|
|
|
|
|
dynamic array field / way to store html code