Jeff,
The DBA (damn them all to hell....) probably placed a constraint on one of
the DB columns. What this does is verify, using some PL-SQL script, that
the data you are putting into the column is of proper format and type.
i.e., you cannot put a string into an integer column. Anyway, you'll have
to find out from him what the particular constraint is and format your data
prior to updating or inserting into the DB.
On another note, I'd recommend staying away from CFUPDATE. It lacks the
granularity that most of us apprecieate when doing updates. In other words,
it's an all or nothing tag. If you used a regular old CFQUERY to do it you
could specify the columns to be updated and format/massage the data so that
it conforms to the constraints put on the database. Hope that this helps.
Jeff Garza
Webmaster,
Spectrum Astro, Inc.
[EMAIL PROTECTED]
-----Original Message-----
From: Jeff Fongemie
To: CF-Talk
Sent: 3/27/01 5:35 PM
Subject: Oracle CF error?
Hello cf-talk,
Anyone good with Oracle? A template that I thought was working now
generates this message:?
> Oracle Error Code = 2290
>
> ORA-02290: check constraint (VELO.SYS_C003412) violated
>
>
> The error occurred while processing an element with a general
> identifier of (CFUPDATE), occupying document position (71:3) to
> (71:90) in the template file
> D:\Inetpub\wwwroot\cycles\masterbib\newswork_RecordAction.cfm
my code on line 71:
<CFIF ParameterExists(Form.RecordID)>
<CFUPDATE dataSource="#application.DSN#"
tableName="NEWS" formFields="#Form.FieldList#">
<CFLOCATION
url="newswork_RecordView.cfm?RecordID=#Form.RecordID#">
<CFELSE>
What the heck is going on? I know the DBA was in there fiddling today,
could he have done anything? I see nothing wrong with the code. Does
anyone else????
Thanks, I'm so stuck!
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
