how to insert rows into database from array/hash using DBI

2007-10-23 Thread petelink1
I'm trying to grab data from an MS-Access log file and put it into a fast, read-only database. (I'm thinking SQL Lite at this point.) The code below is working. Now I need to put the identical data and structure into an SQL Lite table. Any suggestions on where to look for examples? (or if you w

Re: unfamiliar array reference

2007-08-25 Thread petelink1
On Aug 24, 9:03 am, [EMAIL PROTECTED] (Paul Lalli) wrote: snip > > 'our', like 'my', is lexically scoped. Its effects are terminated > when the innermost enclosing block ends. So if you're using the same > package variable in two different blocks, you have to use 'our' in > each of them: > Yes

Re: unfamiliar array reference

2007-08-23 Thread petelink1
On Aug 18, 7:58 pm, [EMAIL PROTECTED] (Paul Lalli) wrote: snip > > Is that seriously from the book? UGH. Just declare $array_ref in the > proper scope, and there's no need to take a reference to a dereference > of the reference. > > while (my $array_ref = $sth1->fetchrow_arrayref) { > push

unfamiliar array reference

2007-08-18 Thread petelink1
I'm reading the book Programming the Perl DBI to start work with databases. The DBI portion I'm getting OK, but I find the reference here to @$ confusing. (This code is based from the book.) my $sth1 = $dbh->prepare("select 'SCM_ORDERS_OUT', message_index, message_no, message_event, time_stamp, d