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

  1. Battery Constantly Drained on iPhonehttps://joellipman.com/component/content/article/battery-constantly-drained-on-iphone.html?catid=60&Itemid=165

    running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I wouldn't usually take notice but I think this is a brilliant example where trying to fix the problem is the very cause of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  2. Setting up your store to use SSLhttps://joellipman.com/articles/else/e-commerce/setting-up-your-store-to-use-ssl.html

    conatct your hosting company. To check Virtuemart under SSL you will need to go to the install location. In our example this would be: https://secure.example.com/username/store

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  3. Android: Keytool and Google Maps displaying greyhttps://joellipman.com/articles/else/app-dev/android-os/android-keytool-and-google-maps-displaying-grey.html

    This tells me the alias is "myexampleapp" for this keystore and the SHA1 to add to google which would be: B4:52:80:2B:A0:52:97:FC:6E:66:FF:61:1E:79:20:AD:4A:60:DA:FD;com.mydomain.myappname * In the above, if you have specified the correct bin folder in...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. 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 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 the data. I tried replacing the new lines but just stopping the return key or trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. Transferring Apps (purchases) from iPhone 4s to 5s on a Windows PChttps://joellipman.com/articles/else/app-dev/ios/transferring-apps-purchases-from-iphone-4s-to-5s-on-a-windows-pc.html

    how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: iOS
    • Language: *
  6. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    list yet There's other instructions out there on the web but I thought I'd put what I did so that when I did the above it would all work: Open your form in InfoPath Go into Design mode Go to "Controls" and add a Drop-down List Box to your form...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  7. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change to the script would need to be repeated across the board. The following example is an isolated Script held in a separate solution which other...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    0987654 MAJ Big Bird M 771 771 771 15 The one lookup task: Changing 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  9. Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    so there may be a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; and when comparing to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  10. Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/component/content/article/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html?catid=77&Itemid=165

    an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how...

    • Type: Article
    • Author: Joel Lipman
    • Category: SharePoint
    • Language: *
  11. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    The default time period is 7 days calculated in seconds. If you wanted to change this to update every day, you would use 86400, or 60 seconds * 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  12. Remove write-protect from USB pen in Windowshttps://joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    the USB pen is automatically lost, and that if you use rescue programs, you may corrupt the pen in such that a way that you would need to return it to the manufacturer.

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  13. Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    as I can which I can do by setting up my work computer to be just like theirs (using the same image, etc). Programs which I would NOT recommend I've put a list of programs which I installed and uninstalled just as quickly as they failed to properly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. Print Directory Contents to a Filehttps://joellipman.com/component/content/article/print-directory-contents-to-a-file.html?catid=80&Itemid=165

    A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? We can do this by adding an entry to the context menu (when you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  15. Set up Desktop SlideShow in Windows 7https://joellipman.com/component/content/article/set-up-desktop-slideshow-in-windows-7.html?catid=80&Itemid=165

    happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  16. Error during processing - Converting Date/Timehttps://joellipman.com/articles/else/database/t-sql/error-during-processing-converting-datetime.html

    that you shouldn't try their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have not tested the performance and database load. Before: StudentID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  18. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before: StudentID...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system. What we have: SELECT EmployeeNo , DaysOffSick , DateOfSickness...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  20. Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    a bugger as you need to do a few other things to see the results of this stored procedure. The following are commands that I would run to view the results of the above example: VARIABLE myResultSet REFCURSOR; EXEC...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 141 - 160 of 210