On 3/31/02, Mike Kear penned: >My server's using CF5 and SQL2K. I can insert into a table using the query >analyser, and I can have CF query the datasource no problem. But when it >goes to insert into the database, using the same SQL I used in the query >analyser, it hiccups. I get a error messages as follows: > >[quote] >ODBC Error Code = 23000 (Integrity constraint violation) >[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL >into column 'memberid', table 'btcmsa.dbo.Newsletter'; column does not allow >nulls. INSERT fails. >The error occurred while processing an element with a general identifier of >(CFQUERY), occupying document position (9:1) to (9:99). > [/quote]
Well, it SAYS you aren't entering anything into memberid. Do you have debugging turned on to where you can see that you're actually trying to insert something into memberid? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
