Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

XML Schema Referencehttps://www.joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 element for schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables the author to extend the XML document with attributes not specified by the schema appinfo Specifies information...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 files in EFS RAW mode. /COPY:copyflag[s] :: what to COPY for files (default is /COPY:DAT). (copyflags : D=Data, A=Attributes, T=Timestamps). (S=Security=NTFS ACLs, O=Owner info, U=aUditing info). /DCOPY:T :: COPY Directory Timestamps. /SEC :: copy files...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 AS Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Extracting the attribute: Here we want to extract an attribute value SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 Quick Answer: the page margins Tackling the page margin on render, I wrap the whole lot inside a DIV layer with the key attribute zcpage-spacing:......... The Quick Answer: the header This repeats the header on every page. The key here is the HTML...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 1.2 in the 90s. For broader compatibility, this is my recommended solution. How? We're going to use the onBlur and onFocus attributes which do, as the name indicates, trigger events when the cursor is either in the field or not. The above field was...

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 system field labels The fix put simply is a CSS hack. Specifically by inspecting the element, removing some of the CSS attributes on the field we want to change, saving it, then returning the "Lead Conversion Mapping" page, mapping it, and then testing...

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

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id. This will yield the following: body.bgstyle1 #main-background {background:...

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

How to make a HTML form post its variables to itselfhttps://www.joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 but you have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code as long as you attribute credit where it's due. License is GNU General Public License v3 (www.opensource.org/licenses/GPL-3.0). FREE / Gratis Did I...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 pwb.document.forms[0].elements[0].value MsgBox % COM_Invoke(pwb, "document.forms[0].elements[0].value") Object's Name / ID Attribute You can also use the objects name or ID. For example, the 1st forms name is SearchForm, with its 1st elements name being...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution #2: Alternative image if file...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" Conclusion: The final fix in my case was due to me not specifying some...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 the Search API call. Code-wise using the same criteria variable for both calls might offer some consistency. Notes on the attribute: Criteria You can't compare a date time value to a field that is simply of datatype: date (eg. Valid_Till) The supported...

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

Add default to a picture buttonhttps://www.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput, Search... Add the submit button with a hidden attribute: Gui, Add, Button, x600 y70 w90 h90 +Default +gSearch +Hide, Search The function to receive the data can be: Search: Gui,...

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

Joomla field types clear my htmlhttps://www.joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 have difficulty following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw attribute, for example: Other searches: Stripping HTML from my joomla 2.5 component Leave my HTML alone for admins field types for...

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

Zoho Inventory Template Issue: First Page is Blankhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 The culprit is the following CSS line: page-break-inside:avoid // change to page-break-inside:auto Resolution Find the CSS attribute "page-break-inside" If this is set to "avoid", then change it to "auto" Additional You may also need to remove the child...

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