Re: Database Repopulation

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59547
interpreted = N
texte = Hi Alan, I would create a "super" Table with the Men and Girls category. T= hen add a crosstable which will only hold the ID of the Men/Girl=20= Category and the ID of the product. Like this you can add many more categories (if your boss would ne= ed more) and you will also not touch the products db and you can=20= add an unlimited number of entries and cross entries. Just a quick thought at the top of my head........ Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Beh= alf Of Alan White Sent: Thursday, October 07, 2004 1:51 PM To: WebDNA Talk Subject: Database Repopulation Hello Folks I am currently trying to facilitate a new method of displaying pr= oducts on our site but need to do several things to make it happen. Essentially we currently have separate brands for say Adidas Mens= & Adidas Girls and then if we had any toys or books they would go i= nto a sub category. What I want to do is migrate all products for each brand into a m= ale / female / unisex split so I can then create gender specific menus.= My problem lies here, I can easily put into pace the mechanism to fl= ag products as the m / f / u for gender but I am a little boggled=20= over the *safest* brand migration method. In order to switch to this new method I will have to create a new= brand and then move all the products from each brand into this new bran= d as well as flagging the gender. Either that or migrate all Girls pr= oducts to the mens, then rename mens to non gender specific brand and th= en code my menu system to reflect the gender choices... Any suggestions or advice are welcome. Thanks Alan White =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Technical / Web Administrator w:// http://www.hanon-shop.com e:// alan@hanon-shop.com t:// +44 0 1224 213452 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Database Repopulation ( Alan White 2004)
  2. Re: Database Repopulation ( "Nitai @ ComputerOil" 2004)
  3. Re: Database Repopulation ( Alan White 2004)
  4. Re: Database Repopulation ( Donovan Brooke 2004)
  5. Re: Database Repopulation ( Alan White 2004)
  6. Re: Database Repopulation ( Donovan Brooke 2004)
  7. Re: Database Repopulation ( Alan White 2004)
  8. Re: Database Repopulation ( "Nitai @ ComputerOil" 2004)
  9. Re: Database Repopulation ( Gary Krockover 2004)
  10. Re: Database Repopulation ( Alan White 2004)
  11. Re: Database Repopulation ( Alan White 2004)
  12. Re: Database Repopulation ( "Nitai @ ComputerOil" 2004)
  13. Database Repopulation ( Alan White 2004)
Hi Alan, I would create a "super" Table with the Men and Girls category. T= hen add a crosstable which will only hold the ID of the Men/Girl=20= Category and the ID of the product. Like this you can add many more categories (if your boss would ne= ed more) and you will also not touch the products db and you can=20= add an unlimited number of entries and cross entries. Just a quick thought at the top of my head........ Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Beh= alf Of Alan White Sent: Thursday, October 07, 2004 1:51 PM To: WebDNA Talk Subject: Database Repopulation Hello Folks I am currently trying to facilitate a new method of displaying pr= oducts on our site but need to do several things to make it happen. Essentially we currently have separate brands for say Adidas Mens= & Adidas Girls and then if we had any toys or books they would go i= nto a sub category. What I want to do is migrate all products for each brand into a m= ale / female / unisex split so I can then create gender specific menus.= My problem lies here, I can easily put into pace the mechanism to fl= ag products as the m / f / u for gender but I am a little boggled=20= over the *safest* brand migration method. In order to switch to this new method I will have to create a new= brand and then move all the products from each brand into this new bran= d as well as flagging the gender. Either that or migrate all Girls pr= oducts to the mens, then rename mens to non gender specific brand and th= en code my menu system to reflect the gender choices... Any suggestions or advice are welcome. Thanks Alan White =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Technical / Web Administrator w:// http://www.hanon-shop.com e:// alan@hanon-shop.com t:// +44 0 1224 213452 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Nitai @ ComputerOil"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

RE: Formulas.db + Users.db (1997) Running WebCat from a CD-ROM (1997) Payments -> Bank Accounts (2005) Dummy Credit Card Number for debug? (1997) PCS Frames (1997) Sort order (1998) [WebDNA] Alert: Google webdna.us search - yields a page full of URLs with errors (2011) advise!! (2001) TCPSend/Replace DB Records (2002) Problems problems problems (1997) Merging databases (1997) [WebDNA] Linux Support (2013) Is the list server working? (1998) Trigger alternatives please ... (2004) Beta Documentation (1997) filemaker - orderfile (1997) Date Time Oddness (1999) Quit revisited (1997) international time (1997) Calendar (1997)