Never mind. It turns out that I just had some dirty data. There were some weird hex
characters in there. I didn't make the data, so don't ask me where they came from....
-----Original Message-----
From: Tim Johnson
Sent: Thu 4/15/2004 10:35 AM
To: [EMAIL PROTECTED]; Dbi-Users
Cc:
Subject: RE: Invalid character value for cast specification
No, but I tried taking away the placeholders and moving my variables into my
prepare statement, and this is what I got:
"Line 1: Incorrect syntax near 'Disty'."
Here is the field in question: 'Enhancement- Load Disty Accounts into
Production (Joe Bloe)'
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 10:26 AM
To: Tim Johnson
Subject: RE: Invalid character value for cast specification
Does this row contain an Irish name like O'Donnel?
--
Charles Knell
[EMAIL PROTECTED] - email
-----Original Message-----
From: Tim Johnson <[EMAIL PROTECTED]>
Sent: Thu, 15 Apr 2004 09:57:48 -0700
To: "Dbi-Users" <[EMAIL PROTECTED]>
Subject: Invalid character value for cast specification
I keep getting this error when I try to insert rows into my SQL Server
2000 DB. Is there any way to find out which character is causing the
problem? I have a feeling I'm doing something stupid, but I'm trying to
figure out what, and I think if I knew which character it was I would
know.
