Re: Sorting problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41390
interpreted = N
texte = 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.- brianAt 4:09 PM 7/10/02, Don wrote:>It still wont work for me here is the entire code>>[searchdb=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/
Associated Messages, from the most recent to the oldest:
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.- brianAt 4:09 PM 7/10/02, Don wrote:>It still wont work for me here is the entire code>>[searchdb=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/
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:
Page Breaks (1999)
using showpage and showcart commands (1996)
Summing fields (1997)
Re:trouble (1997)
Spiders and Bots (2000)
Problem (1997)
How To question on setting up downloads (1997)
I'm new be kind (1997)
sorting and summarizing (1998)
[WebDNA] WebDNA future (2010)
[WebDNA] Yosemite (2015)
Moment of Thanks (1997)
Everyone: List Traffic (was [include ...] behavior) (1997)
carriage returns in data (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
[showif] / [hideif] (1997)
information on Vieworders.tpl (1998)
wierd [cart] action! (1997)
[WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (2009)
WebDNA won't start on reboot (2003)