RE: perl-dbi #temp table created using handle not accessible when accessed via ->do() with the same handle

2011-08-04 Thread William Gordon Rutherdale (rutherw)
Maybe it just doesn't like the # character in the table name. -Will > -Original Message- > From: Anantharaman Sekaripuram, Gopalakrishnan > [mailto:gopalakrishnan.sekaripuram.ananthara...@deshaw.com] > Sent: 4 August 2011 08:57 > To: dbi-users@perl.org > Subject: perl-dbi #temp table cre

RE: question on CPAN example for DBI

2011-07-31 Thread William Gordon Rutherdale (rutherw)
You should look up what prepare-statements do in SQL in general. The idea is that you define the form of the query or update in advance, giving the RDBMS a chance to construct the operation. You then send it repeated execute calls with specific values. In your example, baz in the prepare call