Assuming code is required, the following 267 results were found.
-
** 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 parameter...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
looks similar to the following: Table: DMExtractEmployeeTable ------------------------------------------- ID Name EmpType CodeType 1 Joe Manager 0011 2 John Tape-Monkey 8475 3 Fred Director 7749 4 Bill Manager 0011 5 Another Tape-Monkey 8475 6 Joe...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Almost There! So we're using the ROW_NUMBER() functionality with an ORDER BY which seems to work somewhat. But using the code above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Examples of usage: SELECT ufn_ProperCase([Surname]) FROM employees Additional: Note how the above doesn't convert postal codes, specifically British postcodes, which isn't included in the examples above because the function was only going to be applied...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
* FROM `myTable` WHERE `myColumn` REGEXP '[^A-Za-z0-9 -()\-.]' Joomla! Additional My Joomla website needed the following code to display the above foreign characters as entered into the Joomla administrators console with accents and all:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
The concept - typically drawings, words, models, code and basic prototypes that describe the nature, objectives and features of the website. Design document - a detailed plan of the website’s features and how it will display are generated from the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm redirecting from myolddomain.com to...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
of the asterisk and vertically align to the bottom ( line-height: 10px; vertical-align: bottom;). Here's the whole code: ul.listafter{ list-style-type:none; width:130px; height:130px; background:none; } ul.listafter li{ width:59px; height:52px;...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
across a long page. It would appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code but it is not. My only solution was to propose to set the background as white (#f7f7f7 - white with a tint of grey) and show...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
the parent... How? We're going to use a touch of CSS and instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS:...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
); $str = preg_replace($search, ' ', $str); $str = strip_tags(str_replace(array('[',']'), array(''), $str)); // remove BB Code and HTML tags $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" ); // converts html entities into characters (symbols) $str...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to some JSON in UTF-8. If it were entirely in UTF-8, I would simply load the received XML with SimpleXML and use the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
- Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date Uploaded: Fri, 30th Jul 2010 1.1 - Separated all...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
Width - Added Joomla Admin Panel option: Show Powered By - Date Uploaded: Wed, 16th Feb 2011 1.0.1 - Removed all unnecessary code - Date Uploaded: Wed, 16th Feb 2011 1.0.0 - Shock as its working - Date Uploaded: Wed, 16th Feb 2011
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a JS: /*!...
- Type: Article
- Author: Joel Lipman
- Category: Bootstrap
- Language: *
-
on if you're using a canvas or not) Module is Quotes Type is Page Event Event is onLoad Click on the button Next The code: /* ******************************************************************************* Function: Quotes - Map Distributor/Reseller...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day job's MediaWiki software and it's...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB