Re: Possible Bug 4.51

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55610
interpreted = N
texte = Well if it "basically just a big number" then you *really* should have THEDATETIMEtype=num because from day to day I've seen my sorting routines give back totally erratic answers when I don't specify the type and it defaults to whatever ASCII routine is built in.

Matt

Brian 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" <matt@psiprime.com>To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Sent: Wednesday, January 21, 2004 3:21 PMSubject: Re: Possible Bug 4.51  
What happens if you [url] the GROUP1 data?i.e.&eqGROUP1datarq=[url]United    
States[/url]&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCount  
ry&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=United      
States&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCoun    
t  
ry&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 than      
one  
of 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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to      
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to    
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>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:

    
  1. Re: Possible Bug 4.51 ( Kenneth Grome 2004)
  2. Re: Possible Bug 4.51 ( "Brian Boegershausen" 2004)
  3. Re: Possible Bug 4.51 ( Brian Fries 2004)
  4. Re: Possible Bug 4.51 ( "Brian Boegershausen" 2004)
  5. Re: Possible Bug 4.51 ( Matthew A Perosi 2004)
  6. Re: Possible Bug 4.51 ( "Brian Boegershausen" 2004)
  7. Re: Possible Bug 4.51 ( Matthew A Perosi 2004)
  8. Possible Bug 4.51 ( "Brian Boegershausen" 2004)
Well if it "basically just a big number" then you *really* should have THEDATETIMEtype=num because from day to day I've seen my sorting routines give back totally erratic answers when I don't specify the type and it defaults to whatever ASCII routine is built in.

Matt

Brian 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" <matt@psiprime.com>To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Sent: Wednesday, January 21, 2004 3:21 PMSubject: Re: Possible Bug 4.51  
What happens if you [url] the GROUP1 data?i.e.&eqGROUP1datarq=[url]United    
States[/url]&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCount  
ry&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=United      
States&GROUP1field=Post_Country+DepartureCountry+LayoverCountry+ArrivalCoun    
t  
ry&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 than      
one  
of 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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to      
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to    
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>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/ Matthew A Perosi

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:

Multiple 'Users.db' files not possible (1997) SMSI - MacWorld (2005) SQL statements (2002) WebCatalog2 Feature Feedback (1996) [TaxableTotal] - not working with AOL and IE (1997) Re(2): NT version and O'reily's WebSite (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebCatalog Features (1997) Summary layout (1997) Using Plug-In while running 1.6.1 (1997) WebCat2: multiple currency support (1997) two unique banners on one page (1997) Math Problem - Format? (1997) Problems getting parameters passed into email. (1997) Emailer+NetTen [same machine]=? (2000) Separate SSL Server (1997) [WebDNA] Euca Forum Update (2012) WebCatalog NT beta 18 now available (1997) Webstar 1.3.1 PPC (1997) W* 4.2 / WebCat (TPro) 3.0.5b / OS 8.5.1 / BW G3 (2000)