RE: Can anyone spot a problem with this query?

2006-01-25 Thread Rick Faircloth
Unbelievable... Thanks, Rodney! Rick > -Original Message- > From: Rodney Enke [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 25, 2006 6:10 PM > To: CF-Talk > Subject: Re: Can anyone spot a problem with this query? > > > You're missing the closing p

Re: Can anyone spot a problem with this query?

2006-01-25 Thread Rodney Enke
You're missing the closing parenthesis ')' after the last queryparam. - Rod On 1/25/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > MySQL is giving me an "ODBC Error Code = 23000 (Integrity > contraint violation) > and says I have an error in my SQL syntax...I can't find > it...data being sent

RE: Can anyone spot a problem with this query?

2006-01-25 Thread Rick Faircloth
-Original Message- > From: Adkins, Randy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 25, 2006 4:27 PM > To: CF-Talk > Subject: RE: Can anyone spot a problem with this query? > > > Constraint Violation beans that there would be more than one records > with the same

RE: Can anyone spot a problem with this query?

2006-01-25 Thread Adkins, Randy
Constraint Violation beans that there would be more than one records with the same Set of values. Check your Primary Keys and Indexes. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 4:17 PM To: CF-Talk Subject: Can anyone spot a probl