473,388 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

How to fix this error application uses wrong type of value ?

147 100+
Hi,
I don't know why i am getting this error.

Please see my coding part, where i am facing this following error

Private pbat As New ADODB.Parameter

'in form load
With pbat
.Direction = adParamInput
.Type = adVarChar
.Size = 4
End With

'saving part
pbat = Trim(Text1.Text) & "%" -here i faced the following error


How to rectify this error ?
Jun 9 '11 #1
3 1329
debasisdas
8,127 Expert 4TB
to which property of the object you are assigning that string ?
Jun 9 '11 #2
santhanalakshmi
147 100+
can't understand your question....please explain with explain
Jun 9 '11 #3
Killer42
8,435 Expert 8TB
I'm guessing here, as I haven't played with ADO stuff in years, and don't have much context to work with here. Anyway...

It looks to me as though pbat is meant to be of type ADODB.Parameter, but you're trying to assign a simple string value to it.

Assuming the variable scope is correct (you're in the same form where it was defined as Private?) then perhaps you meant to refer to some specific attribute of pbat (pbat.Name or pbat.Value for example).

Reasonable?
Jun 10 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Richard Davies | last post by:
Hi I have a ASP and SQL Server website which uses a couple of Stored Procedures during the Shopping Cart process. 1 inserts the Customer information into a table and the next inserts the Payment...
2
by: Gargamel | last post by:
Hiya. I've taken over the development of a web app written in ASP. It's not very well coded. In the live environment it's fine, but on my local machine it falls over whenever it tries to pass...
7
by: Tim Gaunt | last post by:
Hi, I'm hoping that someone will be able to help me with this one, I'm developing an application which basically inserts a load of data into the database ready for validation at a later date, I...
15
by: Erica | last post by:
I'm getting the following error: ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /shop/results.asp, line...
1
by: Jack | last post by:
Hi, I am trying to add a new record to a main page. This page is the processing page to a form. However, I am getting the following error message: Error Type: ADODB.Recordset (0x800A0BB9)...
2
by: Babs | last post by:
Hey, I have an ASP.Net web application. I created a new subfolder within this application. The problem is that I cannot access the web pages within this subfolder from my application. I get the...
1
by: dotNetDave | last post by:
I keep getting the following error on one of my web service pages: Parser Error Parser Error Message: Could not create type 'SyPixx.Web.ClearService.ConfigureAlarms'. Source Error: Line 1: ...
5
by: Sheldon | last post by:
Hi Everyone, I have defined a function: struct Transient arrFromHdfNode(HL_NodeList *nodelist, struct Transient retv); and in the code: struct Transient arrFromHdfNode(HL_NodeList...
1
by: thecubemonkey | last post by:
Hi everyone, I'm getting the following error: ADODB.Recordset error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another....
3
by: =?Utf-8?B?SGVyYg==?= | last post by:
I've developed an ASP.NET website that runs fine on my local WinXP IIS and on my server's IIS, both are IIS6.0 The site uses a master page that has the following declaration: <%@ Master...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.