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

13 August 2014 Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...

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

Connection Strings for SQL Serverhttps://joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Note that the charset option works from version 3.51.17 of the driver. Specifying socket This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections. Driver={MySQL ODBC 3.51...

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

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

23 February 2014 [/F] [/L] [/G] [/H] [/R] [/T] [/U] [/K] [/N] [/O] [/X] [/Y] [/-Y] [/Z] [/B] [/EXCLUDE:file1[+file2][+file3]...] source Specifies the file(s) to copy. destination Specifies the location and/or name of new files. /A Copies only files with the archive...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 in detail to address new problems or concerns. Each version is given a distinguishing version number. If the Program specifies that a certain numbered version of the GNU General Public License “or any later version” applies to it, you have the option of...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 be 755 (ie. rwxr-xr-x). The change ownership command in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file size limit. By default this is 2Mb. In my example, I added the hidden input type MAX_FILE_SIZE...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 made them all the same type which is probably why I made the module think all thumbnails were equal. The module specifies the size of the image. The module keeps generating website thumbnail preview images on TWO conditions: 1) you are logged in to the...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 failed because error code 0xC0049064 occurred, and the error row disposition on "output column "DC_This_Date" (3833)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted...

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

SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 m_Header.put("X-Shopify-Access-Token",v_AccessToken); // // create a list of pages (specifies the number of pages to try) l_Pages = {1,2,3}; for each v_Page in l_Pages { if(b_HasNextPage) { // // query using GraphQL v_UpdatedSince =...

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

SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to...

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