Comparing an array value to a recordset value

transparent · Aug 30, 2002

if arr_department_id(i) = obj_RSet("department_id&quot

then ....

however it doesn't seem to detect when the values do match.

I thought this might be due to the fact that the value in the array may be considered a string but

cint(arr_department_id(i)) doesn't seem to work (i get an error)

I've also tried trimming both values - this didn't help either.

Does naybody have a solution to this problem??

Geee · Aug 30, 2002

The first thing I would do is check exactly what is contained in each variable to see if they are compatible to be compared. The second thing I would say is to put the error you get in this thread to give us a chance of helping you

. -GTM Consult, Home of USITE-
-=

http://www.gtmconsult.co.uk=-

transparent · Aug 30, 2002

The array was created using the split command upon a string ie 2,4,5,6,7

The data in obj_RSet("department_id&quot

is of type int.

The error was:

Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'cint'

corresponding to:

if cint(arr_department_id(i)) = obj_RSet("department_id&quot

then.....

Cheers

Geee · Aug 30, 2002

Hmm. Whats the error generated when you use just:

if cint(arr_department_id(i)) = obj_RSet("department_id&quot

then..... ?

Can you post the full code here?

-GTM Consult, Home of USITE-
-=

http://www.gtmconsult.co.uk=-

FesterSXS · Aug 30, 2002

Have you tried forcing both values to Int??

Code:

If CInt(arr_department_id(i)) = CInt(obj_RSet(&quot;department_id&quot;)) Then.....

Tony

http://www.phoenix-paints.co.uk/portfolio

transparent · Aug 30, 2002

I have included the code apart from the database connectivity stuff which is tried and tested.

The error corresponds to ' cint(arr_department_members(i)) '

<%

str_department_members = request.form("str_department_members&quot

arr_department_members = split(str_department_members,",&quot

...data base connectivity.....

if isarray(arr_department_members) then

for i=0 to ubound(arr_department_members)

if cint(arr_department_members(i)) = obj_RSet("department_id&quot

then response.write "match!"

next
end if

%>

cheers

transparent · Aug 30, 2002

the problem stems from not being able to force arr_department_members(i) to a int using cint. Any ideas?

transparent · Aug 30, 2002

The solution I have used...

if arr_department_members(i) = cstr(obj_RSet("department_id&quot

)

cheers for the help.

Geee · Aug 30, 2002

Ok I ran some test code on my server...

===========
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="

http://www.w3.org/1999/xhtml">

<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

<%

str_department_members = "1,2,3,4,5,6,7,8,9"
arr_department_members = split(str_department_members,",&quot

test_string = 6

if isarray(arr_department_members) then

for i=0 to ubound(arr_department_members)

if cint(arr_department_members(i)) = test_string then response.write "match! " & arr_department_members(i)

next
end if

%>

<body>
</body>
</html>
============

and the results can be seen at

http://www.weakest-links.co.uk/test.asp

This leads me to believe that there is a problem with either what is getting passed from your form, or what is coming from the database.

Any help?
-GTM Consult, Home of USITE-
-=

http://www.gtmconsult.co.uk=-

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Comparing an array value to a recordset value

transparent

Programmer

Geee

Programmer

transparent

Programmer

Geee

Programmer

FesterSXS

Programmer

transparent

Programmer

transparent

Programmer

transparent

Programmer

Geee

Programmer

Similar threads

Part and Inventory Search

Sponsor