Assuming note is required, the following 299 results were found.
-
on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
may sound 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
1 Me 2 Myself 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
A quick 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...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' AND TABLE_SCHEMA='sample_db' ORDER BY TABLE_NAME, COLUMN_NAME Note that the user launching this SQL query would need the SELECT privilege as a minimum on "information_schema" (arguable).
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions ie. InnoDB. Don't be silly like me and spend hours wondering why...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than GMT or it's clock is seriously off. Otherwise it's a picture...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
This has taken me too long to figure out and I hope I don't lose this note again. The only website that was titled similarly kept slowing down my computer too much so I decided to work out my own. The complexity is due to content also being dynamically...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: en-GB
-
tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through a loop, which entry was first and which was...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays as => "12 Kb" 1478515 bytes : displays as => "1 Mb" 8798745455 bytes : displays as...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...
- Type: Article
- Author: Joel Lipman
- Category: Products
- Language: *
-
format to [h]:mm:ss -- yields 1:00:00 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss -- yields 1:00:00 Note that the first formula is converting person days into minutes and then dividing by 1440 (resulting in the decimal number:...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *