Re: Strange Search Results
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56041
interpreted = N
texte = That is interesting. When I change 3 records to END_DATE 0 I get them too. Simple fix is to stop putting zero in the END_DATE field. Though I cannot answer why. I think it is treating it as a blank value. ----- Original Message ----- From: "Justin Carroll"
To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 10:04 AM 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=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 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=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:
That is interesting. When I change 3 records to END_DATE 0 I get them too. Simple fix is to stop putting zero in the END_DATE field. Though I cannot answer why. I think it is treating it as a blank value. ----- Original Message ----- From: "Justin Carroll" To: "WebDNA Talk" Sent: Wednesday, February 11, 2004 10:04 AM 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=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 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=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/
"WebDna @ Inkblot Media"
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:
Trigger problem (2003)
quick GREP question (2001)
simple answer? [hideif] (1997)
[WebDNA] Non-numbers entered into a field that asks for a number (2008)
OT: JS Q (2003)
[OT] DOD again (2003)
Followup question re: checksum for credit cards? (1997)
Calculating multiple shipping... (1997)
WebCat b13 CGI -shownext- (1997)
form crasehes server (1997)
DomainList (2005)
carriage returns in data (1997)
A question about security (1998)
[OT] degree symbol (2003)
WebCatalog2 Feature Feedback (1996)
F3 crashing server (1997)
snicker, snicker (1997)
PCS Frames (1997)
Replace with Producteditor.tpl (2000)
OT - Dig Sigs (2004)