Re: URGENT: BUG, woFIELDdata & FIELDword=ww
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45627
interpreted = N
texte = You cant do word comparisons on number fields .. For the purpose of thissearch the PRODUCT_GROUP field is a 'unique' string ..> How about &PRODUCT_GROUPtype=num ?> > Regards,> Tim> >> From: Alain Russell
>> Reply-To: (WebCatalog Talk)>> Date: Fri, 22 Nov 2002 18:17:38 +1300>> To: (WebCatalog Talk)>> Subject: Re: URGENT: BUG, woFIELDdata & FIELDword=ww>> >> No - the field is actually called PRODUCT_GROUP .. I shortened the name for>> the purpose of the email ;)>> >>> Is it possible that the problem may be that your field is named 'group', and>>> WedDNA is getting a bit confused with grouped fields?>>> >>> >>>> From: Alain Russell >>>> Reply-To: (WebCatalog Talk)>>>> Date: Fri, 22 Nov 2002 18:04:41 +1300>>>> To: (WebCatalog Talk)>>>> Subject: URGENT: BUG, woFIELDdata & FIELDword=ww>>>> >>>> I saw this in the archives a few days ago and now it has affected us ..>>>> We have a search as follows>>>> >>>> [search db=products.db&woGROUPdata=400.2,400.9,2&GROUPword=ww&GROUPwbrk=,]>>>> >>>> This unfortunately returns groups as follows>>>> >>>> 51.2>>>> 800.2>>>> 400.2>>>> 2>>>> 400.9>>>> >>>> As you can see the results are not as they should be .. When we take 2 out>>>> of the search string this works perfectly. We have tried all sorts of other>>>> delimiters and the results are the same.>>>> >>>> Can someone please confirm this and let us know when a fix is coming ?? Ken>>>> mentioned in his response he knew of this a couple of years ago - WebDNA>>>> cannot ignore it's internet delimiters when &wbrk= is specified in the>>>> search ? Perhaps this could be squeezed into the 4.5.1 patch ?>>>> >>>> We need to get this problem fixed to get signoff on a job .. No signoff, no>>>> money ;(>>>> >>>> Thanks>>>> Alain>>>> >>>> >>>> ------------------------------------------------------------->>>> 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://webdna.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://webdna.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://webdna.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://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You cant do word comparisons on number fields .. For the purpose of thissearch the PRODUCT_GROUP field is a 'unique' string ..> How about &PRODUCT_GROUPtype=num ?> > Regards,> Tim> >> From: Alain Russell >> Reply-To: (WebCatalog Talk)>> Date: Fri, 22 Nov 2002 18:17:38 +1300>> To: (WebCatalog Talk)>> Subject: Re: URGENT: BUG, woFIELDdata & FIELDword=ww>> >> No - the field is actually called PRODUCT_GROUP .. I shortened the name for>> the purpose of the email ;)>> >>> Is it possible that the problem may be that your field is named 'group', and>>> WedDNA is getting a bit confused with grouped fields?>>> >>> >>>> From: Alain Russell >>>> Reply-To: (WebCatalog Talk)>>>> Date: Fri, 22 Nov 2002 18:04:41 +1300>>>> To: (WebCatalog Talk)>>>> Subject: URGENT: BUG, woFIELDdata & FIELDword=ww>>>> >>>> I saw this in the archives a few days ago and now it has affected us ..>>>> We have a search as follows>>>> >>>> [search db=products.db&woGROUPdata=400.2,400.9,2&GROUPword=ww&GROUPwbrk=,]>>>> >>>> This unfortunately returns groups as follows>>>> >>>> 51.2>>>> 800.2>>>> 400.2>>>> 2>>>> 400.9>>>> >>>> As you can see the results are not as they should be .. When we take 2 out>>>> of the search string this works perfectly. We have tried all sorts of other>>>> delimiters and the results are the same.>>>> >>>> Can someone please confirm this and let us know when a fix is coming ?? Ken>>>> mentioned in his response he knew of this a couple of years ago - WebDNA>>>> cannot ignore it's internet delimiters when &wbrk= is specified in the>>>> search ? Perhaps this could be squeezed into the 4.5.1 patch ?>>>> >>>> We need to get this problem fixed to get signoff on a job .. No signoff, no>>>> money ;(>>>> >>>> Thanks>>>> Alain>>>> >>>> >>>> ------------------------------------------------------------->>>> 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://webdna.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://webdna.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://webdna.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://webdna.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://webdna.smithmicro.com/
Alain Russell
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:
Database Structure? (1998)
Associative lookup style? + bit more (1997)
protect tag on NT IIS (1997)
Decimal point in search.... (2004)
update on include (1997)
Searching multiple Databases (1997)
using listfiles to build a database? more (2000)
test (2006)
target=_blank and form variables (1997)
PCS Frames (1997)
ReturnRaw Returns (2000)
[WebDNA] Installation problems for IIS 6 (2010)
Too Much Rootbeer Free Offer (1997)
If search results are blank... (2003)
New (1998)
Tab Charactor (1997)
[SHOWIF] (1997)
WebCat chatroom (1997)
When is unitShipCost calculated? (1998)
Using Plug-In while running 1.6.1 (1997)