You need to cheat if you want to use ListView to do this...
Use a TwoLinesLayout and a TwoLinesAndBitmap and then not have a bitmap... You can give the TwoLinesLayout Yellow colouring and the Bitmap ones Red for instance.
So in your code, something like this (untested)
Code:
LVDb.Clear
LVDb.TwoLinesLayout.Label.TextSize=20
LVDb.TwoLinesLayout.Label.TextColor=Colors.Yellow
LVDb.TwoLinesLayout.secondLabel.TextSize=16
LVDb.TwoLinesLayout.secondLabel.TextColor=Colors.Cyan
cursor2 = SQL2.ExecQuery(Query Text...")
For i = 0To cursor2.RowCount - 1
cursor2.Position = i
If cursor2.Getstring2(3)<>0ThenLog("1")
LVDb.TwoLinesLayout.Label.TextColor=Colors.Yellow
LVDb.AddTwoLines2("Text to be added...")
Else if cursor2.Getstring2(3)=0ThenLog("2")
LVDb.TwoLinesAndBitmap.Label.TextColor=Colors.red
LVDb.AddTwoLinesAndBitmap("Text to be added...")
End If
Next
cursor2.close