Re: Help with [search] sort

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 49374
interpreted = N
texte = Will -You should certainly be able to get the found items you want with the search alone. Let me walk through this and see if I properly understand what you're trying to do...* Your catalog.db has a level field containing I, II or III...* Your catalog.db has fields for various skin types, say dry and oily (my examples) ...* The skintype variable, prior to your search, contains the name of one of these skin type fields (dry or oily)...* The level variable, prior to your search, contains (blank), I or IIIf the above is true, then the search you've defined should properly return only those records that have both the matching skin type field set to T and the level field greater than the specified level. That is, I think your [search] looks fine, as long as the proper conditions are set up beforehand.To test this, I would duplicate the [search] tag immediately prior to the existing [search] tag and disable it so it displays with its parameters on the page instead of evaluating...[**search db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysort= 1&astitlesort=2&asskusort=3&instockdatarq=T]
Load the page, look at the displayed results and see if it is what you were expecting.One other note... In your hideif / lookup method for hiding undesirable records, you could skip the lookup and instead use [interpret][[skintype]][/interpret], which would be much faster than the lookup method.- brianOn Wednesday, April 9, 2003, at 09:17 AM, WJ Starck wrote:>> On Wednesday, April 9, 2003, at 09:51 AM, WJ Starck wrote:>>>>>> Here is the current search:>>>> [search >> db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysor >> t=1&astitlesort=2&asskusort=3&instockdatarq=T]>>>>>> OK, this did the trick> [search > db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysort > =1&astitlesort=2&asskusort=3&instockdatarq=T]>> [founditems]> [hideif [lookup > db=catalog.db&value=[sku]&lookinfield=sku&returnfield=[skintype]]!T]>> Blah>> Still wondering if it can be done from the search though...> -->> Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@novaderm.com>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com ---------------------------------------------------------------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:

Re: Help with [search] sort (Gary Krockover 2003)
Re: Help with [search] sort (Brian Fries 2003)
Re: Help with [search] sort (WJ Starck 2003)
Help with [search] sort (WJ Starck 2003)

Will -You should certainly be able to get the found items you want with the search alone. Let me walk through this and see if I properly understand what you're trying to do...* Your catalog.db has a level field containing I, II or III...* Your catalog.db has fields for various skin types, say dry and oily (my examples) ...* The skintype variable, prior to your search, contains the name of one of these skin type fields (dry or oily)...* The level variable, prior to your search, contains (blank), I or IIIf the above is true, then the search you've defined should properly return only those records that have both the matching skin type field set to T and the level field greater than the specified level. That is, I think your [search] looks fine, as long as the proper conditions are set up beforehand.To test this, I would duplicate the [search] tag immediately prior to the existing [search] tag and disable it so it displays with its parameters on the page instead of evaluating...[**search db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysort= 1&astitlesort=2&asskusort=3&instockdatarq=T]
Load the page, look at the displayed results and see if it is what you were expecting.One other note... In your hideif / lookup method for hiding undesirable records, you could skip the lookup and instead use [interpret][[skintype]][/interpret], which would be much faster than the lookup method.- brianOn Wednesday, April 9, 2003, at 09:17 AM, WJ Starck wrote:>> On Wednesday, April 9, 2003, at 09:51 AM, WJ Starck wrote:>>>>>> Here is the current search:>>>> [search >> db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysor >> t=1&astitlesort=2&asskusort=3&instockdatarq=T]>>>>>> OK, this did the trick> [search > db=catalog.db&eq[skintype]datarq=T&grleveldatarq=[level]&ascategorysort > =1&astitlesort=2&asskusort=3&instockdatarq=T]>> [founditems]> [hideif [lookup > db=catalog.db&value=[sku]&lookinfield=sku&returnfield=[skintype]]!T]>> Blah>> Still wondering if it can be done from the search though...> -->> Will Starck> NovaDerm Skincare Science> http://www.novaderm.com> wjs@novaderm.com>-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com ---------------------------------------------------------------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/ Brian Fries

DOWNLOAD WEBDNA NOW!

Re: Help with [search] sort

2003

Top Articles:

Related Readings: