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:
RE: type 2 errors with ssl server (1997)
Emailer [cart] file names (1997)
Non-Cart Files in Shopping Cart Folder (1997)
PCS Frames (1997)
Forumulas.db & Variables (2002)
(2000)
Calculating multiple shipping... (1997)
More than one db with the same namn (was: WC2f3) (1997)
database freeze (1997)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] WebDNA and MAMP/Apache (Mac) (2018)
Why is this not false? (2001)
Looking for PHP programmer (2007)
WC 4.0 on OSX 10.0.4 problems (2001)
[WebDNA] Anyone use this coding style for readability... (2010)
Include a big block of text (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Inventory Adjustment (2000)
Renaming textA (1998)