T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 similarly to the following: SET RECSEP WRAPPED SET RECSEPCHAR "-" Stage #1: Duplicate the table and create a separator marker Granted this will slow the query down a touch and only adds a check column which marks rows (identifying when a separator is...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 example, I'm going to add the map as a fragment. This is the most rudimentary example (display map, move camera and display marker) and can be run from any other activity: MapFragment.java package com.joellipman.mymapapp; // change to your own package...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 the table in a listview format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: en-GB

Joes Google Map (JGM) Downloadshttps://www.joellipman.com/component/content/article/joes-google-map-jgm-downloads.html?catid=92

07 September 2015 ChangeLogOptions1.1- Added parameters: Width, Height - Added parameters: Zoom Level, Heading, Tilt - Added parameters: Marker 1: Latitude, Longitude - Added parameters: Marker 1: HTML to display, Replace Marker Image - Added parameters: Control Options...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 the "Menu Assignment") Set the latitude and longitude of where the map starts Set the latitude and longitude of your main marker (HQ?) Set the HTML InfoWindow content (the popup of the marker) Swith the appropriate Overrides to "Yes" Leave blank what...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Mootools - How to contain a menu sidebar between header and footerhttps://www.joellipman.com/articles/web-development/mootools/mootools-how-to-contain-a-menu-sidebar-between-header-and-footer.html

10 August 2012 if anyone has a better idea, I'd really appreciate it. window.addEvent('scroll', function() { var menu_highest_top = $('jdo_marker_table').getCoordinates().top; var menu_height = $('jdo_actions').getCoordinates().height; var component_top =...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: en-GB

SSRS Change Background Color of Imagehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 transparent pixels will be colored in with the page background color. Why? I want an image to display per row as a status marker for 3 different types of results: Success, Failure, Unknown. My images are circles with the background being transparent. I...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 new facebook profile photo My old FC40 looking new(ish) Ok, still going with painting on a budget, yes those are permanent marker color-ins the chipped smaller propeller is stock Less on a budget, let's replace the FC40 gimbal...with an AerialFreaks...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 MapsActivity.java file and open it: Change the function setUpMap() to the following code private void setUpMap() { mMap.addMarker(new MarkerOptions().position(new LatLng(0, 0)).title("Marker").snippet("Snippet")); // Enable MyLocation Layer of Google...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 Restricted Area: Avoid flying in this area at all. Red: Prohibited Area: Do NOT fly in this zone at all! Blue: Location Marker: Represents the area you will be flying in. Green: Model Aircraft Club (the only places you're supposed to be flying). Black:...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 of inserting then associating the categories and -- inserting into the assets table per article. We are going to put a -- marker ":|joe|:" and append the old ID for later use. -- ********************************************************************* --...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 I don't download it again and create a new Creator record to hold the same file but in a new record, as well as include the marker to check when uploading the files back to CRM: row.Parent_Record=input.CRM_Contact; row.Downloaded="Pending Upload";...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *