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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

finding item in array

Status
Not open for further replies.
travisbrown

travisbrown

Technical User
Dec 31, 2001
1,016
This is what I want it to do. What's the right method?

IF rs.Fields("rec_id") IN nav_cid THEN

'nav_cid is an array created from a dash-delimited querystring value. e.g: SPLIT("2-15-22-531", "-")

hasKids = "sxicon3.gif"
ELSE
hasKids = "sxicon2.gif"
END IF
 
Sort by date Sort by votes
I thought maybe something like this, but it doesn't work either:

hasKids = "sxicon2.gif"
FOR EACH rs.Fields("rec_id") IN nav_cid
hasKids = "sxicon3.gif"
NEXT
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
754
leifoet
leifoet
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
405
leifoet
leifoet
Swi
  • Locked
  • Question
PDF Interrogation
Replies
0
Views
234
Swi
Swi
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
392
penguinspeaks
penguinspeaks
DiDYRO_
  • Locked
  • Question
How do I make a VBS file that can collect dialog-type answers in a local .log file?
Replies
0
Views
362
DiDYRO_
DiDYRO_

Part and Inventory Search

Sponsor

Back
Top