RE: Truncated error

2005-11-14 Thread Mike | NZSolutions Ltd
Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 November 2005 8:59 a.m. To: CF-Talk Subject: Re: Truncated error Mike, I wouldn't trust the line number of the error. In my experience, ColdFusion often reports a line number equal to one or two lines ab

Re: Truncated error

2005-11-14 Thread Steve Bryant
Mike, I wouldn't trust the line number of the error. In my experience, ColdFusion often reports a line number equal to one or two lines above . ColdFusion just compiles some SQL and sends it to SQL Server. Since SQL Server doesn't specify which field is causing the problem, ColdFusion doesn't k

RE: Truncated error

2005-11-14 Thread Mike | NZSolutions Ltd
Hmmm, that is weird this is the first time I have seen the error occur - up to today orders have been coming through fine ? mike -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 November 2005 9:48 a.m. To: CF-Talk Subject: Re: Truncated error my guess

Re: Truncated error

2005-11-14 Thread Marlon Moyer
my guess would be that it's trying to pass "true" or "false" as a string and not a 0 or 1. You might try to something like Then use #updates# in your query. On 11/14/05, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: > (I made this question a bit shorter !!) > > Hi guys, > > I am getting a