Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming based is required, the following 108 results were found.

  1. Installing phpBB3 for Joomla with a RocketTheme templatehttps://joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    http://www.mysite.com/phpBB3/language/en/mods/acp_joomla.php Log into the phpBB3 Administration Control Panel. Based on the phpBB3 installation instructions above, this should be something like http://www.mysite.com/phpBB3/adm/. Click on the 'General'...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on StackOverflow. Not sure what version they were using so I modified it to make this work with my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

    this file in the fields folder/directory of your component (/my_component/administrator/models/fields/article.php). It's based on two Joomla core ones, namely administrator\components\models\fields\modal\article.php and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    use. This allows for a good test bed and stable releases, error and hopefully risk-free. How? Here's one method I used based on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  5. Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

    1 above) Lastly and optionally I add the following to the core joomla search module PHP template so that the first search is based on the above heuristics: This needs to be put alongside the other hidden variables in the module, core joomla file is at...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  6. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    recommended practice, I'm moving these guys first so all -- the objects from the existing site will retain their ownership. Based -- on previous migrations, this tends to help not confuse the system. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  7. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    Why? This is a big cop-out as I simply took someone else's functions and upgraded them to use the mentioned token based authentication. I find myself going through the motion and designing on a per-app basis so I wanted a standard way of doing it and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  8. Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

    show up on Special:Version $wgExtensionCredits['parserhook'][] = array( 'name' => 'BUKB Player', 'author' => 'Joel Lipman (based on original flvplayer by Christopher Ottley)', 'url' => 'http://www.joellipman.com/', 'description' => 'Displays videos we...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  9. Android: Replace return key with done, go, send...https://joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    A quick article on how to replace the return key on a soft keyboard (software 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    using Google Maps and Current Location", this article suggests how to add Map as a sub activity. Note that this article is based on a new blank project which does not include code from the previous example but you can still build this over the previous...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  11. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop the task (based on default settings). Additional -- Take a "dd/mm/yyyy" string and convert to date (when (DT_DATE)ThisDate by itself doesn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    used as just putting the file name did not work). Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Report Builder 2.0 - Hide Series1https://joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

    To Full Name] ,_SMDBA_.Incident.[Incident Type] FROM _SMDBA_.Incident WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName Based on the assumption that "Series1" displays on my chart because of values that are not matched (not assigned to a current...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every half-hour in the range (change based on slot times) SELECT DATEADD(MI, 30, [Time]) FROM Times WHERE Time...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  15. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with read-only privileges to list all the details. On the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. SSRS AlphaNumeric Parameter Validationhttps://joellipman.com/component/content/article/ssrs-alphanumeric-validation.html?catid=75&Itemid=165

    formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with changes based on returned value. The Gist Add database level parameter check Add IIF in SSRS to confirm Database Level AlphaNumeric Check...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Problem creating SSRS report subscriptionshttps://joellipman.com/component/content/article/problem-creating-ssrs-report-subscriptions.html?catid=75&Itemid=165

    static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? There are various types of data sources used in SSRS so I'm going to try and cover the ones I...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  20. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last part of this, ie "String4". So I need to delimit based on the dot/period (.) and use substring in a sort of reversed form. For argument's sake, I'm assigning this string to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 61 - 80 of 108