Your error means something like this: You have 2 tables. 1 has customer
info in it with a primary key. The second has order info based on the
primary key from the customer table. You delete the customer, but leave the
orders in the table. You just blew your database integrety to pieces
because when you pull up the orders for that customer and go to grab their
name from the contact table, they aren't there. That's bad ..
And so was that example .. but you get the idea.
It seams you kinda have the problem with inserting instead of deleteing.
Maybe if you could post all of the source for the queries on this page and
how they interract with one another, I would understand what's going on
better..
Todd Ashworth
----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 5:36 PM
Subject: RE: INSERT into error....
> --=====================_2669739==_.ALT
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> ok.. after hacking the SQL insert statement to bits until i just had one
> column being inserted i got this error:
>
> Im not sure what it means.... The "login" and "JobInfo" tables do have
a
> relationship, but not with the column JobNum.
>
>
>
>
>
> Error Occurred While Processing Request
> Error Diagnostic InformationODBC Error Code = 23000 (Integrity constraint
> violation)
> [Microsoft][ODBC Microsoft Access Driver] You cannot add or change a
record
> because a related record is required in table 'login'.
>
> SQL = "INSERT INTO JobInfo(JobNum) VALUES( 6732 )"
>
> Data Source = "CJM.mdb" The error occurred while processing an element
with
> a general identifier of (CFQUERY), occupying document position (76:1) to
> (76:60) in the template file
> D:\Web\Capitol1interface\chad\uploadaction.cfm.Date/Time: 11/27/00
17:37:32
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
> Remote Address: 209.115.116.102
> HTTP Referer: http://209.115.116.151/chad/upload.cfm?name=chad
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
