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

  1. Windows 10: Shortcut Apps to Settingshttps://joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice....

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  2. Formatting a date in an MDX queryhttps://joellipman.com/articles/else/database/t-sql/formatting-a-date-in-an-mdx-query.html

    used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this when setting date as the parameter and trying to specify default date as today's in the format DD/MM/YYYY. Googled this but couldn't find...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  3. T-SQL DateTimestampshttps://joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/else/database/oracle-pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    is another environment variable used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/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

    still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go through the logs, try setting up a test joomla site with a different database and user and see if that behaves the same way. Virtual Hosts I used to have an...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  6. MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/else/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    week/year, person days, resource names, and the activity (+ any others you may want to drill-down). Setup ODBC: Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) > System DSN (get technical help if you don't know how to do...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. Generate a Timesheet in MySQL https://joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  8. What's the problem? Amusing computer issueshttps://joellipman.com/articles/cms/website-development/whats-the-problem-amusing-computer-reports.html

    side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up the workstation with updates etc. as per our standard image. The printer was connected via three usb extension cables. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  9. Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/cms/website-development/css/background-disappears-on-long-pages.html

    was because the template I was using was not actually specifying "white" as the contents background-color and was in fact setting a gradient as the background. Consider the following: /* ERROR CSS: DO NOT USE !!! */ background: #f7f7f7; background:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  10. 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

    work for me because I'm using cURL but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    and not ANSI Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" Conclusion: The final fix in my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  12. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    guideline(s). Set the object’s size and position by right-clicking the field, selecting Object Size and Position and then setting the XY coordinates. Use the horizontal and vertical rulers as a reference when specifying height, width, and XY...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *
  13. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    to match the same style and dimensions. To start, type /prefer suffix Type Type the parameters you want as default Press /settings Settings will default some settings although, again, I wouldn't recommend these if you're just starting off. Leaving these...

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

    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 (top, right, bottom,...

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