my $query2 = "SELECT " . join(",", @q_return) . " FROM rma_list WHERE (" . join(",", (keys %q_search)) . ") = (" . join(",", @q_names) . ")";
my $sth = $dbh->prepare($query2) or die "Couldn't prepare query: " . $dbh->errstr;
$sth->execute();
####
my $query = "SELECT " . join(",", map { "?" } @q_return) . " FROM rma_list WHERE (" . join(",", map { "?" } (keys %q_search)) . ") = (" . join(",", map { "?" } @q_names) . ")";
my $sth = $dbh->prepare($query) or die "Couldn't prepare query: " . $dbh->errstr;
$sth->execute(@q_return, (keys %q_search), @q_names) or die "Could not perform query: " . $sth->errstr;
####
DBI::db=HASH(0x1b76164) trace level set to 0x0/2 (DBI @ 0x0/0) in DBI 1.607-ithread (pid 3392), referer: http://localhost/cgi-bin/temp.cgi
-> prepare for DBD::mysql::db (DBI::db=HASH(0x1b761a4)~0x1b76164 'SELECT ?,?,?,?,? FROM rma_list WHERE (?) = (?)') thr#233e34, referer: http://localhost/cgi-bin/temp.cgi
\t-> dbd_st_prepare MYSQL_VERSION_ID 50013, referer: http://localhost/cgi-bin/temp.cgi
\t>- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets RC -1, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_prepare, referer: http://localhost/cgi-bin/temp.cgi
<- prepare= DBI::st=HASH(0x16ce66c) at temp.cgi line 273, referer: http://localhost/cgi-bin/temp.cgi
-> execute for DBD::mysql::st (DBI::st=HASH(0x16ce66c)~0x1bd12cc 'status' 'rma_num' 'auth_id' 'vendor' 'part_num' 'status' '0') thr#233e34, referer: http://localhost/cgi-bin/temp.cgi
-> dbd_st_execute for 01b875f4, referer: http://localhost/cgi-bin/temp.cgi
\t>- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets RC -1, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
mysql_st_internal_execute MYSQL_VERSION_ID 50013, referer: http://localhost/cgi-bin/temp.cgi
Binding parameters: SELECT 'status','rma_num','auth_id','vendor','part_num' FROM rma_list WHERE ('status') = ('0'), referer: http://localhost/cgi-bin/temp.cgi
<- dbd_st_execute returning imp_sth->row_num 0, referer: http://localhost/cgi-bin/temp.cgi
<- execute= '0E0' at temp.cgi line 274, referer: http://localhost/cgi-bin/temp.cgi
-> trace for DBD::mysql::db (DBI::db=HASH(0x1b761a4)~0x1b76164 0) thr#233e34, referer: http://localhost/cgi-bin/temp.cgi
<- trace= ( 2 ) [1 items] at temp.cgi line 275, referer: http://localhost/cgi-bin/temp.cgi
[Tue Aug 18 18:35:26 2009] temp.cgi: 2 at C:/Documents and Settings/Administrator/My Documents/RMA Beta/cgi-bin/temp.cgi line 275., referer: http://localhost/cgi-bin/temp.cgi
-> DESTROY for DBD::mysql::st (DBI::st=HASH(0x1bd12cc)~INNER) thr#233e34, referer: http://localhost/cgi-bin/temp.cgi
, referer: http://localhost/cgi-bin/temp.cgi
--> dbd_st_finish, referer: http://localhost/cgi-bin/temp.cgi
\t>- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets RC -1, referer: http://localhost/cgi-bin/temp.cgi
\t<- dbd_st_free_result_sets, referer: http://localhost/cgi-bin/temp.cgi
, referer: http://localhost/cgi-bin/temp.cgi
<-- dbd_st_finish, referer: http://localhost/cgi-bin/temp.cgi
\tFreeing 7 parameters, bind 0 fbind 0, referer: http://localhost/cgi-bin/temp.cgi
<- DESTROY= undef at Carp.pm line 356, referer: http://localhost/cgi-bin/temp.cgi