Re: Possible Bug 4.51
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55611
interpreted = N
texte = Just checked the code. It is set to NUM???----- Original Message ----- From: Matthew A PerosiTo: WebDNA TalkSent: Wednesday, January 21, 2004 3:52 PMSubject: Re: Possible Bug 4.51Well if it "basically just a big number" then you *really* should haveTHEDATETIMEtype=num because from day to day I've seen my sorting routinesgive back totally erratic answers when I don't specify the type and itdefaults to whatever ASCII routine is built in.MattBrian Boegershausen wrote:I will give it a shot.The date time field is actually the date in [math] format * 86000 + the timein math format. So basically just a big number.----- Original Message ----- From: "Matthew A Perosi"
To: "WebDNA Talk" Sent: Wednesday, January 21, 2004 3:21 PMSubject: Re: Possible Bug 4.51What happens if you [url] the GROUP1 data?i.e.&eqGROUP1datarq=[url]UnitedStates[/url]&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCountry&asTHEDATETIMEsort=1also, just a thought, do you need to specify THEDATETIMEtype as [date] or[time]?Matt PerosiBrian Boegershausen wrote:When running some searches on my clients, I am noticing a major problem.I do 2 searches for the exact same data.&eqGROUP1datarq=UnitedStates&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCountry&asTHEDATETIMEsort=1#1 searches and only finds data in the Post_Country field.It sorts properly.in search 2, results are found that have the country listed in more thanoneof the Group1 fields and sorts the list differently.It shows results sorted by GROUP1field then by THEDATETIMEBasically it is doing &asGROUP1sort=1&asTHEDATETIMEsort=2Why is this happening???Windows 2000 AdvancedWebDNA 4.51Brian-------------------------------------------------------------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 toWeb 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 toWeb 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 toWeb Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------- This messageis sent to you because you are subscribed to the mailing list . Tounsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archiveof 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:
Just checked the code. It is set to NUM???----- Original Message ----- From: Matthew A PerosiTo: WebDNA TalkSent: Wednesday, January 21, 2004 3:52 PMSubject: Re: Possible Bug 4.51Well if it "basically just a big number" then you *really* should haveTHEDATETIMEtype=num because from day to day I've seen my sorting routinesgive back totally erratic answers when I don't specify the type and itdefaults to whatever ASCII routine is built in.MattBrian Boegershausen wrote:I will give it a shot.The date time field is actually the date in [math] format * 86000 + the timein math format. So basically just a big number.----- Original Message ----- From: "Matthew A Perosi" To: "WebDNA Talk" Sent: Wednesday, January 21, 2004 3:21 PMSubject: Re: Possible Bug 4.51What happens if you [url] the GROUP1 data?i.e.&eqGROUP1datarq=[url]UnitedStates[/url]&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCountry&asTHEDATETIMEsort=1also, just a thought, do you need to specify THEDATETIMEtype as [date] or[time]?Matt PerosiBrian Boegershausen wrote:When running some searches on my clients, I am noticing a major problem.I do 2 searches for the exact same data.&eqGROUP1datarq=UnitedStates&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCountry&asTHEDATETIMEsort=1#1 searches and only finds data in the Post_Country field.It sorts properly.in search 2, results are found that have the country listed in more thanoneof the Group1 fields and sorts the list differently.It shows results sorted by GROUP1field then by THEDATETIMEBasically it is doing &asGROUP1sort=1&asTHEDATETIMEsort=2Why is this happening???Windows 2000 AdvancedWebDNA 4.51Brian-------------------------------------------------------------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 toWeb 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 toWeb 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 toWeb Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------- This messageis sent to you because you are subscribed to the mailing list . Tounsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archiveof 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/
"Brian Boegershausen"
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:
Nested tags count question (1997)
Separate SSL Server (1997)
CC: (1998)
[WebDNA] contents of db files disappearing including triggers.db (2019)
Security Tip (1996)
[NT] ie 4.0 required (1997)
[WebDNA] Auto Suggest Form (2014)
apostrophe in search item (1997)
pc (1997)
Database cannot be opened (2005)
SAVECART (1997)
Automated FTP from Shell - Update (2004)
Webcat XML/XSLT Performance vs. static Html (2006)
math on date? (1997)
Thanks... (1999)
webten vs. webstar (1998)
Encrypted items in DB (2001)
Attention all list readers (1997)
Help- Linux Install Serial number not taling. (2000)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)