CFF Knowledge Base
CFF KB has 207 listed Articles with 253,851 page views
Search KB Articles
Barnes and Noble
Wednesday 13 - Fang Bang [Explicit Lyrics]
Wednesday 13 - Fang Bang [Explicit Lyric

Online Price: $12.26
Clicks = 201
VioSoftware.com
Home & Office - Microsoft Windows 7 Home Premium SP1 OEM 32-bit 30-Pack
Home & Office - Microsoft Windows 7 Home

$3,307.69
Clicks = 77
VioSoftware.com
Internet Security - Trend Micro Worry-Free Business Security Standard Renewal 251+ Users
Internet Security - Trend Micro Worry-Free Bu

$14.48
Clicks = 80
Microsoft Store
Computers - Samsung Series 7 700Z7C-S01
$1,499.00
Out of stock 
Screen size: 17.3 inches
Hard drive size: 1 TB
Weight: 6.26 pounds
**Students: Purchase this PC and get a Xbox 360 4 GB Console free
Computers - Samsung Series 7 700Z7C-S

$1,499.00
Clicks = 101
Barnes and Noble
Music - You Me at Six - Sinners Never Sleep (2011)
Music - You Me at Six - Sinners N

$10.23
Clicks = 68

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.
CFF Knowledge Base Article - 11 - ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation

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 5433 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.