Assuming wanted is required, the following 78 results were found.
-
which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how to do this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
0.187s STATEMENT2 741 rows 49.933s STATEMENT3 741 rows 48.844s STATEMENT4 741 rows 49.603s And Vice-Versa? Well actually I wanted all the articles that have NOT been approved yet... So would this work if I switched MyTable1 with MyTable2? Um I'll get...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
their respective IP ranges. ip_lookup.php: to use the database License.txt: Released under GNU/GPL ReadMe.txt What is it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address, this is what I use. The scripts in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
website has initiated a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The part of a webpage that is visible in the web browser window when the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why? I warned that a 301 site gets removed from the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective social network's site....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules positioned in the "right" div. I specified width of left...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
the web were only partial and thought I'd write a full example here. No jQuery and using the Google Chrome browser. I wanted to: Sort the array by its values my_records.sort(); Iterate through and output these in HTML for(i=0;i y ? 1 : 0; }); // use...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
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. Why? Let's take the country of birth...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted IP...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
CPanel and clicked on "Generate, view, upload, or delete your private keys". Clicked on "Edit" alongside the domain name I wanted to install this SSL for. Copied the "Encoded Private Key" to clipboard and pasted this back under "Install an SSL Website"...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic memory to do the same. My...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB