Assuming needed is required, the following 62 results were found.
-
false); mMapView = (MapView) v.findViewById(R.id.mapView); mMapView.onCreate(savedInstanceState); mMapView.onResume();// needed to get the map to display immediately try { MapsInitializer.initialize(getActivity().getApplicationContext()); } catch...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other instructions out there on the...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
Error: Description: "Invalid character value for cast specification". Exceptions for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Myhouse". Example #2: Using as a Custom Script Component The above will work as a SSIS Script task. At work however, we needed to separate it out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the lookup to "use results of an SQL query": Which would code with the joined tables as follows (note that in our case we needed the lookups on the source database which was not the same as our staging one which this package gets as its source): -- here...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
are various types of data sources used in SSRS so I'm going to try and cover the ones I have used previously and what we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
page. This does not make the change to the setting itself, just displays it to the user for them to make the choice. Why? I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minutes seconds mseconds) I want to total 3 of the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
this will slow the query down a touch and only adds a check column which marks rows (identifying when a separator is needed) but this works. Inspired by Namwar Rizvi's blog, I wrapped my SQL query within a common table expression: --Create CTE WITH...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
characters: SELECT * 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
forgetting to ask something that could have saved an infinite number of man-hours (I exaggerate a little); but seriously, I needed a checklist that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
match the following string: cdefg You can use the collating sequence operator in any regular expression where collation is needed. For example, to specify the range from 'a' to 'ch', you can use the following expression: [a-[.ch.]] POSIX Character...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I needed to create a template in HTML where the first page is a cover page (background image filling the page with a logo floating at the...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
now use JQuery or Mootools but most of these will not work in Internet Explorer 7 which is unfortunately still in use. I needed a back-to-basics solution and this is the one I have used since my fad of JavaScript 1.2 in the 90s. For broader...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
Joomla! displayed funny characters. The Joomla! articles were displaying the correct characters for that language set. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8. I tried enough...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
don't accept ads that offer work from home positions on «CompanyName». 419 scams. You get an email saying that your help is needed to take money out of a country and that you’ll be paid a commission for your help. Eventually the fraudsters will ask you...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods with the same name as their class...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB