Re: Help with searching dates from mysql dump & searching
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 68109
interpreted = N
texte = My bad on why the search isn't working, you're right of course, a ge OR le on the text string would work. Problem here is you can't search the same data field twice, so the le is being ignored. I can't see any way to get a ranged search with just the one field if it isn't a date or number. GJK At 11:33 PM 11/5/2006, you wrote: >Thanks Gary. I guess that's my plan b. Would like to work with the raw data >(date & time in one field) if possible. It seems like the "ge" search tags >works perfectly fine on text strings. The "le" just doesn't seem to work >opposite of "ge" on text strings. These search parameters are supposed to >work on text strings??? > >Guess it's on to plan b. ------------------------------------------------------------- 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:
My bad on why the search isn't working, you're right of course, a ge OR le on the text string would work. Problem here is you can't search the same data field twice, so the le is being ignored. I can't see any way to get a ranged search with just the one field if it isn't a date or number. GJK At 11:33 PM 11/5/2006, you wrote: >Thanks Gary. I guess that's my plan b. Would like to work with the raw data >(date & time in one field) if possible. It seems like the "ge" search tags >works perfectly fine on text strings. The "le" just doesn't seem to work >opposite of "ge" on text strings. These search parameters are supposed to >work on text strings??? > >Guess it's on to plan b. ------------------------------------------------------------- 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/
Gary Krockover
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:
Preventng cacheing (2000)
serial number generation (1997)
Secure Server basic question... (1997)
WebCatalog seems to choke on large (2meg) html files. (1998)
Getting total number of items ordered (1997)
PIXO support (1997)
listfields question (2005)
Max Record length restated as maybe bug (1997)
different show next (1997)
logic help (1998)
NT version and O'reily's WebSite (1997)
Nested search (1997)
Aaron Kant do contextses (2000)
I'm new be kind (1997)
Passing [quantity] (2000)
send mail problem? (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Join us at MacWorld! - Part 2 (1998)
Sorting problem (1997)
Trouble with formula.db + more explanation (1997)