Re^3: Date Problem


Your skill will accomplish what the force of many cannot
	PerlMonks

Re^3: Date Problem

by moritz (Cardinal)

on Apr 26, 2010 at 10:37 UTC ( [id://836877]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Date Problem
in thread Date Problem

The correct way of passing arguments to DB queries is to use placeholders:

my $SQL = Select tran_seq_nbr, sale_amount 
From KCPOS_Tran_Header
Where org_number = ?
And store_number = ? 
And tran_number = ?
And terminal_number =? 
And tran_Date = ?";

my $sth = $dbh->prepare( $SQL )
    or die "Couldn't prepare statement: " . $dbh->errstr;

$sth->execute($ai_div, $ai_store, $al_trans, $ai_reg, $adt_h_date )
    or die "Couldn't execute statement: " . $sth->errstr;
[download]

That way you can avoid quoting errors which might cause your problem.