Re: Strange Search Results
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56050
interpreted = N
texte = Thanks.On Friday, April 2, 1943, Erol Guneri
wrote:>Hi Justin,>>It seems to me that when searching on your test, text characters are =being>ignored. I tried searching on 731hjkahjk987 and it returned the record =with>731987.>>Erol>>----- Original Message ----->From: "Justin Carroll" >To: "WebDNA Talk" >Sent: Wednesday, February 11, 2004 6:04 PM>Subject: 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 =it>return 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=3Ddatabase.db&eqend_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_>d>> >atesdir=3Dde]>> >>> >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 a>simple>> >search string to return such a problem. I'm open to any other>suggestions.>> >Thank you.>> >>> >Justin Carroll>> >>> >On Thursday, April 1, 1943, Kenneth Grome wrote:>> >>>This is my search string:>> >>>[search>>>>>>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_>d>> >atesdir=3Dde]>> >>>>> >>>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/>-------------------------------------------------------------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:
Thanks.On Friday, April 2, 1943, Erol Guneri wrote:>Hi Justin,>>It seems to me that when searching on your test, text characters are =being>ignored. I tried searching on 731hjkahjk987 and it returned the record =with>731987.>>Erol>>----- Original Message ----->From: "Justin Carroll" >To: "WebDNA Talk" >Sent: Wednesday, February 11, 2004 6:04 PM>Subject: 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 =it>return 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=3Ddatabase.db&eqend_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_>d>> >atesdir=3Dde]>> >>> >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 a>simple>> >search string to return such a problem. I'm open to any other>suggestions.>> >Thank you.>> >>> >Justin Carroll>> >>> >On Thursday, April 1, 1943, Kenneth Grome wrote:>> >>>This is my search string:>> >>>[search>>>>>>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_>d>> >atesdir=3Dde]>> >>>>> >>>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/>-------------------------------------------------------------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/
Justin Carroll
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:
Re:no [search] with NT (1997)
database size? (1997)
Math with Time (1997)
Tip O' the Week (1996)
WebCatalog Hosting (1996)
LookUp Tag (1997)
Setting up WebCatalog with Retail Pro data (1996)
[WebDNA] fastcgi 7+ & [cart]? (2010)
Erotic Sites (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Email (1998)
Multiple fields on 1 input (1997)
customizing the color of user's pages (1997)
Template Cache problem, bombing WebSTAR problem (2000)
Mail Integration (1999)
Dummy Form Variables Needed (2000)
Re:2nd WebCatalog2 Feature Request (1996)
WebCatalog2 Feature Feedback (1996)
encrypted query string trouble on OSX (2001)
Sku numbers (1997)