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:
Huge databases and RAM (1998)
Standalone Testing (1998)
Happy Halloween - Check out the pumpkin (2002)
Search/sort in URL Was: GuestBook example (1997)
form data submission gets truncated (1997)
WebCatalog 4.0.2b5 available (2000)
Emailer (1997)
WebCatalog for NT (1999)
Sample Tearoom Search Error (1997)
Problems appending to database (1997)
WebCatalog can't find database (1997)
Pacific Coast Software responsiveness (was WebMerchant - MacAuthorize) (1999)
WebCat is different user (1999)
ODBC on OSX continued (2002)
PCS Emailer's role ? (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
expired beta (1997)
NetSplat and WebCat2 (1997)
Trouble with formula.db (1997)
Problems problems problems (1997)