updating files within the database based on dates compared
From: A L (perlcgi828_at_yahoo.com)
Date: 10/24/03
- Next message: Hardy Merrill: "Re: updating files within the database based on dates compared"
- Previous message: Bill Kurland: "Re: DBD and other perl module for AIX"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 24 Oct 2003 10:36:32 -0700 (PDT) To: dbi-users@perl.org
Dear dbi-users@perl.org,
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
- Next message: Hardy Merrill: "Re: updating files within the database based on dates compared"
- Previous message: Bill Kurland: "Re: DBD and other perl module for AIX"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
