Jeff Perreault

post by jeff

Testing :
  

Crane was built this week.
These photos are taken every 10 minutes

https://helpdesk.desire2learn.com/D2L_Knowledge/knowledge.do?sysparm_document_key=kb_knowledge,05c20ee37039c1807c98ae4640504de9

This link saved my bacon today.

https://www.macobserver.com/tmo/article/see_full_cookie_details_in_safari_5.1

</p><br /> <p><img src=”data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7″ data-wp-preserve=”%3Cscript%20src%3D%22https%3A%2F%2Fjwpsrv.com%2Flibrary%2Fee_HYJvaEeKtCyIACpYGxA.js%22%3E%3C%2Fscript%3E” data-mce-resize=”false” data-mce-placeholder=”1″ class=”mce-object” width=”20″ height=”20″ alt=”<script>” title=”<script>” /></p><br /> <div id=’my-video’>Loading…</div><br /> <p><img src=”data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7″ data-wp-preserve=”%3Cscript%20type%3D’text%2Fjavascript’%3E%0A%20%20%20%20jwplayer(‘my-video’).setup(%7B%0A%20%20%20%20%20%20%20%20file%3A%20’https%3A%2F%2Fmymedia.langara.bc.ca%2Fvod%2Ftesting%2FAccessMyfilesAtLangara.mp4’%2C%0A%20%20%20%20%20%20%20%20image%3A%20’https%3A%2F%2Flangara.bc.ca%2Fcontinuing-studies%2Fimages%2Fbackground.jpg’%2C%0A%20%20%20%20%20%20%20%20width%3A%20’640’%2C%0A%20%20%20%20%20%20%20%20height%3A%20’360’%0A%20%20%20%20%7D)%3B%0A%3C%2Fscript%3E” data-mce-resize=”false” data-mce-placeholder=”1″ class=”mce-object” width=”20″ height=”20″ alt=”<script>” title=”<script>” /></p><br /> <p>

Variables:

Video File URL, fileThe URL of the video. This can be a YouTube video, or can be hosted on Langara’s myMedia server

e.g. https://mymedia.langara.bc.ca/vod/kins2284/kins2284_adolescen1_female_14yrs_runner_lateral_nov_2012.m4v

Image File URL, imageThis is the image that will appear on the video player when the page loads. Think of it as a splash image for the video.
e.g.: https://mymedia.langara.bc.ca/vod/kins2284/kins2284_adolescen1_female_14yrs_runner_lateral_nov_2012.m4v

Width and Height You can customize the size of the rectangle that appears on the page.

See the official README file

I needed to find a way to always select the date range of the previous month.

So if it’s January, I need to select rows with dates between Dec 1 and Dec 31 of the previous year.

If it’s February, I need to select dates with Jan 1 and Jan 31 of the previous year.

Here’s how to do it:

select
trunc(trunc(sysdate, ‘MM’) – 1, ‘MM’),
to_char(trunc(trunc(sysdate, ‘MM’) – 1, ‘MM’),’DD-MON-YYYY’) “First Day of Last Month”,
trunc(trunc(sysdate, ‘MM’) – 1),
to_char(trunc(sysdate, ‘MM’) – 1,’DD-MON-YYYY’) “Last Day of Last Month”
from dual ;

Here’s a state diagram shows how complicated it really is:

Image by Andrew Durdin