Re: UPDATE statements causing me grief!

"Greg Sabino Mullane" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> my $dbh = DBI->connect($SQLDS,$DBUSER,$DBPASS);

It's always a good idea to explictly set AutoConnect here. 
I also like to set PrintError=>0 and RaiseError=>1

> So, for some reason, the update never happens, and I get no errors.

Try changing it to a SELECT statement and see what comes back.

- -- 
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201110070943
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk6PAesACgkQvJuQZxSWSsgDYQCg5K9uqthUP1+5WViFT6JpUdeG
KMsAnAspjf+A8nVov+8AZM9wFSyoPIHs
=jbhS
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.