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[search db=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&LINE_I Dsumm=T]<-----change hereTechnical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of David Anderson Sent: Wednesday, April 12, 2000 4:37 PM To: WebCatalog Talk Subject: 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, it doesn't make a difference, even if I take out the first one. Ideas? [search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [search db=[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: 24 Line ID: 24 Line ID: 24 Line ID: 24 Line ID: 24 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 34 Line ID: 34 Line ID: 34-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of WebDNA Support Sent: Wednesday, April 12, 2000 4:07 PM To: WebCatalog Talk Subject: Re: Search results output problems.. Is [ID] a unique number for each recorded in the cruise.db, try summ=T on a different field or take 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 Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of David Anderson Sent: Wednesday, April 12, 2000 3:54 PM To: WebCatalog Talk Subject: Search results output problems.. I'm trying to do a few search db's inside of eachother, but when trying to sort results, it doesn't work too well at all. Heres the code: I took out the last [/founditems] and [/search] in the email. What happens is that I'm trying to use the Summ=t command, but it won't work on the final search using the cruise.db. I only want to display the [LINE_ID]'s once and not repeat themselves. Any suggestions?Thanks - David Anderson-------------------------------------------------- [search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [search db=[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 add summ=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[search db=[path]itinerary.db&eqPORT_IDdatarq=[PORT_ID]&asIDsort=1&IDtype=num&LINE_I Dsumm=T]<-----change hereTechnical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of David Anderson Sent: Wednesday, April 12, 2000 4:37 PM To: WebCatalog Talk Subject: 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, it doesn't make a difference, even if I take out the first one. Ideas? [search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [search db=[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: 24 Line ID: 24 Line ID: 24 Line ID: 24 Line ID: 24 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 1 Line ID: 34 Line ID: 34 Line ID: 34-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of WebDNA Support Sent: Wednesday, April 12, 2000 4:07 PM To: WebCatalog Talk Subject: Re: Search results output problems.. Is [ID] a unique number for each recorded in the cruise.db, try summ=T on a different field or take 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 Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 *********************************-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of David Anderson Sent: Wednesday, April 12, 2000 3:54 PM To: WebCatalog Talk Subject: Search results output problems.. I'm trying to do a few search db's inside of eachother, but when trying to sort results, it doesn't work too well at all. Heres the code: I took out the last [/founditems] and [/search] in the email. What happens is that I'm trying to use the Summ=t command, but it won't work on the final search using the cruise.db. I only want to display the [LINE_ID]'s once and not repeat themselves. Any suggestions?Thanks - David Anderson-------------------------------------------------- [search db=[path]port.db&bwPORTdatarq=[__PORT]] [founditems] [search db=[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 add summ=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:
Limit on nested [ShowIf]'s? (1997)
WebCat2b12 - nesting [tags] (1997)
Payment Processors (2005)
Problem upgrading from 3.0.8 to 4.0 on MS Windoze 98 / PWS (2000)
Netscape Communicator 4 (1997)
can we get string variables? (1998)
A little syntax help (1997)
All questions are welcome on this list (1997)
multiple search commands (1997)
Help! WebCat2 bug (1997)
Mime Headers for Mail (1998)
NT or Mac (1998)
what include am I using! (2005)
Limiting user access to .tmpl files (1997)
WC1.6 to WC2 date formatting (1997)
& Aftermath (1999)
Re:Emailer setup (1997)
[WebDNA] OS X mail server (2009)
WebCat2 - Getting to the browser's username/password data (1997)
Merging databases (1997)