RE: [Fwd: fetchrow_arrayref()]

2005-07-13 Thread Moon, John
Subject:fetchrow_arrayref() Date: Wed, 13 Jul 2005 11:08:00 +0100 From: David Foley <[EMAIL PROTECTED]> To: beginners@perl.org Hi Guys, I need help with this. Please find below some code: #!/usr/bin/perl -w # Reduce scripting errors + call DBI module use strict; us

Re: [Fwd: fetchrow_arrayref()]

2005-07-13 Thread Jeff 'japhy' Pinyan
On Jul 13, David Foley said: my $SQLQ2a = "INSERT INTO dev (batman, robin) VALUES ($FirstName, $SecondName)"; #SQL Query 2 HANDLE my $SQLQ2 = $MySQL2->prepare($SQLQ2a); $SQLQ2->execute(); You should be using placeholders instead of actual values in your SQL query: my $SQLQ2a = "INSERT IN