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

  1. Importing Joomla articles to WordPress postshttps://joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    0 'term_order' FROM my_joomla_db.jos_content b ORDER BY b.id; Importing Joomla jComments to Wordpress Posts:...still to come...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  2. 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

    the text to its target. IME_ACTION_UNSPECIFIED // no specific action has been associated with this editor, let the editor come up with its own if it can. Source(s) developers.android.com : TextView - android:inputType developers.android.com : EditorInfo...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  3. SSIS Multiple Lookups in onehttps://joellipman.com/component/content/article/ssis-multiple-lookups-in-one.html?catid=74&Itemid=165

    are never blank so it is safe to to use "Lookup Match Output" as rows with neither sequence nor student reference will not come through the system. Lookups that failed will return as NULL. Selecting the fields to output into the data-flow: sequenceID...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  4. SSRS Hide results table if emptyhttps://joellipman.com/component/content/article/ssrs-hide-results-table-if-empty.html?catid=75&Itemid=165

    this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] ,1 Counter FROM [ROOMEQUIPMENT] re INNER JOIN...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  5. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. Copy a table with structure and data into a temporary tablehttps://joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    I wouldn't need to post this note on my website. Thinking outside of the box Hooray for you non-sheep! This is what I've come up with: -- Drop Stored Procedure if already exists IF OBJECT_ID ( 'dbo.usp_MakeTableTemp', 'P' ) IS NOT NULL DROP PROCEDURE...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  7. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  8. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    Things I stumbled upon regarding SSL and cURL Posted data for third-party apps is often required via SSL so this may come in handy curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); // TRUE to output SSL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  9. Submit form as a server and not the client with cURLhttps://joellipman.com/component/content/article/submit-form-as-a-server-and-not-the-client-with-curl.html?catid=109&Itemid=165

    checked against, and it just wouldn't be manageable to add every new user's IP address to their service. The request has to come from a permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  10. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  11. MS Excel - Sort pivottable column headings by datehttps://joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that "10" comes before "8" and it does but just to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  12. Clicking on a weblink returns a 404 errorhttps://joellipman.com/articles/cms/joomla/clicking-on-a-weblink-returns-a-404-error.html

    If you are in the administration panel and you are editing your weblinks and you come across this error: "404 - An error has occurred. Joomla! was unable to locate the stated resource." Just check that the category the link is in is published.

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  13. Border settings not saving in SSRShttps://joellipman.com/component/content/article/border-settings-not-saving-in-ssrs.html?catid=75&Itemid=165

    show for empty spaces. I wasn't getting very far because I'd even ask the border to be grey and save the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Live WebCam feed of Bournemouthhttps://joellipman.com/articles/cms/website-development/live-webcam-feed-of-bournemouth.html

    moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  15. Mirror's Edge Prologue Speedrun Under 2:00https://joellipman.com/component/content/article/mirrors-edge-prologue-speedrun-under-200.html?catid=96&Itemid=165

    game so quick-paced and varied giving you that freedom of completing the game your way. The sountrack is November has come by the Gorillaz {youtube}h5a3RElr7Hs{/youtube}

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  16. Can't play music after Firmware Update Version 3.0https://joellipman.com/component/content/article/cant-play-music-after-firmware-update-version-30.html?catid=116&Itemid=165

    Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 21 - 36 of 36