RE: Storing and Retrieving Arrays [DBD::Pg]

2001-04-05 Thread Sean Carte
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

Storing and Retrieving Arrays

2001-04-04 Thread Sean Carte
I've asked for help on this topic before, but received no response. Is there a better way of doing this? The following is a sample script: #!/usr/bin/perl -w # sql_arrays.pl use strict; use DBI; use Fcntl; my $uid = 'database'; my $db_name = 'test'; my $table = 'array_test1'; my $pass = '';

RE: Storing and Retrieving Arrays

2001-04-04 Thread Neil Lunn
-Original Message- From: Sean Carte [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 7:27 PM To: [EMAIL PROTECTED] Subject: Storing and Retrieving Arrays You're right. You have misunderstood the concept I've asked for help on this topic before, but received

RE: Storing and Retrieving Arrays

2001-04-04 Thread Sean Carte
Thanks for the help Neil and Bodo. However, I do not want to store a Perl array in multiple rows, but in a single SQL array. At 7:49 pm +1000 4/4/01, Neil Lunn wrote: [...] You're right. You have misunderstood the concept [...] Maybe you want to have an array field? You would still have to