numero = 14798
interpreted = N
texte = >[search db=colors.db&eqSKUdata=[SKU]]>Let's simplify this a bit. If you're saying that[search db=colors.db&eqSKUdata=dg1900][numFound][/search]returns 0, then you've got problems that are unrelated to nested searching -- the database fieldnames are messed up, or the data isn't there, or the database is not formatted correctly.On the other hand, from the look of your database setup, you might was well just store the color options in your main catalog. The way it's set up now, there is no advantage to separating them into another database.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>[search db=colors.db&eqSKUdata=[SKU]]>Let's simplify this a bit. If you're saying that[search db=colors.db&eqSKUdata=dg1900][numFound][/search]returns 0, then you've got problems that are unrelated to nested searching -- the database fieldnames are messed up, or the data isn't there, or the database is not formatted correctly.On the other hand, from the look of your database setup, you might was well just store the color options in your main catalog. The way it's set up now, there is no advantage to separating them into another database.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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...