Re: Showing once on a founditems

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15578
interpreted = N
texte = In the relational database world, we talk about parent and child datatables. You need to decide the organization of your tables and which are the parent table and the child tables. Typically, there's one parent and several child tables (there can be grandparents, aunts, uncles, etc. -- just as confusing as real life ;) ).From what you are describing, I'd make the category a field in the photo table photofilename categories uniquekey Any categories that call this photo are entered with spaces separating them in the category field (or space, etc., depending on names of categories).Then the inventory items are a child of the photo.dbSKU categories photokeyYou'd search the photofile for a category match, then do a sub-search for each photo of SKU's with photo.db's uniquekey in the photokey field.At other times, you might want to make inventory.db the parent and photo the child, etc. But planning ahead does allow dealing with all these relationships :) Good luck!Sandy Ray Hatch wrote: > > At 02:17 PM 12/10/97 -1000, you wrote: > >>In doing a search for a specific category, I need to accomplish two things, > >>I need to show the category once (which I could use the [searchTitle] > >>outside of my founditems to do this) and then show the different [Titles] > >>associated with this category, Now..some of my titles share a single photo, > >>so I need to group those with that photo. > >> > >>Example: I have 3 Different Jackets, all of same category yet with > >>different names[titles], but all three are depicted on one photo. > >> > >>So.. If I have 6 different items under category Jackets, 3 of which share > >>the same photo, 2 share another photo, & one has it's own. Can I Show the > >>[Category] Jackets, one time at top of page. Then group each found item > >>with it's photo. > >> > >>Like: > >> > >>JACKETS > >> > >>jacket one > >>jacket two photo off to side > >>jacket three > >> > >>
> >>
> >> > >>jacket four > >>jacket five photo > >> > >>
> >>
> >> > >>jacket six photo > >> > >> > >> > >>Any suggestions? > > > > > >Wow, you sure like to make things difficult for WebCat, don't you? :) > > > >Ray, I'm sure WebCatalog can do this, but you will probably have to > >re-think the way you have decided how to assign which photos to which > >products, and exactly what procedures WebCat will need to go thru in > >order to decide which scenario it has to deal with in each different > >situation. > > > >WebCat has the flexibility, but programming that flexibility is going > >to take a lot of intense thinking and pre-planning on your part ... :) > > Yeah, I have this nack of jumping to the end of the learning curve instead > of starting at the beginning, I have total confidence that WebCat can > handle these requests, I'm not too sure if I can. But I think the joy of > this software is making it work as hard for you as it can, thus making > everything else so much easier. > > If anyone has done anything like what I'm attempting to figure out, I would > love to see and hear about it. > > Ray Associated Messages, from the most recent to the oldest:

    
  1. Re: New site announcement + Re: Showing once on a founditems (Christophe BECK 1997)
  2. Re: New site announcement + Re: Showing once on a founditems (Christophe BECK 1997)
  3. New site announcement + Re: Showing once on a founditems (Gilles Renoul 1997)
  4. Re: Showing once on a founditems (Sandra L. Pitner 1997)
  5. Re: Showing once on a founditems (Ray Hatch 1997)
  6. Re: Showing once on a founditems (Kenneth Grome 1997)
  7. Showing once on a founditems (Ray Hatch 1997)
In the relational database world, we talk about parent and child datatables. You need to decide the organization of your tables and which are the parent table and the child tables. Typically, there's one parent and several child tables (there can be grandparents, aunts, uncles, etc. -- just as confusing as real life ;) ).From what you are describing, I'd make the category a field in the photo table photofilename categories uniquekey Any categories that call this photo are entered with spaces separating them in the category field (or space, etc., depending on names of categories).Then the inventory items are a child of the photo.dbSKU categories photokeyYou'd search the photofile for a category match, then do a sub-search for each photo of SKU's with photo.db's uniquekey in the photokey field.At other times, you might want to make inventory.db the parent and photo the child, etc. But planning ahead does allow dealing with all these relationships :) Good luck!Sandy Ray Hatch wrote: > > At 02:17 PM 12/10/97 -1000, you wrote: > >>In doing a search for a specific category, I need to accomplish two things, > >>I need to show the category once (which I could use the [searchTitle] > >>outside of my founditems to do this) and then show the different [Titles] > >>associated with this category, Now..some of my titles share a single photo, > >>so I need to group those with that photo. > >> > >>Example: I have 3 Different Jackets, all of same category yet with > >>different names[titles], but all three are depicted on one photo. > >> > >>So.. If I have 6 different items under category Jackets, 3 of which share > >>the same photo, 2 share another photo, & one has it's own. Can I Show the > >>[Category] Jackets, one time at top of page. Then group each found item > >>with it's photo. > >> > >>Like: > >> > >>JACKETS > >> > >>jacket one > >>jacket two photo off to side > >>jacket three > >> > >>
> >>
> >> > >>jacket four > >>jacket five photo > >> > >>
> >>
> >> > >>jacket six photo > >> > >> > >> > >>Any suggestions? > > > > > >Wow, you sure like to make things difficult for WebCat, don't you? :) > > > >Ray, I'm sure WebCatalog can do this, but you will probably have to > >re-think the way you have decided how to assign which photos to which > >products, and exactly what procedures WebCat will need to go thru in > >order to decide which scenario it has to deal with in each different > >situation. > > > >WebCat has the flexibility, but programming that flexibility is going > >to take a lot of intense thinking and pre-planning on your part ... :) > > Yeah, I have this nack of jumping to the end of the learning curve instead > of starting at the beginning, I have total confidence that WebCat can > handle these requests, I'm not too sure if I can. But I think the joy of > this software is making it work as hard for you as it can, thus making > everything else so much easier. > > If anyone has done anything like what I'm attempting to figure out, I would > love to see and hear about it. > > Ray Sandra L. Pitner

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:

Help name our technology! (1997) [SUM field=xxx] (2000) Images in WebCat (2000) Shared conversion under WebTen (1998) Date Sorting (1997) Searching for a Blank Field (2000) WebCatalog can't find database (1997) [format 40s]text[/format] doesn't work (1997) suffix mapping for NT? (1997) can WC render sites out? (1997) Bug: MySQL WebDNA 6 int bigint fail case (2004) Line items in table cells (1997) Regarding PayPal (was Payments -> Bank Accounts) (2005) syntax question, not in online refernce (1997) PSC recommends what date format yr 2000??? (1997) FEA REQ: One .hdr, multiple .db's (2003) Sku numbers (1997) WCS Newbie question (1997) Problem with updating 2.1b7 -> 2.1.1 (1998) SSL and reg web* (1997)