Re: Disabling ORA error



On Mar 23, 3:59 pm, "MattJ83" <mattjo...@xxxxxxxxxxxxx> wrote:
I am running an "insert or update" sql statement.

If the field already exists in the db - it doesn't insert but updates
the field. This is what the script should do.

The problem is that in carrying out the statement - the DBI throws
back a "unique contraint error" (a primary key makes sure the field
isn't replicated in the db).

I know i can set up the statement in a if/else statement - but i was
wondering if i could cheat in effect and just get rid of the error
messages that are brought back on the command prompt.

Thanks,

Ok - so i feel like a newbie now.

$dbHandle->{PrintError} = 0;
$dbHandle->{RaiseError} = 0;

This solves the problem. I just could'nt think right!

.



Relevant Pages

  • Re: Wireless Zero Configuration Service Problem
    ... This generally has to do with display drivers. ... or ran the MS updates to do so, try a rollback via the Device Manager. ... To use the VBS Files: Download .vbs file and save it to your hard drive (you ... You will be prompted when the script is done. ...
    (microsoft.public.windowsxp.general)
  • Re: Private Mirror/Repository
    ... http://www.stearns.org/yum-pull/ has the script and a howto ... "updates-released" is the same as "updates" in ... I don't use all the distributions supported by the script, so I don't always know the compatibility tricks such as "Centos 3.4 is fully compatible with RHEL 3", allowing yum-pull to pull down any rhel3 repositories for centos 3.4 as well. ... If none of those install cleanly, you could recompile the SPRM on your system, or simply not install it at all. ...
    (Fedora)
  • Re: centralized administration for windows 98 updates
    ... Hmmm...a login script. ... to go out and check for the most current updates and download the necessary ... > still visiting every workstation to configure it to log into the domain so ... > the Windows XP method hsprader refers to. ...
    (microsoft.public.security)
  • nsupdate(8) rc.d Script
    ... Subject: nsupdaterc.d Script ... As I was setting up DNS for IPv6 on a test network, ... And the script is not optimized to do the updates in the ...
    (freebsd-current)
  • Re: Windows Update 7 Internet Explorer
    ... The command would run from a command prompt, but the script does it. ... You are probably blocked from the updates by your antivirus app. ... >> marfers notes for windows xp ...
    (microsoft.public.windowsxp.help_and_support)