Author: lostpet_dev | Posted on: 8/13/2008 4:14:40 PM | Views : 315


I have a variable coming from the database that has a comma separator that I'd like to check against a series of IDs inside a While Loop, the variable has data looks like this "1, 4, 6". I believe I have an issue with a conditional statement where I'd like to just check if a variable is equal to another (var1 = var2) forgive my asp lingo / syntax as I've been a php jockey for a while and just now adapting to asp over the last month.

Here is the ASP code I've been struggling with thus far:

<% if temper>"" then

sql = "select * from PetTemper"
Set RS1 = DBConn1.Execute(sql)

ListArray = split(temper, ", ")
'count 'em up
cnt = ubound(ListArray)

selected=0
x=0

Do While Not RS1.EOF

if ListArray(x) > "" then idx = ListArray(x)
if idx>"" and idx = RS1("id") then match = ...

Go to the complete details ...