Articles - Joel Lipman .Com

DataTumble - Randomize Data Rows

: Joel Lipman; Transact-SQL; 07 December 2012; Hits: 5457

What?
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values:

Before:

copy raw

ID        Name         DateOfBirth
--------- ------------ -----------
1         John Smith   1988-06-24
2         Fred Bloggs  1972-11-17
3         Another User 1964-02-18

ID Name DateOfBirth
--------- ------------ -----------
1 John Smith 1988-06-24
2 Fred Bloggs 1972-11-17
3 Another User 1964-02-18

After:

copy raw

ID        Name         DateOfBirth
--------- ------------ -----------
1         Fred Bloggs  1964-02-18
2         Another User 1988-06-24
3         John Smith   1972-11-17

ID Name DateOfBirth
--------- ------------ -----------
1 Fred Bloggs 1964-02-18
2 Another User 1988-06-24
3 John Smith 1972-11-17

Looks pretty good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble).

How?

Category: Transact-SQL :: Article: 459

: Joel Lipman; Joomla; 04 December 2012; Hits: 5331

What?
Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website addresses enabled.

How?
Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice:

copy raw

- SEF URL
http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html

- Direct Link (irrespective of SEF)
http://www.joellipman.com/?option=com_content&view=article&id=449

- SEF URL
http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html
- Direct Link (irrespective of SEF)
http://www.joellipman.com/?option=com_content&view=article&id=449

Category: Joomla :: Article: 458

Battery Constantly Drained on iPhone

: Joel Lipman; Apple; 27 November 2012; Hits: 4883

Event 1

A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)...

I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the problem in the first place:

The empty arrow next to the battery indicator tells you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to "remind you".

The reminder here was to charge the phone but it was the reminder which would drain a full charge in less than a day.

Generate Academic Calendar using MySQL

: Joel Lipman; MySQL; 27 November 2012; Hits: 6561

What?
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers.

Why?
The aim of this article is to quickly generate a calendar for a full academic year for referencing by staff/students.

How?

: Joel Lipman; Joomla; 22 November 2012; Hits: 26143

What?
If you get something like the following error:

Warning: call_user_func() [function.call-user-func]: First argument is expected to be a valid callback in /home/.../templates/rt_affinity/rt_sectionrows.php on line 311

How?

Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php
Find the following piece of code around line 311:
copyrawstyler
```
foreach($this->horizontalCookie[$row] as $block) {
	$block = str_replace('-', '', $block);
	$this->module_row1 .= call_user_func($block, $this, $mClasses);
}
```
1. foreach($this->horizontalCookie[$row] as $block) {
2. $block = str_replace('-', '', $block);
3. $this->module_row1 .= call_user_func($block, $this, $mClasses);
4. }
And change it to:
copyrawstyler
```
foreach($this->horizontalCookie[$row] as $block) {
	if(!empty($block)) {
		$block = str_replace('-', '', $block);
		$this->module_row1 .= call_user_func($block, $this, $mClasses);
	}
}
```
1. foreach($this->horizontalCookie[$row] as $block) {
2. if(!empty($block)) {
3. $block = str_replace('-', '', $block);
4. $this->module_row1 .= call_user_func($block, $this, $mClasses);
5. }
6. }

Category: Joomla :: Article: 451

About 5 seconds worth of fun

: Joel Lipman; SharePoint; 21 November 2012; Hits: 6099

What?
Really not work related but if you know your sharepoint site:

Custom Error
http://<My_SharePoint_Site>/_layouts/MySite.aspx?Error=You%20are%20a%20jerk%20and%20SharePoint%20does%20not%20share%20with%20jerks.

Installer?

: Joel Lipman; Cascading Stylesheets; 20 November 2012; Hits: 6372

What?
This is a quick article on how to resolve the following issue:

Overall body background color is blue.
Background color of my contents is white.
When I visit a small page on the site, the contents background (white) shows.
When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read.

Why?
Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would disappear when the page finally loaded.

How?

: Joel Lipman; File Transfer Protocol; 20 November 2012; Hits: 6387

Why?
So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows?

How?
I don't have a clue. Here's what I've got so far:

: Joel Lipman; Joomla; 19 November 2012; Hits: 9911

Applies to:

Joomla 2.5.8
Yootheme Template 2012

What?
For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates how to make this an option that your client can switch off/on using the Joomla Admin Panel.

How?

: Joel Lipman; SharePoint; 09 November 2012; Hits: 10222

What?
I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't.

The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint calendar will sit separate to the others. Once it's in your Outlook, you can copy over events. The calendar is separate to your own and to other Exchange ones.

Eeek!

: Joel Lipman; SharePoint; 08 November 2012; Hits: 7654

Applies to

Microsoft Office Sharepoint 2007

What?
I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg. I:\myFile.doc)but what if other users haven't mapped the same drive letter to the path? Then they won't be able to use the link.

Why?
As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise). There may be situations when this is better but I'm just trying to add a link to our Sharepoint 2007 portal.

How?

: Joel Lipman; Databases; 05 November 2012; Hits: 6288

What?
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load).

How?
The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and saving it on a database):

Credit where Credit is Due:

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Donate & Support