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

  1. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/cms/website-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    on line ### Why? So I've googled, binged and yahoo'd for this and although there are some solutions that deal with loading UTF16 content into SimpleXMLElement or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  2. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    a question mark inside a diamond shape instead of the foreign character. How does it happen? Have I tried the other solutions on the web? I have tried adding the following to my headers: This does nothing: // add these to the header: DOESNT WORK...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  3. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/cms/website-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

    works! DONE! Stop reading any further and tell your boss it was always in hand. Other things I tried but to no avail The solution above was as easy as that. Here are a number of other things I tried first: mysql_set_charset(): No iconv(): No...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  4. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    CODE is not populated, -- Using &G[COD.SRS:•|•]&ABLANK="*LookupFailed*" -- yields: A colleague of mine found this ABLANK solution. It took two of us the best part of two days to come up with the SRL syntax... Our XSLT can then do the following: -- for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  5. Accessing Apimo WebService APIhttps://www.joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    of getting the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); // specify company ID $company_id_1 = 1234;...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *

  6. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  7. MS Excel: Convert a text to a numberhttps://www.joellipman.com/component/content/article/ms-excel-convert-a-text-to-a-number.html?catid=110&Itemid=165

    could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should work. My solution Include the space (if there is one) in the substitute formula: =SUBSTITUTE(B3, " ₱", "") The resulting value will still need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  8. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    End Sub Press F5 to run the code. A separate file will be created for each sheet in the same folder. A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB

  9. Make bootstrap carousel responsive to swipehttps://www.joellipman.com/articles/cms/website-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

    will suggest to load the jQueryMobile library but that started messing up the template layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: Bootstrap
    • Language: *

  10. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an article on my own site....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *

  11. Reminder on SSRS row separatorhttps://www.joellipman.com/component/content/article/reminder-on-ssrs-row-seperator.html?catid=75&Itemid=165

    are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group"...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  12. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    Microsoft Business Intelligence Development Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  13. SSRS No Delay for First Report of the Dayhttps://www.joellipman.com/component/content/article/ssrs-no-delay-for-first-report-of-the-day.html?catid=75&Itemid=165

    This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  14. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working Solution: SELECT ps.person_id, ps.person_name, ( select txt from ( select pa.person_text as txt, pa.person_reference as personid,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  15. Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  16. Ordered List of over 1000 Itemshttps://www.joellipman.com/articles/cms/website-development/css/ordered-list-of-over-1000-items.html

    So many people asking this when the solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *

  17. How to make a HTML form post its variables to itselfhttps://www.joellipman.com/articles/cms/website-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

    a PHP page which generates a HTML form. When the user submits the form, you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB

  18. Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/cms/website-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

    hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard European format:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  19. First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/cms/website-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

    out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 121 - 139 of 139