[Zope] unlimited SET?

3205 5361 1215 9784 3205 5361 1215 9784 <keo@goa.hu>
Sun, 11 Aug 2002 22:29:23 +0200


Hello zope,

  i posted this to zope-db, but nobody replied...

      there is this SET type in mysql... the problem is it's bit
      based, and can contain up to 32 elements...

      what if i have lot more stuff?

      i have 2 tables, the first one is for the product (i'm building
      an e-commerce site) and the other has options, that can be
      selected for the product.

      i thought of keeping the "option1,option2,option3" structure,
      but make it TEXT instead of SET, and doing the whole
      searching/adding/deleting logic from code and not mysql.

      but it seems a bit complicated for first.

      is there a better workaround? whats the practice for this?


      i have ran into this problem several times, and i am sure there
      is a good working practice for this under zope;D


      thanks a lot,

      k.  

-- 
don't believe everything you think