Re: Strange Search Results
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56033
interpreted = N
texte = 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 CarrollOn Thursday, April 1, 1943, Kenneth Grome
wrote:>>This is my search string:>>[search=20>>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_datesdir=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=20>>fine. But can someone explain to me why when I search for any text=20>>(ex. alsdlajsdf) that this search returns all the records in my=20>>database instead of nothing? Thanks.>>>Because you're supposed to put a comparison operator in front of=20>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or=20>"wa" or some other comparison operator in front, then see what kind=20>of results you get ... :)>--=20>>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/
Associated Messages, from the most recent to the oldest:
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 CarrollOn Thursday, April 1, 1943, Kenneth Grome wrote:>>This is my search string:>>[search=20>>db=3Ddatabase.db&end_datedata=3D[url][txtKeyword][/url]&end_=datetype=3Dnum&end_datesdir=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=20>>fine. But can someone explain to me why when I search for any text=20>>(ex. alsdlajsdf) that this search returns all the records in my=20>>database instead of nothing? Thanks.>>>Because you're supposed to put a comparison operator in front of=20>"end_datedata" but you didn't. Try putting "eq" or "ne" or "wo" or=20>"wa" or some other comparison operator in front, then see what kind=20>of results you get ... :)>--=20>>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/
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:
Running 2 two WebCatalog.acgi's (1996)
IPADDRESS mystery (2003)
Check boxes (1997)
Nested vs conditional (1997)
default value from Lookup (was Grant, please help me) (1997)
WCS Newbie question (1997)
Disappearing data [OT] (2002)
letterrip and webcats emailer (1998)
A quickie question (1997)
WebCat for mass emailings (1997)
[WebDNA] [announce] CICADA Gold Products (2009)
Clear/Reset form with JavaScript (2001)
WebCatalog stalls (1998)
Integration with SQL (1997)
Dual 2GHz G5 (2003)
Need relative path explanation (1997)
removing commas from a preformatted number (2000)
Include a big block of text (1997)
Another question (1997)
[ShowIf] a either fields are blank (1998)