Ah, nevermind,
I needed to add a
$dbHandle->commit(); for the changes to take effect.
Also, Does anybody know if there is a way to retrieve the auto incremented ID in the same SQL statement? It would help cut down the over head in my script.
User Profile
Collapse
-
MS SQL + Perl = Phantom rows
Hi, I just posted this in the MS SQL Section, but maybe my problem is rooted in Perl, so it's more appropriate to post here instead (sorry for the double post)
I'm writing a PERL script to access and insert rows into a Microsoft SQL. i'm using MS SQL Server Management Studio Express (2005) to architect tables and queries.
I've inserted two records into my "Pools" table
One from MS SQL Manager... -
mSQL + Perl = Phantom rows
I'm writing a PERL script to access and insert rows into a Microsoft SQL. i'm using MS SQL Server Management Studio Express (2005) to architect tables and queries.
I've inserted two records into my "Pools" table
One from MS SQL Manager as a test, and another from my PERL script.
The one inserted by MS SQL Manager shows up everytime. The row from my PERL script doesn't show up on MS SQL Manager and...
No activity results to display
Show More
Leave a comment: