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

  1. 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

    "http://joellipman.com/xml_feeds/my_XML_url.xml" ); $file_xml = simplexml_load_string( $file_content ); // doesn't work and returns a load of parser errors The tweaked command using cURL is: function get_data($url) { $ch = curl_init(); $timeout = 5;...

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

  2. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the...

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

  3. XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

    of digits allowed. Must be greater than zero whiteSpace Specifies how white space (line feeds, tabs, spaces, and carriage returns) is handled Source(s): w3schools.com

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

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

    XML declaration from results $output = substr($output, stripos($output, '?>') + 2 ); // remove leading spaces, carriage returns $output = trim($output); // process if type specified was xml if($apimo_type=='xml'){ // send header...

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

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

    against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending...

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

  6. 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

    specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE! How? The problem is that I have a column which includes the currency symbol as per the following image: I create...

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

  7. Trim in T-SQL and SSIShttps://www.joellipman.com/component/content/article/trim-in-t-sql-and-ssis.html?catid=74&Itemid=165

    Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

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

  8. SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/component/content/article/ssrs-report-builder-20-error-during-processing.html?catid=75&Itemid=165

    The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

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

    DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC BEGIN DECLARE iStart, iEnd, iLength int; WHILE Locate( '', Dirty, Locate( '', Dirty, Locate( '

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

  10. Select unique values in Microsoft Excel columnhttps://www.joellipman.com/component/content/article/select-distinct-values-in-microsoft-excel-column.html?catid=110&Itemid=165

    and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells. Display all Unique Found this note...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 81 - 90 of 90