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

  1. List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

    levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups (required to view the category): Page ID, Title, Content, Category, Groups SELECT p.page_id AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
  2. Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

    key performs a "send" operation, delivering the text to its target. IME_ACTION_UNSPECIFIED // no specific action has been associated with this editor, let the editor come up with its own if it can. Source(s) developers.android.com : TextView -...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  3. SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    -like excel- to select the column). Select "delete columns". Still deleting: Make sure you select "delete columns and associated groups": Overview: So the following screenshot is how your report should look now. Result: You can even run/preview it and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  4. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    The association to a user can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as staff or student. Number of total hits aggregated by month with on-peak/off-peak. SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  5. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked me to look at ways of reducing the...

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

    into the morning and afternoon slots. All days and time slots must be listed irrespective of whether any time has been associated to them. We need to be able to specify any date, and the system returns the timesheet for the week that date occurs in....

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  7. Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/component/content/article/amazon-kindle-send-pdfs-to-your-kindle.html?catid=121&Itemid=165

    Under Device Summary, you will be shown a host of information related to your device, which includes the email address associated to your Kindle. Copy and save the email at your desired location, for that’s the email id you need to send files to for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Kindle
    • Language: *
  8. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *
Results 21 - 28 of 28