[thelist] datatype conversion error

Joshua Olson joshua at alphashop.net
Fri Jun 29 11:20:34 CDT 2001


I would be inclined to think you might have a data issue.  Here are a couple
of questions:

Is one of the fields that you are expecting to be a numeric type really a
varchar?
If you try to use CAST on the string 'abc' does it throw this particular
error?  If so, then one of the database records may have such data.
Can you use CAST on a NULL value?  If not, which error does it throw?

I'd say to check your base tables to ensure the field types are what you
expect--varchar, numeric, etc.

-joshua

----- Original Message -----
From: "Warden, Matt" <mwarden at mattwarden.com>
Subject: [thelist] datatype conversion error


: thelist,
:
: I'm having a lot of trouble with a stored procedure I wrote for MS SQL
: Server 7. Specifically, I'm having problems with the "getting it to work"
: part, which is arguably the most important part. I'm getting the following
: error whether I call the stored proc from ASP or directly in a database
SQL
: window:
:
: Microsoft OLE DB Provider for SQL Server error '80040e07'
:





More information about the thelist mailing list