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

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

    expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows: SELECT * FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  2. Developer's Checklist: Taking over a projecthttps://joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

    and 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: *
  3. Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

    We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  4. MyALN.bournemouth.ac.ukhttps://joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

    use their website to reduce the paperwork and manage all the invoicing processes. The site is restricted to staff and students only.

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

    Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ',...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  6. Newbies guide to be the local computer guyhttps://joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

    you print it on your business cards. Hit up local colleges and post flyers there. If you’re going to market to college students, learn how to troubleshoot Macs and iPods. Develop a protocol for troubleshooting common problems It’ll save you time....

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  7. SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

    roles of the Reporting Manager Problem #2: Alternative image if file does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  8. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    but if you get your search result twice, this may be why. Performance Average - Run against a database of circa 30'000 students and their details (incl. courses ~ 700'000 records) took just under 2 minutes (found over 7 million occurrences similar to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  9. SITS: Export field code and namehttps://joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

    to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 1 - 9 of 9

Please publish modules in offcanvas position.