At 7:57 pm +1000 5/4/01, Neil Lunn wrote:
>I tend to not like this method. Certainly the duplication of field names
>tends to break code. If you are really looking at storing array values in a
>field for some purpose, you would be better off breaking up the scalar in
>perl.
>
>If the idea is just day[1], day[2], etc then name fields day_1, day_2, etc.
>This approach tends to be more portable between databases. Not everything
>supports array fields and if it does it usually isn't like this.
And the array fields seem to be quite limited in usefulness: there
doesn't seem to be much that you can do with one beyond SELECTing its
individual elements by index -- I can't find a way to DELETE or
UPDATE elements.
Oh well, it's been educational. Thanks for all the help!
--
My brain hurts!
SeanC
Mediatek Training Institute
26 Crart Ave., Berea, Durban, South Africa
<-- New Address
phone: +27 (0)31 202 1886 [EMAIL PROTECTED] <--
New Phone Number
fax: +27 (0)31 202 1767
<-- New Fax Number
<http://members.nbci.com/s_carte/>