Re: Annoying DB question

- Original Message - From: Bill Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:08 PM Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server

RE: Annoying DB question

Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question

Annoying DB question

I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats

Re: Annoying DB question

Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: nagraj [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 12:04 PM Subject: Re: Annoying DB question Hi Bill, It Seem

Re: Annoying DB question

Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Van Vliet, Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:50 AM Subject: RE: Annoying DB question The error you are getting suggests that your PK value is not unique

RE: Annoying DB question

PM To: CF-Talk Subject: Re: Annoying DB question Well the value is not unique becuase the key is on MEALID and MEALTIME which is like 1 = monday time = 1(breakfast) i just was reading about that serialize isoloation level and thought that should do the trick Bill Wheatley Senior Database

RE: Annoying DB question

] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having

RE: Annoying DB question

I thought you have to committ the transaction as well? I've had SQL problems using this syntax w/o a commit.. - j -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 2:39 PM To: CF-Talk Subject: RE: Annoying DB question try using a CFTRANSACTION

RE: Annoying DB question

try using a CFTRANSACTION like this... cftransaction cfquery name= EXECUTE sp_newmeal /cfquery /cftransaction It is my understanding that the CFTRANSACTION will single thread ALL requests to the specified DB (instead of just row-level or table-level locks).

RE: Annoying DB question

I thought you have to committ the transaction as well? I've had SQL problems using this syntax w/o a commit.. By default, if you simply have an opening and closing CFTRANSACTION tag, you don't need to explicitly commit - the CFTRANSACTION tag will do that all by itself. CF 4.5 introduced the

RE: Annoying DB question

] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:25 PM To: CF-Talk Subject: RE: Annoying DB question try using

Re: Annoying DB question

i do commit heres the transaction CREATE PROCEDURE sp_newmeal ( acctid varchar(20), visitnum int, delvisit int, tempMealCode1 varchar(6), tempMealCode2 varchar(6), tempMealCode3 varchar(6), tempMealCode4 varchar(6), tempMealCode5 varchar(6), tempMealCode6 varchar(6), tempMealCode7 varchar(6),

RE: Annoying DB question

that this is more efficient. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 3:54 PM To: CF-Talk Subject: Re: Annoying DB question i do commit heres