Dear [EMAIL PROTECTED],
Thank you for your help. It is clear to me that this is a forum to share ideas and no
one has to answer any of the questions. After reading
http://www.catb.org/~esr/faqs/smart-questions.html, one can't help feeling that a
question was deemed stupid when there is no reply, and that I am a luser, which I
detest to think so after giving much effort to acquire better programming skill. But,
to continue the attitude that is valued among the world of hackers, no offense was
taken, if someone thought so. And, my problem was solved. Instead of doing the
following:
if ($result){
my $update_table1=$dbh1->prepare(
"UPDATE table1
SET retrieval_date=?
WHERE idnum=?");
$update_table->execute($result,$access);
}
to designate the execute statement to go through all the rows of database, the excute
statement was empty, which resulted in no change for the rows that needed to be
changed. As expected, it was a simple solution. But, a lesson was learned from this
question. In the future, my writing needs to be more clear for others to understand
what is being asked. Now, next step to better programming! To that end, I thank you
again for your patience and tolerance.
Sincerely,
Angela
---------------------------------
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
