Re: Strange Search Results
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56049
interpreted = N
texte = Hi Justin,It seems to me that when searching on your test, text characters are beingignored. I tried searching on 731hjkahjk987 and it returned the record with731987.Erol----- Original Message -----From: "Justin Carroll"
To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 6:04 PMSubject: Re: Strange Search Results> This is a link to my test:> http://secure.sanduskyregister.com/justin/test/>> Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does itreturn sku 1 and 3 but not 2? Thanks.>> Justin Carroll>> On Thursday, April 1, 1943, WebDna @ Inkblot Media wrote:> >Hi Justin,> >> >Your search seems to be:> >> >[search>>db=database.db&eqend_datedata=[url][txtKeyword][/url]&end_datetype=num&end_d> >atesdir=de]> >> >It does not return all record in my DB.> >> >See here:> >http://www.inkblotmedia.com/justin/> >> >Ron> >> >> >----- Original Message -----> >From: "Justin Carroll" > >To: "WebDNA Talk" > >Sent: Wednesday, February 11, 2004 9:02 AM> >Subject: Re: Strange Search Results> >> >> >I've tried everything suggested. Nothing seems to work. It's such asimple> >search string to return such a problem. I'm open to any othersuggestions.> >Thank you.> >> >Justin Carroll> >> >On Thursday, April 1, 1943, Kenneth Grome wrote:> >>>This is my search string:> >>>[search>>>>db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_d> >atesdir=de]> >>>> >>>In my database, end_date holds numerical date values (ex. 735748).> >>>> >>>When I search for "735748" it will pull just that record. This is> >>>fine. But can someone explain to me why when I search for any text> >>>(ex. alsdlajsdf) that this search returns all the records in my> >>>database instead of nothing? Thanks.> >>> >>> >>Because you're supposed to put a comparison operator in front of> >>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or> >>"wa" or some other comparison operator in front, then see what kind> >>of results you get ... :)> >>--> >>> >>Kenneth Grome> >>WebDNA Programmer> >>Outsource Service Provider> >>Phone: +6332 255-6591> >>> >>-------------------------------------------------------------> >>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:
Hi Justin,It seems to me that when searching on your test, text characters are beingignored. I tried searching on 731hjkahjk987 and it returned the record with731987.Erol----- Original Message -----From: "Justin Carroll" To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 6:04 PMSubject: Re: Strange Search Results> This is a link to my test:> http://secure.sanduskyregister.com/justin/test/>> Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does itreturn sku 1 and 3 but not 2? Thanks.>> Justin Carroll>> On Thursday, April 1, 1943, WebDna @ Inkblot Media wrote:> >Hi Justin,> >> >Your search seems to be:> >> >[search>>db=database.db&eqend_datedata=[url][txtKeyword][/url]&end_datetype=num&end_d> >atesdir=de]> >> >It does not return all record in my DB.> >> >See here:> >http://www.inkblotmedia.com/justin/> >> >Ron> >> >> >----- Original Message -----> >From: "Justin Carroll" > >To: "WebDNA Talk" > >Sent: Wednesday, February 11, 2004 9:02 AM> >Subject: Re: Strange Search Results> >> >> >I've tried everything suggested. Nothing seems to work. It's such asimple> >search string to return such a problem. I'm open to any othersuggestions.> >Thank you.> >> >Justin Carroll> >> >On Thursday, April 1, 1943, Kenneth Grome wrote:> >>>This is my search string:> >>>[search>>>>db=database.db&end_datedata=[url][txtKeyword][/url]&end_datetype=num&end_d> >atesdir=de]> >>>> >>>In my database, end_date holds numerical date values (ex. 735748).> >>>> >>>When I search for "735748" it will pull just that record. This is> >>>fine. But can someone explain to me why when I search for any text> >>>(ex. alsdlajsdf) that this search returns all the records in my> >>>database instead of nothing? Thanks.> >>> >>> >>Because you're supposed to put a comparison operator in front of> >>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or> >>"wa" or some other comparison operator in front, then see what kind> >>of results you get ... :)> >>--> >>> >>Kenneth Grome> >>WebDNA Programmer> >>Outsource Service Provider> >>Phone: +6332 255-6591> >>> >>-------------------------------------------------------------> >>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/
"Erol Guneri"
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:
[OT] On a side note.. (2003)
Multiple 'Users.db' files not possible (1997)
[WebDNA] [MATH] strangeness (2013)
convert characters (2003)
grouped fields? (1999)
my price won't move (1997)
re: Large databases in WebCat (1997)
PSC recommends what date format yr 2000??? (1997)
[cart] number range ?? (2001)
WebCat2b12--[searchstring] bug (1997)
type 2 errors with ssl server (1997)
Two prices in shoppingcart? (1997)
WebCatalog for guestbook ? (1997)
Separate SSL Server (1997)
[delete] problem (1997)
WebCatalog for Postcards ? (1997)
Strange intermittent WebDNA problems (2008)
TCPConnect (2005)
WCS Newbie question (1997)
WC 2.0 frames feature (1997)