Re: Database Repopulation
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59549
interpreted = N
texte = Hi NitaiUnfortunately I am still on Version 4.5.1 so I cannot use tables and even if I was to upgrade I would need to learn how to use the new features available to me such as tables before using them. Categories are not actually a problem at the moment, it is more how I negotiate imalgimating brands where I am getting a little confused.I want to change from something likeDunk Hi Footwear Nike Dunk Hi Footwear Nike Womens History Books Nike Books ToDunk Hi Footwear Nike m Dunk Hi Footwear Nike f History Books Nike u In order to do this I need to change my products to contain a gender flag and also point them to a single brand, my problem lies where I have a cross over... do I move all of my womens products into mens (notice in the example above only womens is specified) first and give them a gender flag... once I have moved all products into individual brands, I can then break them up by use of the flags in brand menu's ie (taken from above) :-Mens BrandsNikeWomens BrandsNikeToys & AccessoriesNikeEach of the links above would lead to a set of category sub navigation.Hope that makes it a little clearer... I guess I am just fishing to see if I am on the right track or if there is a better quicker way to do it like writing a script to strip out values and populate db's for me...For example: Before going down this route I decided to try and attach gender to brands as a quick route of acomplishing what is required, in hindsight I noticed inherrint problems with doing it like this but I actually now have a *handle* I could use to flag all my products in each brand with either an m for male brands or f for female brands... (I think I may have a few hurdles still doing it that way)Anyway, I hope what I am trying to do is a little clearer for anyone following this and thanks for your suggestion.RegardsAlanNitai @ ComputerOil wrote:>Hi Alan,>>I would create a "super" Table with the Men and Girls category. Then add a crosstable which will only hold the ID of the Men/Girl Category and the ID of the product.>>Like this you can add many more categories (if your boss would need more) and you will also not touch the products db and you can add an unlimited number of entries and cross entries.>>Just a quick thought at the top of my head........>>Nitai>> >-------------------------------------------------------------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 NitaiUnfortunately I am still on Version 4.5.1 so I cannot use tables and even if I was to upgrade I would need to learn how to use the new features available to me such as tables before using them. Categories are not actually a problem at the moment, it is more how I negotiate imalgimating brands where I am getting a little confused.I want to change from something likeDunk Hi Footwear Nike Dunk Hi Footwear Nike Womens History Books Nike Books ToDunk Hi Footwear Nike m Dunk Hi Footwear Nike f History Books Nike u In order to do this I need to change my products to contain a gender flag and also point them to a single brand, my problem lies where I have a cross over... do I move all of my womens products into mens (notice in the example above only womens is specified) first and give them a gender flag... once I have moved all products into individual brands, I can then break them up by use of the flags in brand menu's ie (taken from above) :-Mens BrandsNikeWomens BrandsNikeToys & AccessoriesNikeEach of the links above would lead to a set of category sub navigation.Hope that makes it a little clearer... I guess I am just fishing to see if I am on the right track or if there is a better quicker way to do it like writing a script to strip out values and populate db's for me...For example: Before going down this route I decided to try and attach gender to brands as a quick route of acomplishing what is required, in hindsight I noticed inherrint problems with doing it like this but I actually now have a *handle* I could use to flag all my products in each brand with either an m for male brands or f for female brands... (I think I may have a few hurdles still doing it that way)Anyway, I hope what I am trying to do is a little clearer for anyone following this and thanks for your suggestion.RegardsAlanNitai @ ComputerOil wrote:>Hi Alan,>>I would create a "super" Table with the Men and Girls category. Then add a crosstable which will only hold the ID of the Men/Girl Category and the ID of the product.>>Like this you can add many more categories (if your boss would need more) and you will also not touch the products db and you can add an unlimited number of entries and cross entries.>>Just a quick thought at the top of my head........>>Nitai>> >-------------------------------------------------------------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/
Alan White
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:
Formvariables name matching (2005)
RE: [WebDNA] Redirecting incoming URL request to https page (2018)
SameAsShipping (2005)
Summing fields (1997)
Non-technical messages ... (1997)
[WebDNA] WebDNA 8.6 announced - New features (2018)
redirect with frames (1997)
carriage returns in data (1997)
Multiple Ad databases? (1997)
Mac Vs WindowsNT (1997)
shipcost (1997)
Sorting error (1997)
Firewalls - What's Good? (1999)
WebCatalog Plugin: Getting Data Canceled (2000)
Country & Ship-to address & other fields ? (1997)
HELP WITH DATES (1997)
Getting total number of items ordered (1997)
WC2f3 (1997)
formula??? (2000)
[WebDNA] [Test] (2009)