Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Grouping Continuous Dates

520297Dec 20 2009 — edited Oct 14 2010
My Table is -

<pre>
H_DAYS
18/01/1999
19/01/1999
20/01/1999
26/01/1999
29/01/1999
31/01/1999
01/02/1999
02/02/1999
</pre>
I need to group all the continuous dates like -

<pre>
From_Date To_Date Days
18/01/1999 20/01/1999 3
26/01/1999 26/01/1999 1
29/01/1999 29/01/1999 1
31/01/1999 02/02/1999 3
</pre>

Thanks in Advance
This post has been answered by Aketi Jyuuzou on Dec 20 2009
Jump to Answer

Comments

trent
Hi Scott,

If you open the developer toolbar, you will notice the document mode is: IE9 standards.

Change this to: Standards and it works fine.

I'm not very guru'ey in IE stuff, but there must be something in the template forcing it to go into IE9 mode. The hunt begins!
trent
Answer
Couldn't find anything to suggest it should force ie9 standards.

But adding the following to the page header seems to clear that and actually load in Standards mode.
<meta http-equiv="X-UA-Compatible" content="IE=edge" >
I do note that the apex builder pages are all loaded in IE9 Standards mode as well, which I find a little odd.

It is worth checking out the following:

http://msdn.microsoft.com/en-us/library/ms533876%28v=vs.85%29.aspx
http://msdn.microsoft.com/en-us/library/jj676915(v=vs.85).aspx
*Note Edge mode is intended for testing purposes only; do not use it in a production environment.*
Because it forces all pages to be opened in standards mode, regardless of the version of Internet Explorer, you might be tempted to use this for all pages viewed with Internet Explorer. Don't do this, as the X-UA-Compatible header is only supported starting with Windows Internet Explorer 8.
Tip If you want all supported versions of Internet Explorer to open your pages in standards mode, use the HTML5 document type declaration, as shown in the earlier example.>

Although, everywhere seems to suggest using edge mode (StackOverflow, etc)

http://stackoverflow.com/questions/5374099/how-do-i-force-internet-explorer-to-render-in-standards-mode-and-not-in-quirks
http://webdesign.about.com/od/metataglibraries/p/x-ua-compatible-meta-tag.htm
"IE=edge" tells Internet Explorer to use the highest mode available to that version of IE. Internet Explorer 8 can support up to IE8 modes, IE9 can support IE9 modes and so on.
Edited by: trent

Excuse all my edits! It looks like the !html5 test just below the opening head tag does not pass, which is where it should set browser mode to standards. I'd say just to take it out of there and put it in the if gte IE9 bit, so:
<!--[if (gt IE 9)|!(IE)]><!--> <html lang="&BROWSER_LANGUAGE."><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">  <!--<![endif]-->
Marked as Answer by Scott Wesley · Sep 27 2020
Scott Wesley
Thanks Trent, from what I read I figured the issue would be something to do with those headers - but you've interpreted it nicely for me.

Scott
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 11 2010
Added on Dec 20 2009
6 comments
16,277 views