Assuming than is required, the following 166 results were found.
-
is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
More for others than for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?). Why? We have a row on a website of three boxes made of div layers. When viewed normally on a 15" Laptop, all was good using...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
-- yields ".String2.String3.String4" Not quite right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
1.00 002 3.00 2000-02-18 1.00 002 3.00 2000-02-18 1.00 003 2.00 1999-02-25 1.00 003 2.00 1999-02-25 1.00 If you have more than 999 items in the column, then you may need to increment the 3 in the above statement "LEFT(..., 3)". Almost there, but in the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT". "O'REILLY" should become "O'Reilly"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
for a number of occurrences within a specified range. For example, to find where 'a' occurs at least 3 times and no more than 5 times, you use the following regular expression: a{3,5} This expression matches all of the following sequences: aaa aaaa...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
which isn't included in the examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: -- Now for some UK (British)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
name of the field, its entity and dictionary. My example below will use the Decision/date and Response/date fields (rather than the CAP_IDRC). This demo will use the key fields from the Course Application (CAP) entity/table. Create the XML Exchange...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
the right one given to Google Maps. Follow On Article/Sequel Next: Article on separating the map into a sub-activity rather than it being the main activity - Android OS: Add GoogleMap as fragment.
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
the alias of the component (eg. "doc_indexer"), you would need to modify this to the component you want it to search. More than one area I have added the hidden fields in the HTML form (generated in PHP) in the following file: mod_joesearch.php. Simply...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Force no underlines on words. - Date Uploaded: Thu, 11th Nov 2010 1.2.3- Fixed bug: counts international characters rather than bytes. - Fixed bug: renamed functions so as not to conflict with any pre-existing ones (eg. utf8_strlen) - Date Uploaded:...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes = column_values[1].split('"').join(''); // populate my array with an object obj_temp.push({...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
if you update your Joomla CMS. Why? When checking audit logs, I sometimes see that my administrator url is accessed more than my front-end. The below has worked for me on Joomla websites in general and prevents the administrator URL showing up at all in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
tokens and specified the appropriate scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested): https://www.googleapis.com/auth/drive.file...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
#2945 INVALID TICKET: Ensure you are using creator.zoho.com or creator.zoho.eu for your endpoints as appropriate. #2945 MORE_THAN_MAX_OCCURRENCE: Ensure your params are submitted as a JSON string (not a JSON list). Update Success: Not updating creator:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
the image so that you can position it as per your requirements. That should do it.... The Gist Don't load in images bigger than an A4 sheet... Additional Notes I found that some classes are reserved words used by the Zoho built-in renderer. I am making...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF