What?
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds.
Why?
Here are some examples of what ...
... being deprecated (end of life at the end of this year). So I'm familiar with the methods in API v2 or just using newer functions.
Method #1: API v1
userResp = getUrl(("https://crm.zoho.com/crm/private/xml/Users/getUsers?authtoken=xxxxxxxxxxx&scope=crmapi&type=ActiveUsers"));
users ...
... an attribute value
SELECT
CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS INT(4)) AS FinancialYear
FROM
[dbo].[XML_EVENTS]
-- Returns attribute "financialyear" ...
... in our case and could be left as they were. Our last file backup was over a year old but we only needed the core files, a working system, and then we could proceed with a standard Joomla update.
I ...
... subsequent tasks until these add up to 1 hour.
Housing the production and 2 development websites and email system as permanent host is £120/year (or £10/mo). This includes keeping the servers up-to-date ...
... identified by the labels mentioned below.
What data does Joes Infographic for Joomla (JIJ) need?
Summary Period Report (details on your awstats report)
Monthly History (per month per year)
Days ...
... that maybe all the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year.
How?
I used two "Derived Column" tasks for this after ...
What?
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
Why?
I've used various mySQL administration tools to manage mySQL databases over the years, ...
i3 workstation upgrade running Windows 7
So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review ...
What?
More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website.
I have been doing this for years and still come across ...
... is to quickly generate a calendar for a full academic year for referencing by staff/students.
How?
Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"):
ID ...
... AS SecondsElapsed
FROM StaffActivities s
WHERE WEEKDAY(s.DateTimeCreated)=0
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) ...
... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list will be in the following order: 2010, 2011, ...
... - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays,
CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource,
s.StaffActivity AS Activity,
s.AdditionalNotes AS Notes,
CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) ...
... yesterweek, yestermonth, yesteryear and do the layout in PHP.
Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal.
In Theory:
SELECT
...
... CMS. I've tried all the following for about a year each and these are my reviews/opinions:
Phoca Download
Good compatibility and actively developed. Unfortunately hacked on more than one occasion. ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.