On 06/11/2007 06:52 PM, Northstardomus wrote:
[...]
print "<br/>Inserting into Database , @values.";
Use the "quotemeta" function to escape special characters
that may be in the values.
my @values_copy = @values;
@values = map quotemeta($_), @values;
$dbh->do("INSERT INTO area_status (areaID, survey_date,
update_time,
status ) VALUES ('$values[0]', '$values[1]', '$values[2]',
'$values[3]')");
$dbh->disconnect();
}
}
Read "perldoc -f quotemeta"
The "do" method also has a better way to input the values. See the top
of "perldoc DBI"
I hope this helps.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
