Posted by --CELKO-- on 10/28/06 01:26
>> I know that it's usually pretty trivial within the code that is querying the database, but I'm wondering if the database itself can do this. <<
Yes, if you do not mind violating good programming practices. Why do
you wish to destroy First Normal Form (1NF) with a concatendated list
structure? It is the foundation of RDBMS, after all.
Why are you formatting data in the back end? The basic principle of a
tiered architecture is that display is done in the front end and never
in the back end. This a more basic programming principle than just SQL
and RDBMS.
This is like getting on a woodworking newsgroup and asking about the
best rocks for driving screws into fine furniture ...
Navigation:
[Reply to this message]
|