Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: YankeePride13
- Order by date
-
PERL DBI question
my $update_pcm = $dbh->prepare(qq{ UPDATE PRODUCT_CATEGORY_MEMBER SET product_Category_Id = ?, FROM_DATE = NOW() WHERE PRODUCT_ID = ? AND PRODUCT_CATEGORY_ID = ? }); my $update_product = $dbh->prepare(qq{ UPDATE PRODUCT SET primary_product_Category_Id = ? WHERE PRODUCT_ID = ? AND...- YankeePride13
- Post #6
- Forum: Perl
-
PERL DBI question
my $update_pcm = $dbh->prepare(qq{ UPDATE PRODUCT_CATEGORY_MEMBER SET product_Category_Id = ?, FROM_DATE = NOW() WHERE PRODUCT_ID = ? AND PRODUCT_CATEGORY_ID = ? }); my $update_product = $dbh->prepare(qq{ UPDATE PRODUCT SET primary_product_Category_Id = ? WHERE PRODUCT_ID IN ? AND...- YankeePride13
- Post #5
- Forum: Perl
-
PERL DBI question
for reasons out of my control i can't post the whole code, but i'll post the queries that the perl script makes and ill find you in one how it works my $update_pcm = $dbh->prepare(qq{ UPDATE PRODUCT_CATEGORY_MEMBER SET product_Category_Id = ?, FROM_DATE IN NOW() WHERE PRODUCT_ID = ? AND...- YankeePride13
- Post #4
- Forum: Perl
-
PERL DBI question
Hello, currently I'm trying to use PERL to update my web sites database with new info. I am trying to update large numbers of rows, reading information from a text file, and it fails every time stating that I cannot update or insert a child row as foreign key constraints fail (which is something...- YankeePride13
- Thread
- Replies: 6
- Forum: Perl
