Re: Sorting problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41395
interpreted = N
texte = 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 luckIt 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 SpecialistDon 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/
Associated Messages, from the most recent to the oldest:
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 luckIt 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 SpecialistDon 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/
Don
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:
[WebDNA] XML Help please (2009)
expired beta (1997)
timing out? (1997)
Email within tmpl ? (1997)
Database changes (1998)
Replacing a variable within a variable. (1998)
Simple way to create unique SKU (1997)
All choices on IE different than Netscape (1997)
re: [addlineitem] working almost (1997)
OT: CT Scan might have saved my life!! (2006)
[WebDNA] Hard-coded db write delay when running certain code? (2011)
[WebDNA] Fails to recognize comma-separated db (2010)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Clearly.home (1998)
How to implement 'email to a friend' feature? (2002)
Text Areas, Sendmail and returns.... (2002)
Help! WebCat2 bug (1997)
Running subtotal? (1998)
WebCat2 - [format thousands] (1997)
Multiple prices (1997)