Re: Search results output problems..
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30424
interpreted = N
texte = What happens when you replace ID with Line_ID for summ=T[searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&LINE_IDsumm=T]<-----change hereTechnical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of David AndersonSent: Wednesday, April 12, 2000 4:37 PMTo: WebCatalog TalkSubject: Re: Search results output problems..Here's the code and output...if I try to put&asLINE_IDsort=1&LINE_IDtype=num&LINE_IDsumm=t in the bottom search, itdoesn't make a difference, even if I take out the first one. Ideas?[search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&IDsumm=T] [FOUNDITEMS] [search db=[path]cruise.db&eqIDdatarq=[ID]] [FOUNDITEMS] [LINE_ID]Line ID: 24Line ID: 24Line ID: 24Line ID: 24Line ID: 24Line ID: 1Line ID: 1Line ID: 1Line ID: 1Line ID: 1Line ID: 34Line ID: 34Line ID: 34-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of WebDNA SupportSent: Wednesday, April 12, 2000 4:07 PMTo: WebCatalog TalkSubject: Re: Search results output problems..Is [ID] a unique number for each recorded in the cruise.db, try summ=T on adifferent field ortake a look at the database and make sure [ID] has multiple entriesTechnical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of David AndersonSent: Wednesday, April 12, 2000 3:54 PMTo: WebCatalog TalkSubject: Search results output problems..I'm trying to do a few search db's inside of eachother, but when trying tosort results, it doesn't work too well at all. Heres the code: I took outthe last [/founditems] and [/search] in the email. What happens is that I'mtrying to use the Summ=t command, but it won't work on the final searchusing the cruise.db. I only want to display the [LINE_ID]'s once and notrepeat themselves. Any suggestions?Thanks - David Anderson--------------------------------------------------[search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&IDsumm=T] <--- This one works correctly [FOUNDITEMS] Itinerary ID: [ID] - [search db=[path]cruise.db&eqIDdatarq=[ID]] <--- If I try to addsumm=T, it won't do anything. [FOUNDITEMS] Line ID: [LINE_ID]-----------------------------------------------------------------------------------------------------------------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-------------------------------------------------------------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-------------------------------------------------------------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-------------------------------------------------------------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
Associated Messages, from the most recent to the oldest:
What happens when you replace ID with Line_ID for summ=T[searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&LINE_IDsumm=T]<-----change hereTechnical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of David AndersonSent: Wednesday, April 12, 2000 4:37 PMTo: WebCatalog TalkSubject: Re: Search results output problems..Here's the code and output...if I try to put&asLINE_IDsort=1&LINE_IDtype=num&LINE_IDsumm=t in the bottom search, itdoesn't make a difference, even if I take out the first one. Ideas?[search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&IDsumm=T] [founditems] [search db=[path]cruise.db&eqIDdatarq=[ID]] [founditems] [LINE_ID]Line ID: 24Line ID: 24Line ID: 24Line ID: 24Line ID: 24Line ID: 1Line ID: 1Line ID: 1Line ID: 1Line ID: 1Line ID: 34Line ID: 34Line ID: 34-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of WebDNA SupportSent: Wednesday, April 12, 2000 4:07 PMTo: WebCatalog TalkSubject: Re: Search results output problems..Is [ID] a unique number for each recorded in the cruise.db, try summ=T on adifferent field ortake a look at the database and make sure [ID] has multiple entriesTechnical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of David AndersonSent: Wednesday, April 12, 2000 3:54 PMTo: WebCatalog TalkSubject: Search results output problems..I'm trying to do a few search db's inside of eachother, but when trying tosort results, it doesn't work too well at all. Heres the code: I took outthe last [/founditems] and [/search] in the email. What happens is that I'mtrying to use the Summ=t command, but it won't work on the final searchusing the cruise.db. I only want to display the [LINE_ID]'s once and notrepeat themselves. Any suggestions?Thanks - David Anderson--------------------------------------------------[search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [searchdb=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&IDsumm=T] <--- This one works correctly [founditems] Itinerary ID: [ID] - [search db=[path]cruise.db&eqIDdatarq=[ID]] <--- If I try to addsumm=T, it won't do anything. [founditems] Line ID: [LINE_ID]-----------------------------------------------------------------------------------------------------------------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-------------------------------------------------------------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-------------------------------------------------------------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-------------------------------------------------------------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
WebDNA Support
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:
A quickie question (1997)
Frames and WebCat (1997)
Install problems on 3.08 (2000)
[format] (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
2.0 Info (1997)
Emailer prefs in two places ... (1997)
Web Merchant process after credit card clears (1998)
weird G3 happenings (1998)
WebCat2b13 Command Reference Doc error (1997)
Summing fields (1997)
Problems reading files created by WC (1997)
vs (1997)
Banner ads example (1997)
ShippingCosts Help Needed (1998)
hiding return characters (2000)
capitalize each word? (2002)
WebCatalog/WebDNA Hosting? (2006)
Requiring that certain fields be completed (1997)
RE: Cart Template (1997)