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:
NetSplat and WebCat2 (1997)
oops private message leaked into talk list (1997)
RequiredFields parameter (1998)
Search in 2 or more catalogs (1997)
setcookie getcookie on the same page (2003)
sendmail and accented characters (1998)
[ConvertChars] problem (1997)
MySQL (2003)
Major Security Hole (1998)
Using Plug-In while running 1.6.1 (1997)
Help name our technology! (1997)
WebCatalog/WebMerchant 2.1 (1998)
locking variables? (2000)
[WriteFile] problems (1997)
verify online (1997)
Include a big block of text (1997)
Emailer update for Mac? (1998)
A new bug? (1999)
Webmerchant/Cybercash (2000)
New public beta available (1997)