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.Knowledge Base
- Breadrumbs:
Microsoft VBScript runtime error '800a01a8' Object required: 'cmd'
- Article ID:
133 - Date Created
Tuesday, May 10, 2011 - Last Updated
Tuesday, May 10, 2011 - This Article Has been Viewed
2283 times - Short Desc
When you write your SQL Statement using Parameters, you may sometimes misplace a character inplace another another character. - Details
When you write your SQL Statement with Patameters, you may sometimes add in a characters inplace of another character. This usually happens when the coder is in a rush, and then this does accure, you will receive the following error.
Microsoft VBScript runtime error '800a01a8'
Object required: 'cmd'
/header.asp, line 340 - Recreate Issue
To recreate this issue.
<%
cmd=commandtext-"Select column from table"
%>
In the above, you can see where we have an = between the cmd and commandtext - Resolve Issue
To resolve this issue.
<%
cmd.commandtext-"Select column from table"
%>
In the above, you can see we have the period placed between, and there for, our code will compile.
Share With Friends (Updated 6-8-2010)
Recent Articles
All Topics
- Coming Soon - Knowledge Exchange
Trending Articles
- Microsoft VBScript runtime error '800a0046' Permission denied FileSystemObject 24695
- Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. or The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. 21297
- ADODB.Parameters error '800a0e7c' Parameter object is improperly defined 19544
- After Effects warning: Audio conforming failed for the following file .cfa. Perhaps due to disk space 17785
- The backup set holds a backup of a database other than the existing 16826