Re: Perl arrays into MySQL

2004-06-01 Thread Tim Cutts
On 1 Jun 2004, at 2:55 am, Nik Belajcic wrote: This may be a silly question, but I am wondering if there is something opposite to: @row = $sth->fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite

Re: Perl arrays into MySQL

2004-06-01 Thread Richard Clarke
into $table set $sql",undef,values %record); Richard - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Nik Belajcic" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 01, 2004 5:15 AM Subject: Re: Perl arrays into MySQL &

Re: Perl arrays into MySQL

2004-06-01 Thread Richard Clarke
A perhaps more perlish way would be, my $table = "MyTable"; my $sql = join ',', map {"$_=?"} keys % - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Nik Belajcic" <[EMAIL PROTECTED]>; <[EMAIL PROTECTE

Re: Perl arrays into MySQL

2004-05-31 Thread Daniel Kasak
Nik Belajcic wrote: This may be a silly question, but I am wondering if there is something opposite to: @row = $sth->fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite - take a Perl (associative

Perl arrays into MySQL

2004-05-31 Thread Nik Belajcic
This may be a silly question, but I am wondering if there is something opposite to: @row = $sth->fetchrow_array In other words, instead of fetching rows from MySQL and loading them into an array that can be accessed from Perl, I want to do the opposite - take a Perl (associative) array and load i