You can do this in CF with several examples given by repliers to your post.
But, you would be better off normalizing the data (fields/columns are
supposed to be atomic).
If you set up another table, something like:
CREATE TABLE ProductAndCategory
(
ProductID integer References Product,
CategoryID integer References Category,
PRIMARY KEY (ProductID, CategoryID)
)
Then you can let SQL do all the work (that's its job). Also, you can
easily retrieve all products for a category or all cotegories for a
product.
HTH
Dick
At 9:04 AM -0400 6/27/2000, Joel Firestone wrote:
>Everyone:
>
>I'm having a complete brain fart, so hopefully you guys can help.
>
>I have a table with a varchar field named catid. When a url variable named
>catid is passed, the page grabs all the data for that specific catid. Simple
>stuff.
>
>My problem lies in now I need for the catid to be a list (2,5,56,89). Thus the
>varchar field, and not a numeric. How can I select those items that contain
>the correct url.catid? I tried the IN keyword, with no success.
>
>Any help would be greatly appreciated.
>
>Joel
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
