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 140 results were found.

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

    shockproof BUT NOT joe-proof!... I'm using windows 7 and my day-job machines tend to be windows xp. I found this solution on a windows xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found...

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

  2. Formatting a date in an MDX queryhttps://joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above. Another built-in function is the text-formatter =Format(Fields!myDateTime.Value, "M/d/yy")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  3. T-SQL Record Separatorhttps://joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    need to use the case statement to either put the value or your empty row. Here's an example of the query for a timetabling solution with spacing rows between days. This worked ok but pay special attention to Stage #3 afterwards otherwise if you stop in...

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

  4. T-SQL functions to convert Strings to Tableshttps://joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by...

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

  5. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    this with you in case this your problem too. Source: Joomla Forum: http://forum.joomla.org/viewtopic.php?f=433&t=198257 My Solution I have over 20 joomla websites on my virtual server and I haven't had this problem. I setup a website with about 20...

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

  6. Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/else/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    tables with a CROSS JOIN, (BTW these are not instructions to create some table I'll never use again unlike the rest of the solutions I found on the web). In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module...

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

  7. Getting the mysql where in delimited string to workhttps://joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    to do: SELECT value FROM my_table WHERE my_id IN ('1, 2, 3') SELECT value FROM my_table WHERE my_id IN ('1', '2', '3') The Solution I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL...

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

  8. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    all-in-one query). The DBA responsible for the system asked me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the...

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

  9. Project Plan for Freelance Websitehttps://joellipman.com/articles/cms/website-development/project-plan-for-freelance-website.html

    Services (for .com, .net, .org, etc) - Note you can use the above UK ones for .com domains as well. http://www.networksolutions.com/ http://www.register.com/ http://www.godaddy.com/ http://www.cleverdot.com/ Domain Registrars for domains already...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  10. Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    appear to be fool proof because of the "background:#f7f7f7" specified at the beginning of the code but it is not. My only solution was to propose to set the background as white (#f7f7f7 - white with a tint of grey) and show the customer the unnoticeable...

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

  11. CSS Add Text to Breadcrumb Link with a Transitionhttps://joellipman.com/articles/cms/website-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

    this only deals with the opacity transition as the width transition is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width...

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

  12. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0...

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

  13. FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/cms/website-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

    show. There's a good bit of information from the source link listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *

  14. Embed an FLV file into a web pagehttps://joellipman.com/articles/cms/website-development/html/embed-an-flv-file-into-a-web-page.html

    without installing anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude as this. Copy the below code (beginning and ending with object tags) Paste it into your HTML page Replace both...

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

  15. Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/cms/website-development/php/using-a-html-form-and-php-to-upload-a-file.html

    (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form is setup to do this:...... The form above will post to itself but more...

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

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

    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

  17. Foreign Characters create symbols in PHP and MySQLhttps://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

  18. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://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: *

  19. SITS: Export field code and namehttps://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: *

  20. Accessing Apimo WebService APIhttps://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: *
Results 101 - 120 of 140