Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   Error Type:0x80040E57 and ADODB.Command error '800a0d5d' (http://www.velocityreviews.com/forums/t800026-error-type-0x80040e57-and-adodb-command-error-800a0d5d.html)

ern edwar 11-15-2005 06:50 PM

Error Type:0x80040E57 and ADODB.Command error '800a0d5d'
 

Hello,

i have come to the conclusion i have problem in one of two areas and ive
spent two days tring to figure it out.

First the error i get is below with this code:

ParamList(1) = reportDate
ParamList(0) = month(reportDate) & "/1/" & Year(reportDate)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
[Oracle][ODBC][Rdb]%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
runtime -SQL-F-DATCONERR, Data conversion error for string '1109-20-05'
-COSI-F-IVTIME, invalid date or time
/PICKLER/common/connect.asp, line 201

So i though oh in my code i have to prepend the pound sign in this part
of the code below:


ParamList(1) = "#" & reportDate
ParamList(0) = "#" & month(reportDate) & "/1/" & Year(reportDate)

But now i get an error:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/PICKLER/common/connect.asp, line 195

The code on this line 195 is:
Cmd.Parameters.Append Cmd.CreateParameter(TempName, TempType,
adParamInput, 50, TempParam)

What did i do wrong?

Any help would be greatly appeciated!!




*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT. The time now is 11:31 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.