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

  1. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

    Following up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  2. Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

    Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  3. Webdeveloper-Speakhttps://www.joellipman.com/articles/web-development/webdeveloper-speak.html

    I don't usually write an article on another site but I came across it and rather than just add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html

    Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  5. Language Codeshttps://www.joellipman.com/articles/cms/joomla/language-codes.html

    Having started developing multi-language components, it was important that I get a general idea as to what languages are abbreviated to. Usually I only write english files (en-GB) but it's not very international and narrow-minded to think only English...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  6. Change the login link in MediaWikihttps://www.joellipman.com/articles/cms/mediawiki/change-the-login-link-in-mediawiki.html

    As usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this: We have an internal wiki knowledge base using MediaWiki version 1.14. Some articles are available for public, some are...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  7. Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

    What? This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  8. Joes Word Cloud (JWC)https://www.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

    Installation Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

    This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario: Joomla works fine with international characters A Module Extension I wrote for Joomla!...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  10. RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  11. Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

    The following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  12. Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

    The following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  13. SQL Queries for Statisticshttps://www.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

    Basically, I've started using so much more SQL in our new Business Intelligence projects that I've been revising all my scripts to see what SQL I can optimize. One of my systems is a MediaWiki CMS which is used for the official Bournemouth University...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  14. Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

    Download Connectors from dev.MySQL.com MySQL Connector/Net Type: .NET Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  15. Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

    Well I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

    Thought I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  17. Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    Once again I've spent a whole morning going in the wrong direction with a convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. Merge the content of two similar tables in MySQLhttps://www.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

    1 Welcome This is Joomla 2 Copyright This site and its design is property of JoelLipman.com HP Articles (table name: jos_hp_items): id name description -------------------------------------------------------------------------- 1 Welcome This is HP 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. Albert Schweitzerhttps://www.joellipman.com/articles/_other-misc/albert-schweitzer.html

    Do something wonderful, people may imitate it.

    • Type: Article
    • Author: Webmaster
    • Category: Hobbies
    • Language: *
  20. Formatting a date in an MDX queryhttps://www.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

    Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The other formats are: =FormatDateTime(Fields!BirthDate.Value,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
Results 141 - 160 of 655

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.