SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 (System.Data.OracleClient) The Situation I'm using...

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

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

11 October 2011 you can replace NULL with lots of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever character. I just put NULL because I wanted an empty row. My final query This displays all room bookings for today and the next 6 days....

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

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 anything", treat it as empty. this.value.split(' ').join('') -- split this value into an array separated by the delimiter character "" -- join this array back replacing any spaces with nothing Examples: -- If field is "Joes Just Joking!" yields...

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

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the...

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

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

14 March 2013 + SUBSTRING((DT_STR,8,1252)StartDate,3,2) + "/" + SUBSTRING((DT_STR,8,1252)StartDate,5,4)) Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the...

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

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 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 content Needle1b...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space character and delimiting by a string. The Gist -- What I have Image00001 (Copy).jpg Image00002 (Copy).jpg -- What I want Image00001.jpg...

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

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 BEGIN DECLARE @StringValue VARCHAR(MAX) -- Trim and remove last pipe character SET @StringInput = LEFT(RTRIM(LTRIM(@StringInput)), LEN(RTRIM(LTRIM(@StringInput))) - 1) WHILE LEN(@StringInput) > 0 BEGIN SET @StringValue = LEFT(@StringInput,...

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 based) on a touch-device. Why? I have an editText where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 function for old MySQL. - Enhancement: Check for W3C Validation and force fix "&". - Double-check that unicode characters work in exclusion list. (they do) - Date Uploaded: Mon, 8th Aug 2011 1.6.6- Bug Fix: "Case-sensitive=No" now checks that word in...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 What? A quick article to stop me running into this issue again. This article serves to address the issue of importing characters from an XML in a different language character set and trying to load it in PHP with the function simplexml_load_string()....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 { English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...

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

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

06 May 2019 server-side scripts for the sake of search-engine friendliness. There are no silver bullets here but I want to block any character that isn't a letter, a number or an underscore. How? Suppose the following exists as a MySQL database table called...

• 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 a.home:before { content:'\00bb'; margin-right:5px; } The last snippet is completely optional if you want to prefix the character » to your breadcrumbs. Unfortunately, this only deals with the opacity transition as the width transition is not a smooth...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 This will contain the code triggered when one of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main workflow. Other fields needing to...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 } How? So the quick answer is to build a nested map in your request instead of using the Creator/JavaScript period/dot character... Some might suggest it's an authorization error but if you do a getRecordById and it works then the connection string is...

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

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

14 November 2023 encoding the value: ((Last_Name:equals:Burns%5C%2CB)and(First_Name:starts_with:M)) When you use backslash as the last character in the value for a criteria, you must escape it using another backslash. Further, you must encode the value. Example:...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 you, and ensure it can respond to eBay's validation challenge code. In the Verification token field, enter a unique 32–80 character token containing only letters, numbers, underscores (_), or hyphens (-), which eBay uses to verify ownership of your...

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "")...

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

Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255 characters (it could be a multiline but this would defeat the objective of an Etag). How? Well I was going to document writing a...

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