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 worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Beh=alf Of Alan WhiteSent: Thursday, October 07, 2004 1:51 PMTo: WebDNA TalkSubject: Database RepopulationHello FolksI 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.ThanksAlan 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=3DTechnical / Web Administratorw:// http://www.hanon-shop.come:// alan@hanon-shop.comt:// +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:
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 worksContent Management & eBusiness Systems ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://computeroil.com-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Beh=alf Of Alan WhiteSent: Thursday, October 07, 2004 1:51 PMTo: WebDNA TalkSubject: Database RepopulationHello FolksI 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.ThanksAlan 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=3DTechnical / Web Administratorw:// http://www.hanon-shop.come:// alan@hanon-shop.comt:// +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)