Re: Sorting problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41419
interpreted = N
texte = In order to get the TDC.db search to sort all items you're trying to list, you've got to find all the items with only one call to the [search] context. Instead of nesting your searches, first search the PrinterDB.db and build a list of all the cartridges you want into a text variable, then search the TDC.db matching all cartridges in the list. Something like this:[text]cartList=[/text][!]intialize list to be empty[/!][search db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[CARTRIDGES]][foundItems][text]cartList=[cartList]+[CARTRIDGES][/text][/founditems][/search][search db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPartNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]][foundItems][sortorder] [title]
[/foundItems][/search]
- BrianAt 4:44 PM 7/10/02, Don wrote:>Thanks Brian I tried adding &allhit=1 and no luck, I tried it on each>search string as well as both at the same time, no luck>>It does find multiple items on the outside search and it looks like they are>sorting properly within there set but how do I get them to sort all>together?>>Don>>>On 7/10/02 4:30 PM, Brian Fries
wrote:>>> Are you getting multiple founditems on the outside search? If so then>> the founditems from the TDC.db will only be sorted WITHIN each found>> Printer.db record.>>>> Otherwise, try adding &allhit=1 to your search string.>>>> - brian>>>> At 4:09 PM 7/10/02, Don wrote:>>> It still wont work for me here is the entire code>>>> >> [search >db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C> >> ARTRIDGES]]
> >> [foundItems]
> >> >[searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asSO>>> RTORDERsort=1&max=20&startat=[url][startat][/url]]
>>> [foundItems]
>>> [sortorder] [title]
>>> [/foundItems]
>>> [/search]
> >> [/foundItems]
>>> [/search]
>>>>>> I'm trying to make the list sort by the field SortOrder which is a field>>> stored in the 2nd search DB I do this all the time when I'm only calling>>> from one database but it just doesn't seem to want to work when searching>>> from 2.>>>>>> Any Ideas>>>>>> Don>>>>>>>>> On 7/10/02 2:23 PM, Glenn Busbin wrote:>>>>>>> Sorry. My bad. I looked at the sorts and didn't notice that you're>>>> searching>>>> on 2 fields in Printer.db and had some other syntax errors.>>>>>>>> Try this:>>>>>>>> [search>>>> db=PrinterDB.db&eqModeldatarq=[Model]&eqCARTRIDGESdatarq=[CARTRIDGES]>>>> &asCARTRIDGESsort=1]>>>> [foundItems]>>>> [search db=TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&>>>> asTITLEsort=1&max=20&startat=[url][startat][/url]]>>>> [foundItems]>>>> [title]
>>>> [/foundItems]>>>> [/search]>>>> [/foundItems]>>>> [/search]>>>>>>>> Glenn>>>>>>>> ------------------------------------------------------------->>>> 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://search.smithmicro.com/>>>>>> -->>> ************************************************************>>> Apple Specialist>>>>>> Don Chatwin Phone: 800-645-2533> >> T.D. Curran Inc. Fax: 360-594-3987> >> 800 Marine Drive email: don@tdcurran.com> >> Bellingham WA 98225 Web: http://www.tdcurran.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://search.smithmicro.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://search.smithmicro.com/>>-->************************************************************> Apple Specialist>>Don Chatwin Phone: 800-645-2533>T.D. Curran Inc. Fax: 360-594-3987>800 Marine Drive email: don@tdcurran.com>Bellingham WA 98225 Web: http://www.tdcurran.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://search.smithmicro.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
In order to get the TDC.db search to sort all items you're trying to list, you've got to find all the items with only one call to the [search] context. Instead of nesting your searches, first search the PrinterDB.db and build a list of all the cartridges you want into a text variable, then search the TDC.db matching all cartridges in the list. Something like this:[text]cartList=[/text][!]intialize list to be empty[/!][search db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[CARTRIDGES]][founditems][text]cartList=[cartList]+[CARTRIDGES][/text][/founditems][/search][search db=TDC_Databases/TDC.db&woManufacturePartNumberdata=[cartList]&ManufacturerPartNumberword=ww&allhit=1&asSORTORDERsort=1&max=20&startat=[url][startat][/url]][founditems][sortorder] [title]
[/foundItems][/search]
- BrianAt 4:44 PM 7/10/02, Don wrote:>Thanks Brian I tried adding &allhit=1 and no luck, I tried it on each>search string as well as both at the same time, no luck>>It does find multiple items on the outside search and it looks like they are>sorting properly within there set but how do I get them to sort all>together?>>Don>>>On 7/10/02 4:30 PM, Brian Fries wrote:>>> Are you getting multiple founditems on the outside search? If so then>> the founditems from the TDC.db will only be sorted WITHIN each found>> Printer.db record.>>>> Otherwise, try adding &allhit=1 to your search string.>>>> - brian>>>> At 4:09 PM 7/10/02, Don wrote:>>> It still wont work for me here is the entire code>>>> >> [search >db=TDC_Databases/PrinterDB.db&eqModeldata=[Model]&eqCARTRIDGESdata=[C> >> ARTRIDGES]]
> >> [founditems]
> >> >[searchdb=TDC_Databases/TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&asSO>>> RTORDERsort=1&max=20&startat=[url][startat][/url]]
>>> [founditems]
>>> [sortorder] [title]
>>> [/foundItems]
>>> [/search]
> >> [/foundItems]
>>> [/search]
>>>>>> I'm trying to make the list sort by the field SortOrder which is a field>>> stored in the 2nd search DB I do this all the time when I'm only calling>>> from one database but it just doesn't seem to want to work when searching>>> from 2.>>>>>> Any Ideas>>>>>> Don>>>>>>>>> On 7/10/02 2:23 PM, Glenn Busbin wrote:>>>>>>> Sorry. My bad. I looked at the sorts and didn't notice that you're>>>> searching>>>> on 2 fields in Printer.db and had some other syntax errors.>>>>>>>> Try this:>>>>>>>> [search>>>> db=PrinterDB.db&eqModeldatarq=[Model]&eqCARTRIDGESdatarq=[CARTRIDGES]>>>> &asCARTRIDGESsort=1]>>>> [founditems]>>>> [search db=TDC.db&eqManufacturePartNumberdata=[CARTRIDGES]&>>>> asTITLEsort=1&max=20&startat=[url][startat][/url]]>>>> [founditems]>>>> [title]
>>>> [/foundItems]>>>> [/search]>>>> [/foundItems]>>>> [/search]>>>>>>>> Glenn>>>>>>>> ------------------------------------------------------------->>>> 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://search.smithmicro.com/>>>>>> -->>> ************************************************************>>> Apple Specialist>>>>>> Don Chatwin Phone: 800-645-2533> >> T.D. Curran Inc. Fax: 360-594-3987> >> 800 Marine Drive email: don@tdcurran.com> >> Bellingham WA 98225 Web: http://www.tdcurran.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://search.smithmicro.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://search.smithmicro.com/>>-->************************************************************> Apple Specialist>>Don Chatwin Phone: 800-645-2533>T.D. Curran Inc. Fax: 360-594-3987>800 Marine Drive email: don@tdcurran.com>Bellingham WA 98225 Web: http://www.tdcurran.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://search.smithmicro.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://search.smithmicro.com/
Brian Fries
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:
# fields limited? (1997)
pc (1997)
[OT] Apple and 128bit SSL (2003)
Adding Items to Cart (2003)
Formating found categories (1997)
WC TableGrinder (1997)
Digest Version (2000)
Form Variables (2000)
Image maps/Webcat (1997)
WC1.6 to WC2 date formatting (1997)
Weird Math and SV (1997)
Using Plug-In while running 1.6.1 (1997)
Extended [ConvertChars] (1997)
Log-in Scheme (2003)
Re:Part 2 - [showif] if variable exists (1998)
[ot] table gap help?!? (2001)
show all problem (1997)
Practice runs ? (1997)
development check... (2004)
Add to Cart & List of Products (1997)