Type mistmatch error

ASP Free Forums Sponsor:

September 7th, 2007, 10:13 AM

jonyBravo

Contributing User

Join Date: Jul 2007

Posts: 112

Time spent in forums: 1 Day 22 h 40 m 14 sec
Reputation Power: 2

Type mistmatch error

I've got the following statment in my application:

Do While Not rs.EOF
LstPars.AddItem (rs.Fields("NNI").Value)
LstPars.ItemData(LstPars.NewIndex) = rs.Fields("BT_Exchange").Value
rs.MoveNext
Loop

The problem is it saying type mistmatch on the line in red. Is there anyone that can tell me what is wrong there?

Thansk

__________________
If this help you please show your gratitude by adding reputation points.

Thanks

JonyBravo

September 7th, 2007, 10:28 AM

zanna5910

Contributing User

Join Date: Sep 2005

Posts: 744

Time spent in forums: 4 Days 20 h 30 m 3 sec
Reputation Power: 49

Your comparing an object to a string. Call the objects ToString function

LstPars.ItemData(LstPars.NewIndex).ToString() = rs.Fields("BT_Exchange").Value

__________________
I take donations in increments of $100.

September 18th, 2007, 12:14 PM

Shadow Wizard

Moderator From Beyond

ASP Free God 46th Plane (27500 - 27999 posts)

Join Date: Sep 2004

Location: Israel

Posts: 27,932

Folding Points: 391471 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Months 2 Weeks 12 h 17 m 53 sec
Reputation Power: 2002

in case this isn't solved yet...

what is LstPars?
is this VB6 or VB.NET?

__________________

Visit The Windows Scripting Guru

Viewing: ASP Free Forums > Programming > Visual Basic Programming > Type mistmatch error

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

More Free IT White Papers!