|
|
Posted by Oli Filth on 12/18/29 11:48
Tim Streater said the following on 23/05/2006 17:49:
> I have some items, numbered from 0 upwards. Some of them may have a
> string attached. All these items need to be represented in a single
> already existing database record. So, I thought of taking an array, as
> it might be looking thus (the values are all strings):
>
> Key Value
> --- -----
> 0 firstone
> 2 somestring
> 5 anotherstr
>
>
> and so on, and converting it to a single string:
>
> "'0', 'firstone', '2', 'somestring', '5', 'anotherstr'"
>
> then I have a string I can write to the database record.
>
Is it absolutely mandatory that you put these into a single record?
This is almost certainly a bad idea. Not only do you have to write
conversion functions to get data into and out of the database, but you
data is no longer atomic. Amongst other things, this makes it difficult
to search, index, delete or reference your data...
--
Oli
Navigation:
[Reply to this message]
|