comparing data base element with array element

[getteddy]

hi i am working on array , i am facing a problem in comparing data base element with array element


if not (objrs("namephase")=("despArray(ctr,0)+despArray(c tr,3)")) then

or

If (StrComp(objRS("UserName")),("despArray(ctr,0)+des pArray(ctr,3)")) , vbTextCompare) = 0) Then

please help me

[jhardman]

what types of problems is this giving you? Does the logic always return false?

Jared

[markrawlingson]

If i'm understanding what you're trying to do correctly.. I wrote a function for this purpose not too long ago.

    Function IsLegitimate(aTemp,sTerm)
        For i = 0 To UBound(aTemp)
            If InStr(aTemp(i), sTerm) > 0 Then
                IsLegitimate = True
                Exit For
            Else
                IsLegitimate = False
            End If
        Next
    End Function
 
 

called like this..

If IsLegitimate(Split("value1 value2 value3 value4 value5"), rs("whateverfield")) then
'the function found the value of the field from the database in your array
Else
'the array does not contain the value of the field from the database
end if