On Jun 18, 2008, at 1:32 PM, Nate Lowrie wrote:
> I need to be able to search by this metadata for a part that matches
> values in 1 or more of these fields (i.e. a resistor with a 0603
> package and a resistance of 330 ohms). Yet, the only way I could
> think of doing it is searching the metadata table separately for each
> field value and then seeing which partIDs are on both lists. Anyone
> got a better way?
SELECT Part.ID, Part.SKU
FROM Part
WHERE Part.ID IN
(SELECT ID from MetaData
WHERE ParameterName = "Package"
AND ParameterValue = "0603"
)
AND Part.ID IN
(SELECT ID from MetaData
WHERE ParameterName = "Resistance"
AND ParameterValue = 330
)
Don't know if that helps, but that should give you a start.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
