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

  1. Inserting incremental weeks in MySQLhttps://joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    year ends halfway in a normal people's calendar, so you actually have to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what...

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

    figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. 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: *
  4. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    that could have saved an infinite number of man-hours (I exaggerate a little); but seriously, I needed a checklist that works for me. Most Difficult? My hardest project was (still is) one created by a PhD student who graduated and left the institution....

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

    bottom, #f7f7f7, #f4f4f4); background-clip: padding-box; border-radius: 0 0 5px 5px; Harmless you might say. Works fine on a small page but I have discovered limitations with the majority of browsers when having to spread gradient backgrounds across a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  6. CSS Printing - Page Break Inside with Headers and Footershttps://joellipman.com/articles/cms/website-development/css/css-printing-page-break-inside-with-headers-and-footers.html

    for a footer. @page { size: A4; margin: 3cm 1cm 2cm 1cm; } @page :first { size: A4; margin: 0cm 0cm 0cm 0cm; } If this works for you then brilliant because it didn't work for me... I guess I'm special, this is what I had to do: @page { size: A4; margin:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: *
  7. CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/cms/website-development/css/css-center-an-iframe-horizontally-and-vertically.html

    instead of determining heights and alignment with JS. The following code will work with DIV layers but in this case, also works on iframes: HTML: Horizontally and Vertically Centered Iframe CSS: body { background:red; } iframe { position: fixed; top:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Cascading Stylesheets
    • Language: en-GB
  8. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/cms/website-development/js/inline-labels-in-form-fields-using-javascript.html

    the value of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing you to type normally. Clear...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  9. 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

    you check after the script has completed. Do the following step to keep the file in a specified folder. 5. Form processing works so now test the actual file upload Add the following code after the above code sample in step #4: if (file_exists(""....

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  10. UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    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! displayed funny characters. The Joomla! articles...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. 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

    "http://joellipman.com/xml_feeds/my_XML_url.xml" ); $file_xml = simplexml_load_string( utf8_encode( $file_content ) ); // 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  12. SITS: Export field code and namehttps://joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    you should get something like: 5826|England Almost! If the code and it's short name/full name exist in the database, this works accordingly. If however, for some reason the code does not exist the code lookup will fail: -- If CODE=0000 and 0000 does not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
  13. Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=105&Itemid=165

    parameter ("float") relative to its container. - Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height" values. - Date...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  14. Crystal Reports: Exporting to Excel omits column headershttps://joellipman.com/component/content/article/crystal-reports-exporting-to-excel-omits-column-headers.html?catid=110&Itemid=165

    unnecessary extra gridlines (the ones that appear in the ruler as little arrows). So right-click on a heading text box that works Select "Size and Position..." Copy to clipboard the exact height value Right-click on a faulty heading textbox Select "Size...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  15. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    this added field to the Report Filter section (click on it and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  16. Import Excel CSV file as JavaScript arrayhttps://joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    array by a object label function populate_array_from_csv(this_file){ // using deprecated XMLHttpRequest to read file // (works at time of print (2015-10-05)) var xhr = !window.XMLHttpRequest ? new ActiveXObject('Microsoft.XMLHTTP') : new...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  17. Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    all up for any suggestions people might have on how this can be improved but it's the one I'm going on for the moment which works fine.

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *
  18. Mouseover Links in AutoHotkeyhttps://joellipman.com/component/content/article/mouseover-links-in-autohotkey.html?catid=48&Itemid=165

    GuiClose: close: Gui, Destroy ExitApp Now this results in a tiny GUI that displays the link in black and works (somewhat). If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  19. Zoho Deluge - MD5 functionhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-md5-function.html

    just replace the base64encode function with an MD5 function, like so: v_Etag = zoho.encryption.md5(v_Combined_Fields); // WORKS! Returns a hexadecimal 32 character string Arguably, I'm using Creator 5 and the documentation for the encryption tasks are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  20. Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/component/content/article/windows-7-and-google-chrome-incognito-mode-by-default.html?catid=61&Itemid=165

    on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character to the beginning and end...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
Results 61 - 80 of 81