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

  1. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT( DAYOFMONTH(calendar.StartDate), '-',...

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

  2. Generate a Timesheet in MySQL https://joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

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

    (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for Joellipman.com below) Similar looking websites and colour schemes Will the website be...

    • 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

    left the institution. It was a custom-built site written from scratch, and it's purpose was to manage Staff and Students within the Additional Learning Needs group. These are staff who take lecture notes for people of all disabilities and assist the...

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

  5. CSS Center an iFrame Horizontally and Verticallyhttps://joellipman.com/articles/cms/website-development/css/css-center-an-iframe-horizontally-and-vertically.html

    the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app within the iframe has an alert message, it popups a div at the centre of its app. The alert message is always at the center of...

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

  6. Slideshow div layer through a windowhttps://joellipman.com/articles/cms/website-development/mootools/slideshow-div-layer-through-a-window.html

    to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm...

    • Type: Article
    • Author: Joel Lipman
    • Category: MooTools Framework
    • Language: *

  7. Creating a Top 10 chart with less codehttps://joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

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

  8. UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a...

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

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

    loading UTF16 content into SimpleXMLElement or simplexml_load_string, it doesn't solve my problem. I'm receiving XML data within a cURL result but I get the above error with using either "SimpleXMLElement" or "simplexml_load_string". Returning the XML...

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

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

    to use the newly uploaded report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: *

  11. Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation,...

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

  12. Import Excel CSV file as JavaScript arrayhttps://joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function populate_array_from_csv(this_file){ // using deprecated...

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

  13. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/component/content/article/ms-excel-split-workbook-into-separate-files-per-sheet.html?catid=110&Itemid=165

    first subroutine "RunAll". Here's a quick summary of what the below script does: Splits one spreadsheet to several sheets within the same workbook. Inserts a blank row at the top of each of the created sheets. Copies the header from the first sheet into...

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

  14. Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

    taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

  15. SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *

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

    User Name\AppData\Local\Google\Chrome\Application\chrome.exe" -incognito) Additional Note 201004201256: The shortcut key within Google Chrome is holding down the Control and Shift key and then pressing the letter N.

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

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

    failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the problematic...

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

  18. SSRS Repeat Headers in PDF Reporthttps://joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

    Set "FixedData" to "True" if you want the headers to scroll with the report when viewed on the Reporting Server or within your IDE. Set "RepeatOnNewPage" to "True" for the headers to repeat on every generated page.

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

  19. Regular Expressions in SQLhttps://joellipman.com/articles/else/database/regular-expressions-in-sql.html

    perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  20. Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment. How? Consider the following: SELECT ps.person_id, ps.person_name, ( select pa.person_reference as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
Results 81 - 100 of 102