CFF Knowledge Base
CFF KB has 208 listed Articles with 387,204 page views
Search KB Articles
Microsoft Store
Finance - Excel Home and Student 2010
$119.99
 
For school and household projects
Easy organization added to your household routine
Ready-to-use templates
Finance - Excel Home and Student 20

$119.99
Clicks = 125
Barnes and Noble
ASP.NET - ASP.NET MVC 1.0 Test Driven Development Problem - Design - Solution
ASP.NET - ASP.NET MVC 1.0 Test Driv

35.13
Clicks = 248
Barnes and Noble
Music - Morbid Angel - Abominations of Desolation (1991)
Music - Morbid Angel - Abominatio

$18.04
Clicks = 117
Barnes and Noble
Music - Christian Thielemann - Orff: Carmina Burana
Music - Christian Thielemann - Or

$7.59
Clicks = 94
Barnes and Noble
Music - Purity Ring Shrines
Music - Purity Ring Shrines

$14.24
Clicks = 140

CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)

ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation

Article ID: 11 - Date Created Tuesday, September 28, 2010 - This Article Has been Viewed 7884 times.
Article was last updated on: Wednesday, November 17, 2010

ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation

CFF Knowledge Base - Share on MySpace CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
Share With Friends (Updated 6-8-2010)
When you are trying to query your table, your QueryString may not be properly defined. (or) if you are sending to many characters to your Parameter with a set Character Length.


Details
If your QueryString is not properly defined or misspelled, you will receive this error

 
ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
rss.asp, line 8


(or) Scenaria #2:
If you are trying to send to many characters to your Parameterized Query.

 
ADODB.Command (0x800A0D5D)
Application uses a value of the wrong type for the current operation.
Inserts.asp, line 290


Recreate Issue
In the below SQL Query, we are getting our ID from the QueryString of rss.


<%
rss = ProtectSQL(request.QueryString("rss"))
Set sqlRSS = Server.CreateObject("ADODB.Command")
sqlRSS.ActiveConnection=objConn
sqlRSS.Prepared = true
sqlRSS.commandtext="Select id, RSSFeed FROM MyTable WHERE id=? AND RSSFeed=1"
sqlRSS.Parameters.Append sqlRSS.CreateParameter("@id", adInteger, adParamInput, , rss)
set rsRSS = sqlRSS.execute
%>



We instead Query our string as:
page.asp?rsss=1

Scenaria #2:

<%

Set sqlFFiltnd = CreateObject("ADODB.Command")
sqlFFiltnd.ActiveConnection=objConn
sqlFFiltnd.commandtext="update DTable set DFolder='NotDefault' where id=? and PicsFolder=?"
sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@id", 3, 1, , MineID)
sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@PFolder", 200, 1, 25, strFolderName)
sqlFFiltnd.execute

%>


In the above code, are 5th line which is our PFolder, has a character count of 25.
This will cause this error if you have over 25 characters to go into the field.


Resolve Issue
To correctly call our Query, we need to make sure that our QueryString matches our Variable that we define within our code.

page.asp?rss=1
Will get our records and display them back to us properly.


<%
rss = ProtectSQL(request.QueryString("rss"))
Set sqlRSS = Server.CreateObject("ADODB.Command")
sqlRSS.ActiveConnection=objConn
sqlRSS.Prepared = true
sqlRSS.commandtext="Select id, RSSFeed FROM MyTable WHERE id=? AND RSSFeed=1"
sqlRSS.Parameters.Append sqlRSS.CreateParameter("@id", adInteger, adParamInput, , rss)
set rsRSS = sqlRSS.execute
%>



Scenaria #2:

<%

Set sqlFFiltnd = CreateObject("ADODB.Command")
sqlFFiltnd.ActiveConnection=objConn
sqlFFiltnd.commandtext="update DTable set DFolder='NotDefault' where id=? and PicsFolder=?"
sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@id", 3, 1, , MineID)
sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@PFolder", 200, 1, 75, strFolderName)
sqlFFiltnd.execute

%>


On line #5, we have changed the Character count from 25 allowed Characters to 75
This gives us more room to allow for special characters, especially if you are using a function to converts characters over to hex or so forth.