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

  1. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    I've returned to the process where one SQL query returns all possible results and the PHP script runs another SQL query for each row to check the ID does not exist in the audit table... -- Note: This article was updated on 2011-04-19 11:54

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

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

    January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he also forgot the academic year ends halfway in a normal people's...

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

  3. MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/else/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you...

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

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

    few things we have to deal with still: We have lost the rows with days that have no events. We need to group by days so that each day only outputs one row (see Thursday). We want the earliest time and the latest time per morning and afternoon slot....

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

  5. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table...

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

  6. Webdeveloper-Speakhttps://www.joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    criticism. initialism An initialism is a phrase or multi-word name that has been abbreviated to the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author webpages), is an...

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

  7. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    Review Examine all functions: what goes in, what comes out? (accepts/returns, data types specifically, test by running each function separately) Examine databases (data types, constraints, primary/foreign keys, autoincrements, schema diagram, scheduled...

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

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

    (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over...

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

  9. URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/cms/website-development/php/url-alias-uniqueness-with-php-mysql.html

    DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1;...

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

  10. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    Monitoring the monitors Some useful tools: Stu-Talk Monitor Details (SMD): The SITS application audit giving details on each process. Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters. Stu-Talk Monitor Summary (STMS): Specify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  11. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be unlinked and relinked each time further dates get added which is why you should leave it in ascending order if you don't want this overhead.

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

  12. Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/component/content/article/excel-convert-degrees-minutes-seconds-to-decimal.html?catid=110&Itemid=165

    // will work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1,...

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

  13. Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

    Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added...

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

  14. GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did...

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

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

    ready to send PDF files to your Kindle device. Also, the above steps are a one-time process and won’t need to be repeated each time. So, what you need to do now is simply send an email to the Kindle email ID with the PDF file attached to it. Also, you...

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

  16. Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-check-time-booking-slots.html

    work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration = 90; bool_doubleBooked=false; for each thisRecord in allRecords { thisRecord_StartTime = thisRecord.req_StartTime ; thisRecord_EndTime =...

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

  17. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing a whole page for this is probably unwarranted so...

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

  18. Android Background Image Resolutionshttps://www.joellipman.com/articles/else/app-dev/android-os/android-background-image-resolutions.html

    image I was using was unedited at 1600x2133 (364kb) and was not displaying on smaller devices. Configuring drawables for each layout seemed to be the only solution. res/drawable-ldpi 240x320 res/drawable-mdpi 320x480 res/drawable-hdpi 480x800...

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

  19. SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/component/content/article/ssrs-expand-specific-drilldown-by-default.html?catid=75&Itemid=165

    MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want...

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

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

    tablix header... obviously). I right-clicked on the header row of the tablix and checked the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 181 - 200 of 209