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 done is required, the following 105 results were found.

  1. Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

    in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its developer. I've started writing this article because I find myself forgetting to ask something that could have saved an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  2. MySQL parameters in Excel 2007 PivotTableshttp://mail.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    be automatically added to row or column), then click on it and select "Move to Report Filter". Shout in Gordon Ramsey-style: Done! Better than... MS Reporting Services? Yes by far. Fast, quick to setup and a big fat refresh button for the executives....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

    altogether, hit the Data Refresh button Add the column back to the "Row Labels" Move the field back into "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  4. Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

    1) Decompress to a folder of your choosing 2) Run the EXE (there is no install process, it should just start) 3) Done! ChangeLog: v1.0 (22/11/2011) - Display internal and external IP address - Display flushdns errorlevel - Display registerdns errorlevel...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

    in my second select query (the one preceded with "open cursor for") didn't match my SSRS report field name mapping. Done! Well almost as you still need to design your report. At least this article should have got you to the part where you're simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Adding a selectable background to a Yootheme templatehttp://mail.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    Test by logging into the Joomla Admin Panel > Extensions > Template Manager > Styles > "Select the Background" > Save/Apply Done! Additional Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  7. Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    not overwrite configuration.php !!!) Copy database from LIVE to TEST (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  8. CharIndex Reverse - find occurrence starting from end of string in TSQLhttp://mail.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) + 2, LEN(@Haystack)) -- yields "String4" Yay!!! Done! Untested but in theory: SELECT REVERSE( SUBSTRING( REVERSE( @Haystack ), 1, CHARINDEX( @Delimiter, REVERSE( @Haystack ) ) - LEN( @Delimiter...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  9. Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

    (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  10. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    SQL Server\100\DTS\PipelineComponents" /Y REM Returning to directory where this BAT is held. CD "C:\Temp" ECHO Done. Deployment Method #?: As a setup.exe Package the visual studio project by adding a "setup wizard" project. This results in a setup.exe...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  11. Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

    #__assets SET parent_id=1 WHERE parent_id=0 AND id1 AND title'Root Asset' -- where #_ is the Database Tables Prefix value Done phpMyAdmin alternative The gist is simple, you can only have one asset that has a parent_id of zero. Login to your database...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  12. SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the Flat File Source. Done.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

    return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  14. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttp://mail.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    a newer version that corrects this. I personally downloaded HeidiSQL, setup a connection and exported the database. Job done without making any changes to the LIVE environment!

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  15. Batch Process to rename multiple files using Windows DOShttp://mail.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

    of the files). Type the following DELETE rename.bat (removes it from the users computer) Exit the command prompt and we are Done Other Links: DOS - String Manipulation DosTips.com - Forums SS64.com

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  16. Add attribute xsl:nil=true on empty elements using XSLThttp://mail.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

    by the XSLT choose...when...test...otherwise: true true -- yields: assuming value of DATE_OF_BIRTH is blank or null yields Done!

    • Type: Article
    • Author: Joel Lipman
    • Category: XML Stylesheet Language Transformations
    • Language: *
  17. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

    and gimballed. Very close to the ground so will have to watch those landings and thats with thicker than stock pads Done. Here's a video and I will try to post some more: {youtube}tG6Yg0H11U8{/youtube} Noticed a problem with jello. This problem was due...

    • Type: Article
    • Author: Joel Lipman
    • Category: Quadcopters
    • Language: *
  18. Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttp://mail.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

    the game. I'm trying to remove the first two entries from a news feed from a Google News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  19. Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

    in the `wp_options` database table (note: include `wp_postmeta` and `wp_posts` if you want images and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  20. Warning: Save failed. Another menu item has the same aliashttp://mail.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

    created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this will generate your URL. Done

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 41 - 60 of 105

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.