Re: UPDATE statements causing me grief!

On Oct 7, 6:43 am, [email protected] ("Greg Sabino Mullane") wrote:
> -----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 Corporationhttp://www.endpoint.com/
> PGP Key: 0x14964AC8 201110070943http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iEYEAREDAAYFAk6PAesACgkQvJuQZxSWSsgDYQCg5K9uqthUP1+5WViFT6JpUdeG
> KMsAnAspjf+A8nVov+8AZM9wFSyoPIHs
> =jbhS
> -----END PGP SIGNATURE-----

I did, and the select statement works.