The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 2=Cache, 3=Snapshot, 4=History) Status nvarchar(32) NOT NULL either rsSuccess or an error code; if multiple errors occur, only the first error is recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 selecting all cells and then right-clicking and selecting "row height" is beyond us. We have since simplified this so that only the person who knows how to hit the refresh button is the one to save as a PDF file and sends it to all customers. Training...

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

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

11 October 2011 it as displayed in the following image (apologies for the image but it's still clear as mud in my head): Oracle SQL*Plus Only for display/print but SQL*Plus has a nifty separator record activated similarly to the following: SET RECSEP WRAPPED SET...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 to put them in one place on a website I've bookmarked (my personal site :c) My own with Typos Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the...

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

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 Issues : ** ** Will pick up variations with trailing spaces but this is not easily recognized from the results ** ** ** ** Only finds the first table_name.column_name where the match occurred (ordered alphabetically). ** ** -> Example: if a table has...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 LIVE and for developers to play with. DEV2 - a copy of LIVE for another team of developers to play with. Refresh TEST using only web-based tools Requires: Web-Based File Manager (eg. cPanel File Manager) Web-Based Database Manager (eg. phpMyAdmin)...

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

Joomla Component: Set default params on installationhttps://www.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 2000000 All Drives 67108863 3ffffff Log off and log on, or restart the computer to apply changes. Important! The above only applies to the user you are running Regedit as! (So if logged in as Admin, this hides it from the Admin, but not from the Guest...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 if it is not in uppercase SET @Ret=@Text END RETURN @Ret END Examples of what this script does: Reminder: The script only affects data already in UPPERCASE. Change the IF (UPPER(@Text)=@Text COLLATE Latin1_General_CS_AI) line if you want to change this....

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the Excel...

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

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

13 August 2014 Defines an attribute attributeGroup Defines an attribute group to be used in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines extensions or...

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

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted IP address. If the end-user were to make the request, then their own IP...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Templates - Font size is inexplicably tinyhttps://www.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to my template. Specifying only a font-size, font-family, margins and page-break-after was pretty much the only change I can do to this class.

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

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 the PHP $p_Name here is the title of your article or product that will be changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 over the "Lanterns" link: » Home / Products / More Lanterns How? Given the following HTML: Home Products lanterns Using CSS only, I have so far achieved the following: /* Specify a blank prefix which is fully transparent */ ul.breadcrumb a span:before {...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 desktop Send, ^#{Right} ; previous desktop Send, ^#{Left} Additional The above example, is if you have 3 monitors. If you only have 2 monitors, then note that right-most will not exist and only left and centre should with the central screen starting at...

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

Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 startsWith startsWithIgnoreCase used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only Source(s): Zoho Deluge - Functions which return a boolean value Community » Zoho Creator » CASE...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...

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