CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner:
Perl Script to search the database

 



alkuhs
New User

Sep 27, 2009, 5:21 PM

Post #1 of 2 (338 views)
Perl Script to search the database Can't Post

Hi all,

Here is my problem statement: I have 2 database tables. I need to fetch an element(for eg: domain) from table 1, compare it with all the values of the similar column in table 2, and if the domain is not present, update table 2 with the domain.

I have to scan last 3 months of entries for this. Table 2 should update only if domain is not present for the last 3 months. But it should get updated if the domain was present before 3 months.

Is there any efficient technique to do this? Any modules that I could take help of to make it more efficient?


FishMonger
Veteran / Moderator

Sep 27, 2009, 8:17 PM

Post #2 of 2 (336 views)
Re: [alkuhs] Perl Script to search the database [In reply to] Can't Post

You need to use the DBI module and the proper DBD:: module for your database.

http://search.cpan.org/~timb/DBI-1.609/DBI.pm

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives