Re: Search Questions

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26703
interpreted = N
texte = Regarding question 2...My SKU system works like this:The base product might be A71240 and that same product in XL would be A71240XL. Is that the best way to set up the databases? Have the base product in one database and the specific SKUs with the diff. sizes and colors like I have above?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Paul Fowler Sent: Friday, January 28, 2000 9:08 PM To: WebCatalog Talk Subject: Re: Search Questions Hi Brady,>Hello everyone! > >I have a few questions that I'm hoping someone can help me with.No Problem> >1. I have a form where I want people to be able to search for products by >entering a keyword and then having web catalog look thru the items to find >one that matches. What would the command be that goes in the FORM ACTION= >tag to do this?
Then you can use hidden form fields to pass any other info.> >2. I have several products, each with a diff. SKU number. I have some >products like a polo shirt that comes in 5 different sizes and color >combinations, each of which has its own SKU. However, I want the search to >only display the basic product, and then put all of the colors and sizes >that go along with that product into a drop-down list. In addition, some of >these shirts increase in price as the size increases. How would I code all >of this?I would use 2 databases. One would have the basic product information and a unique SKU, the second will have all the sizes with 1 SKU joining them together. The first database will be searched for product names and keywords, then there will be a nested search of the second database for the common SKU, returning all of the sizes and colors with their prices.Does this make sense? It is getting late and I have been at it too long today!Good luck, Paul Fowler> >Thanks. > >-- >Brady J. Horenstein >brady@imagetrends.com > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 >|--------------------------------------| | Get Real Gear, Inc. | P.O. Box 11199 | Aspen, CO 81612 | fax/voice (970)544-0527 | paul@gearworld.com | http://www.gearworld.com |--------------------------------------|------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Search Questions (Brady J. Horenstein 2000)
  2. Re: Search Questions (PCS Technical Support 2000)
  3. Re: Search Questions (Bob Minor 2000)
  4. Re: Search Questions (Kenneth Grome 2000)
  5. Re: Search Questions (Paul Fowler 2000)
  6. Search Questions (Brady J. Horenstein 2000)
  7. Re: Forms Search Questions (Grant Hulbert 1997)
  8. Re: Forms Search Questions (Kenneth Grome 1997)
  9. Re: Forms Search Questions (Jacques VERNAY 1997)
  10. Re: Forms Search Questions (Christer Olsson 1997)
  11. Re: Forms Search Questions (Christer Olsson 1997)
  12. Re: Forms Search Questions (Kenneth Grome 1997)
  13. Forms Search Questions (Richard Shapiro 1997)
Regarding question 2...My SKU system works like this:The base product might be A71240 and that same product in XL would be A71240XL. Is that the best way to set up the databases? Have the base product in one database and the specific SKUs with the diff. sizes and colors like I have above?-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Paul Fowler Sent: Friday, January 28, 2000 9:08 PM To: WebCatalog Talk Subject: Re: Search Questions Hi Brady,>Hello everyone! > >I have a few questions that I'm hoping someone can help me with.No Problem> >1. I have a form where I want people to be able to search for products by >entering a keyword and then having web catalog look thru the items to find >one that matches. What would the command be that goes in the FORM ACTION= >tag to do this? Then you can use hidden form fields to pass any other info.> >2. I have several products, each with a diff. SKU number. I have some >products like a polo shirt that comes in 5 different sizes and color >combinations, each of which has its own SKU. However, I want the search to >only display the basic product, and then put all of the colors and sizes >that go along with that product into a drop-down list. In addition, some of >these shirts increase in price as the size increases. How would I code all >of this?I would use 2 databases. One would have the basic product information and a unique SKU, the second will have all the sizes with 1 SKU joining them together. The first database will be searched for product names and keywords, then there will be a nested search of the second database for the common SKU, returning all of the sizes and colors with their prices.Does this make sense? It is getting late and I have been at it too long today!Good luck, Paul Fowler> >Thanks. > >-- >Brady J. Horenstein >brady@imagetrends.com > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >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 >|--------------------------------------| | Get Real Gear, Inc. | P.O. Box 11199 | Aspen, CO 81612 | fax/voice (970)544-0527 | paul@gearworld.com | http://www.gearworld.com |--------------------------------------|------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Brady J. Horenstein

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:

Writing files (2000) RE: ShowNext Command (1997) multi-paragraph fields (1997) Webcat2, WebCommerce, Mod 10 etc. (1997) RE: [WebDNA] db admin tool (2008) RE: IIS4b2 and WebCatalog b19 (1997) Before I Can Begin . . . (1998) Giving out error pages (1997) Nested tags count question (1997) WebCatalog can't find database (1997) Authenticate (1997) special commerce fields (1997) Multiple prices (1997) WebCat2b13MacPlugIn - [include] (1997) StandardConversions.db (1998) Changing to a windows mounted share from a Mac OS X machine (2002) $flushcache causes crash (2000) Physical Proximity searches (2000) New Business Opportunity (2006) WebCatalog for guestbook ? (1997)