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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. calis2

    Using IN with an INT and varchar id list (eg: 1,4,5,6)

    Thanks Terry & Tim. Tim, I had actually tried that method and sql still appeared not to like it. (thx for your help netherless :PP) However, that dynamic function is a great idea...just need to work out how to construct *dynamic sql* statements in CF. thx
  2. calis2

    Using IN with an INT and varchar id list (eg: 1,4,5,6)

    I need to be able to relate a varchar field that contains a list of id numbers (eg: 3,4,7,89,203) to a category id field (int). I've tried :: C.category_id IN (SELECT mID = CAST ( M2.member_category as INT) FROM member_details M2 WHERE M2.member_id = M.member_id) It returns this rather...

Part and Inventory Search

Back
Top