Re: CDATA Insert problem

2003-01-11 Thread Jesse Houwing
Webmaster wrote: Hi, Can anyone explain how this happened? I use Client vars and it looks like CF got confused and try to insert a duplicate record into the CDATA table. Has anyone else seen this? [Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert duplicate key row in object 'CDATA'

Re: CDATA Insert problem

2003-01-11 Thread cf-talk
PM Subject: Re: CDATA Insert problem You might want to check your CDATA and CGLOBAL tables and make sure you don't have a ton of records in there. It has been my experience that the CDATA and CGLOBAL tables DO NOT get purged like they're supposed to. For example, if you tell the CF

Re: CDATA Insert problem

2003-01-11 Thread Kwang Suh
Yeah, I've had the same problem as well. We ended up creating a SQL Server job that nuked old records instead. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 11, 2003 10:10 PM Subject: Re: CDATA Insert problem I should have been more

Re: CDATA Insert problem

2003-01-11 Thread cf-talk
. Something to keep in mind depending on how you're using your client variables. -Novak - Original Message - From: Webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, January 11, 2003 8:13 AM Subject: CDATA Insert problem Hi, Can anyone explain how this happened? I use

Re: CDATA Insert problem

2003-01-11 Thread Webmaster
[EMAIL PROTECTED] Sent: Sunday, January 12, 2003 12:39 AM Subject: Re: CDATA Insert problem Yeah, I've had the same problem as well. We ended up creating a SQL Server job that nuked old records instead. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent