Assuming based is required, the following 108 results were found.
-
ID Employee Subject Grade 1 001 Computer Science BSc 2.1 2 001 Superman 10/10 3 002 Tape-Monkey Engineer 1:0 So based on this logic, the Employee "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one has two sections, the first part capitalizes any letter after a non-alpha letter. The...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
a zero isn't inserted. Note: Running just one of the queries will work as normal with the NVL function. Running the second based on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original data but the same length and the same type of data. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
(VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
We want to bring back the articles that aren't listed in the audit table (articles yet to be approved). So this will be based on the SQL query to get just your articles from your MediaWiki CMS: -- to get articles from MediaWiki CMS: Let's call it...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
(subtract 1 so this is not inclusive). Crude solution but it works in Excel 2007 Now we want to filter the pivotTable data based on these two values... (I don't like the idea of requiring macros as not all users switch this on and teaching executives on...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Simply don't refer to the table after the DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases s and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). I also need to use Oracle databases in my day...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html
add it to my weblinks section, I thought I'd give it a little more credit. "Motive is a web design and development agency based in Wellington, New Zealand providing consultation, website design, development and usability evaluation services." Their...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header Left Right Footer Situation The header displayed fine....
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
a remainder of zero but I'm not 100% sure this fixes the issue throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script is using the remainder when it should be discarding it.
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
outside) 1. Item 1 1.1 Item 1a 1.2 Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter;...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
Seconds If you are interested to know the machine configuration, these tests ran on a Celeron 1.6GHz processor based laptop with 768 MB of RAM. And I am using PHP 5.1.1 Source: http://hasin.wordpress.com/2007/04/30/c … functions
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality but nothing...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Mon, 18th Jul 2011 1.6.4 - Added Joomla! Admin Option: Module Content Caching - Added Joomla! Admin Option: Include content based on User Level - Added Joomla! Admin Option: Include Category IDs - Added Joomla! Admin Option: Exclude Category IDs - Added...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
from the HTML file launching this function (not from the if external JS)) // add parameters to this function to specify rows based on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array =...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
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 some conditional...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB