Yes, and it doesn't show anything but the error message. And the memberID is an identity field. The SQL2K equivalent of Access's autonumber field. If you try to enter anything in there yourself it barfs on you.
The SQL inside the <CFQUERY tag works fine when sent using Query Analyser. So the SQL itself is ok. I'd gladly look at the debug info but the page doesn't show any. Doesn't show anything but the error message. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 8:02 AM To: CF-Talk Subject: Re: CF Can't insertinto SQL2K ... any ideas? 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
