Re: Not able to insert data in mysql

How did you make sure that your XPath expression actually matches nodes?

Consider making DBI die on errors:

my $dbh = DBI->connect($dsn,$username,$password, {RaiseError => 1, Pri
+ntError => 0 })
    or die "cannotconnect to database : $DBI::errstr";
[download]

Also, Basic debugging checklist.

Comment on Re: Not able to insert data in mysql Download Code

Replies are listed 'Best First'.
Re^2: Not able to insert data in mysql by ashishg0310 (Novice) on May 08, 2014 at 19:16 UTC
Included your mentioned line "{RaiseError => 1, PrintError => 0 })".. execution was successful..without any error..but still data not inserted..	[reply]
Re^2: Not able to insert data in mysql by Anonymous Monk on May 08, 2014 at 18:50 UTC
i think he as defined mentioned node in xml file.. And corion is right "how can you make sure that your XPath expression actually matches nodes?".. Corion is there any way to check that..even i want to know.??	[reply]
Re^3: Not able to insert data in mysql by Corion (Patriarch) on May 08, 2014 at 18:55 UTC
`foreach my $row($xp->findnodes('/main/MAIN')){ print "I matched a node.\n"; };` [download]	[reply] [d/l]