[RESOLVED] problem finding listview first column value

[tony007]

Hi all I am trying to use the following code to find a value in listview first column cell but it keeps failing to find.The value exist but it says it didn't find the value. The value in listview first column is an IP value. I be happy if some one tell me how to make this work .Thanks

Set lvwitem = Listview1.FindItem(objNode.selectSingleNode("ip").Text)
        If lvwitem Is Nothing Then
           MsgBox "Couldn't be found"
          Set lvwitem = Listview1.ListItems.Add(, , objNode.selectSingleNode("ip").Text)
                  End If

[Hack]

To get the value of the first column do

Msgbox ListView1.SelectedItems.Text

[tony007]

Hack i want to use Listview1.FindItem to check if a perticuler xml item already exist on first column of listivew or not. But it keeps telling me couldn't find it while i see it on listview!!! I want to check if it exist then i don't need to update it.But now it can't find the item and keeps updating it for no reason!!

I used MsgBox objNode.selectSingleNode("ip").Text and i saw it has the correct value but Listview1.FindItem always gets null value!!!


I tried using:

MsgBox lvwItem

I get the following error:

Run-tme error 91:

object variable or with block variable not set

pointing at :

MsgBox lvwItem

also i tried using:

MsgBox lvwItem = ListView1.FindItem(objNode.selectSingleNode("ip").Text)

i get this error:

Run-tme error 91:

object variable or with block variable not set

pointng at :

MsgBox lvwItem = ListView1.FindItem(objNode.selectSingleNode("ip").Text)

could any one tell me how to fix these erros so i debug the program corectly?Thanks in advance:-))

[MartinLiss]

Does objNode.selectSingleNode("ip").Text actually return the value you expect?

[tony007]

martin thanks for your reply. Yes it returns the correct value. I check it via :

MsgBox objNode.selectSingleNode("ip").Text

objNode.selectSingleNode("ip").Text is an IP number not text.I still don't know why Listview1.FindItem returns nothing!!!

[MartinLiss]

Try

Set lvwitem = Listview1.FindItem(objNode.selectSingleNode("ip").Text, , lvwPartial)

and if that doesn't work try

Dim strIP As String
strIP = objNode.selectSingleNode("ip").Text
Set lvwitem = Listview1.FindItem(strIP, , lvwPartial)

[tony007]

I tried both of them it both failed to find the ip!!!

first one:

Set lvwItem = ListView1.FindItem(objNode.selectSingleNode("ip").Text, lvwPartial)

for second one it failed to find it again!!

Dim strIP As String
strIP = objNode.selectSingleNode("ip").Text
'MsgBox strIP
Set lvwItem = ListView1.FindItem(strIP, lvwPartial)

i have feeling that Listview1.FindItem(...) is not looking at the first coloum of listview!! Because the value passsed to it is corret value to look for but it fails to find it!!

[MartinLiss]

Please note that my example was wrong (yours was too). There should be THREE commas and not two as in my examples or one as in yours.

Set lvwItem = ListView1.FindItem(objNode.selectSingleNode("ip").Text, , , lvwPartial)

And FindItem definately looks for the ListItem object's Text property.

[tony007]

Please note that my example was wrong (yours was too). There should be THREE commas and not two as in my examples or one as in yours.

Set lvwItem = ListView1.FindItem(objNode.selectSingleNode("ip").Text, , , lvwPartial)

And FindItem definately looks for the ListItem object's Text property.

Martin i tried again .It keeps failing again. It seems finditem can't find ip value!!Because ip has dots and it is integer. May be that is the problem!!

[MartinLiss]

Martin i tried again .It keeps failing again. It seems finditem can't find ip value!!Because ip has dots and it is integer. May be that is the problem!!

Try it (again with 3 commas) but use

Left$(objNode.selectSingleNode("ip").Text, 2)

and see if that finds anything.

[tony007]

:-(( not workin again:

Set lvwItem = ListView1.FindItem(Left$(objNode.selectSingleNode("ip").Text, 2), , , lvwPartial)

[MartinLiss]

Can you attach a zip file containing your project or a sample project that reproduces the problem?

[tony007]

i think i need some rest. lol. I fixed it. Problem was that i was clearing the listview before reaching finditem that is why it was failing to findd it!! Mart many thank for helping me :-))