Re: [WebDNA] Unexpected search results

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111686
interpreted = N
texte = Glad you got it sorted. You don=92t need to use grouping now that you eliminated the second = comparison on productid. Sincerely, Donovan On Nov 18, 2014, at 5:24 PM, Diane Blackmore = wrote: > Hi >=20 > That has worked Raymond, thanks for that. I excluded the type and = used; >=20 > search = db=3D../db/products.db&eqlivedatarq=3DT&woocc_idsdatarq=3D400004&wnproduct= iddatarq=3D1132192 1132188 &max=3D22&startat=3D1 >=20 > Be interesting to see what happens when there are more than two = product ids to exclude, but it should be fine. Would still like to know = why the =91ne=92 comparison didn=92t work. >=20 >=20 > Donovan - I wasn=92t searching across multiple fields, so grouping = doesn=92t appear to be relevant - there is only one field in > "&neproductiddatarq=3D1132192&neproductiddatarq=3D1132188" > Appreciate the input and prompt response however. >=20 >=20 > Cheers, >=20 >=20 > >=20 >=20 > On 19/11/2014, at 11:30 am, Raymond Borhan = wrote: >=20 >> Try: >>=20 >> [search = db=3D../db/products.db&productidtype=3Dnum&eqlivedatarq=3DT&woocc_idsdatar= q=3D400004&wnproductiddatarq=3D1132192 1132188&max=3D22&startat=3D1] >>=20 >> Also, ideally I would exclude the prodcutidtype since it's not = necessary (you're not using a greater than less than comparison operator = or a sort), and i'd use eq instead of wo in woocc_idsdatarq: >>=20 >> [search = db=3D../db/products.db&eqlivedatarq=3DT&eqocc_idsdatarq=3D400004&wnproduct= iddatarq=3D1132192 1132188&max=3D22&startat=3D1] >>=20 >> I tried to respond via the talk address but apparently i am blocked = from posting for some reason... >>=20 >> On Tue, Nov 18, 2014 at 5:15 PM, Diane Blackmore = wrote: >> Hi >>=20 >> The following search string is failing to exclude the two results I=92m= trying to exclude; >>=20 >> [search = db=3D../db/products.db&productidtype=3Dnum&eqlivedatarq=3DT&woocc_idsdatar= q=3D400004&neproductiddatarq=3D1132192&neproductiddatarq=3D1132188&max=3D2= 2&startat=3D1] >>=20 >> Field names in the above are productid, live, occ_ids - so no typo=92s= anywhere. (occ_ids has multiple comma-delimited numeric entries which = is why I=92m using =93wo=94 instead of another comparison) >>=20 >> I get the right results for the search, but the two product id=92s = that I=92m trying to exclude are still in the results. I could work = around with a hideif, but it=92ll create a mess on the following pages = so I really want to avoid this - and I don=92t feel I should have to = anyway, since I can=92t see why the string above wouldn=92t work. >>=20 >> Running WebDNA 6.2 Server on Ubuntu 12.0.4 LTS with Apache2 >>=20 >> Any ideas anyone? >>=20 >>=20 >> Thanks, >>=20 >> >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Unexpected search results (Donovan Brooke 2014)
  2. Re: [WebDNA] Unexpected search results (Diane Blackmore 2014)
  3. Re: [WebDNA] Unexpected search results (Donovan Brooke 2014)
  4. [WebDNA] Unexpected search results (Diane Blackmore 2014)
Glad you got it sorted. You don=92t need to use grouping now that you eliminated the second = comparison on productid. Sincerely, Donovan On Nov 18, 2014, at 5:24 PM, Diane Blackmore = wrote: > Hi >=20 > That has worked Raymond, thanks for that. I excluded the type and = used; >=20 > search = db=3D../db/products.db&eqlivedatarq=3DT&woocc_idsdatarq=3D400004&wnproduct= iddatarq=3D1132192 1132188 &max=3D22&startat=3D1 >=20 > Be interesting to see what happens when there are more than two = product ids to exclude, but it should be fine. Would still like to know = why the =91ne=92 comparison didn=92t work. >=20 >=20 > Donovan - I wasn=92t searching across multiple fields, so grouping = doesn=92t appear to be relevant - there is only one field in > "&neproductiddatarq=3D1132192&neproductiddatarq=3D1132188" > Appreciate the input and prompt response however. >=20 >=20 > Cheers, >=20 >=20 > >=20 >=20 > On 19/11/2014, at 11:30 am, Raymond Borhan = wrote: >=20 >> Try: >>=20 >> [search = db=3D../db/products.db&productidtype=3Dnum&eqlivedatarq=3DT&woocc_idsdatar= q=3D400004&wnproductiddatarq=3D1132192 1132188&max=3D22&startat=3D1] >>=20 >> Also, ideally I would exclude the prodcutidtype since it's not = necessary (you're not using a greater than less than comparison operator = or a sort), and i'd use eq instead of wo in woocc_idsdatarq: >>=20 >> [search = db=3D../db/products.db&eqlivedatarq=3DT&eqocc_idsdatarq=3D400004&wnproduct= iddatarq=3D1132192 1132188&max=3D22&startat=3D1] >>=20 >> I tried to respond via the talk address but apparently i am blocked = from posting for some reason... >>=20 >> On Tue, Nov 18, 2014 at 5:15 PM, Diane Blackmore = wrote: >> Hi >>=20 >> The following search string is failing to exclude the two results I=92m= trying to exclude; >>=20 >> [search = db=3D../db/products.db&productidtype=3Dnum&eqlivedatarq=3DT&woocc_idsdatar= q=3D400004&neproductiddatarq=3D1132192&neproductiddatarq=3D1132188&max=3D2= 2&startat=3D1] >>=20 >> Field names in the above are productid, live, occ_ids - so no typo=92s= anywhere. (occ_ids has multiple comma-delimited numeric entries which = is why I=92m using =93wo=94 instead of another comparison) >>=20 >> I get the right results for the search, but the two product id=92s = that I=92m trying to exclude are still in the results. I could work = around with a hideif, but it=92ll create a mess on the following pages = so I really want to avoid this - and I don=92t feel I should have to = anyway, since I can=92t see why the string above wouldn=92t work. >>=20 >> Running WebDNA 6.2 Server on Ubuntu 12.0.4 LTS with Apache2 >>=20 >> Any ideas anyone? >>=20 >>=20 >> Thanks, >>=20 >> >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us Donovan Brooke

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:

WebCat2b15MacPlugin - [protect] (1997) [SHOWIF]s and empty arguments (1997) All questions are welcome on this list (1997) Looking For WebCatalog Migration Assistance (2003) WebTen and WebCat (1997) hotmail filtering emails (2004) emailer (1997) Server IP address? (1998) WebDNA on RedHat ES 4 (2007) Practice runs ? (1997) Subtotal Not Calculated on Invoice.html (1998) WebCatalog2 Feature Feedback (1996) ANother SHOWIF problem (1997) WebCat NT v. Mac (1997) Next X hits (1996) RedHat Linux glibc version 2.1.2 or higher required (2000) Multiple Newcarts (1996) Multihoming and webcat (1998) [showif] based on data from [tcpconnect][tcpsend]? (2000) Just Testing (1997)