I'm strugling a little here. Let me start from the beginning...
I want to search my product catalogue, by paramter. An example being paramters or Artist and Format for CDs. In fact I have a table that maps these as follows:
[b]t_product_parameter_options[/b]
ID -> 1 . . description -> "Artist"
ID -> 2 . . description -> "Format"
Into my stored procedure I am given a delimited string of integers, representing VALUE_IDs. I have turned these into a table through a function I wrote - so let's call that:
Question
+Dick Montage Subscriber²
I'm strugling a little here. Let me start from the beginning...
I want to search my product catalogue, by paramter. An example being paramters or Artist and Format for CDs. In fact I have a table that maps these as follows:
I then have a table for each parameter:
These are then mapped against products as follows:
Okie dokie so far.
Into my stored procedure I am given a delimited string of integers, representing VALUE_IDs. I have turned these into a table through a function I wrote - so let's call that:
What I want to do is match:
* Single products
* Where ALL value_IDs for that product match splitval_Vals
* WHERE a related option is given
So, a product may also have a paramter for "RPM". If I look for ONLY artist and format - I am do not need to consider the values related to RPM.
Am I making sense here?
Cheers
Link to comment
Share on other sites
4 answers to this question
Recommended Posts