CFF Knowledge Base
CFF KB has 208 listed Articles with 408,090 page views
Search KB Articles
VioSoftware.com
System Utilities - Symantec Backup Exec 2012 V-Ray Edition 8+ Cores OLP Renewal (Basic Maintenance)
System Utilities - Symantec Backup Exec 2012

$520.99
Clicks = 132
Microsoft Store
Mail & Web Servers - Windows Small Business Server 2011 Standard (20-User Client Access License)
$1,447.00
Includes 20 additional user client access licenses
Affordable, all-in-one business solution
Increased data and network protection
Mail & Web Servers - Windows Small Business Se

$1,447.00
Clicks = 151
Barnes and Noble
Music - Gary Moore - Essential Montreux (2009)
Music - Gary Moore - Essential Mo

$39.45
Clicks = 114
Barnes and Noble
KISS - Double Platinum
KISS - Double Platinum

Online Price: $15.80
Clicks = 239
Microsoft Store
Printing - Avanquest Hallmark Card Studio Deluxe 2012
$49.99
 
Over 12,00 Hallmark greeting cards and projects
Make photo cards, calendars, 3D cards
Easy Facebook integration
Printing - Avanquest Hallmark Card S

$49.99
Clicks = 142

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