How is the primary key set up, if the this field is using the Auto number for Access or the Identity in SQL then they both will not allow this insertion however if it is a normal int field then the only problem would be if that number already exists.
-----Original Message----- From: Cody Estes [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 2:18 PM To: CF-Talk Subject: RE: Foreign keys Why not rename your date field to something else instead of "date". Isn't that a reserved word? Cody ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
