Re: Database Repopulation
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59549
interpreted = N
texte = Hi Nitai Unfortunately 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 like Dunk Hi Footwear Nike Dunk Hi Footwear Nike Womens History Books Nike Books To Dunk 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 Brands Nike Womens Brands Nike Toys & Accessories Nike Each 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. Regards Alan Nitai @ 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 Nitai Unfortunately 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 like Dunk Hi Footwear Nike Dunk Hi Footwear Nike Womens History Books Nike Books To Dunk 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 Brands Nike Womens Brands Nike Toys & Accessories Nike Each 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. Regards Alan Nitai @ 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:
using showpage and showcart commands (1996)
Dark Horse Comics success story (1997)
Show shoppingcart after remove last item (1997)
Error, 101 a DNS problem ? (1997)
Math with Time (1997)
Getting Values into Cart the easy way?* (1998)
What am I doing wrong? (2000)
RE: IIS 4 (1998)
Emailer (1997)
?The parameter is incorrect.? (2006)
For those of you not on the WebCatalog Beta... (1997)
Emailer (WebCat2) (1997)
Multiple catalog databases and showcart (1997)
[WebDNA] Linix v 6.2 Server (2013)
spaces in db (2001)
WebCat preferences caching problem (2000)
Clear/Reset form with JavaScript (2001)
sort problems....bug or brain fart? (1997)
emailer error -108 (1997)
process SSI (1998)