Assuming comes is required, the following 25 results were found.
-
amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08"...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
guy says, "167." The robot proceeds to chat with him about subatomic physics, black holes, and game theory. Curious, the guy comes back a second night. "What'll you have?" says the robot and the guy again receives the best martini of his life. "What's...
- Type: Article
- Author: Joel Lipman
- Category: Jokes
- Language: *
-
Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to deal with room bookings and said we shouldn't use Outlook for this... The DataSet The script I used to generate the dates comes from www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/ DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Check Usernames/Passwords (formats, defaults and vulnerability) Technical 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,...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
newsletter so it's unlikely you'll ever hear from my site. I never email for personal details, passwords etc so if something comes from my site it should only be if you contacted me first :c) FAQs Question What's the "lastscreenshot.bmp" image for?...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels"...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
select query is pulling data from my CTE in its post-formatted form. I perform all the formatting within the CTE and when it comes to the CASE events comparing to the previous row, all I do is say display this value or display a blank value based on if...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
value FROM my_table WHERE my_id IN ('1', '2', '3') The Solution I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
in section 4 to “keep intact all notices”. c) You must license the entire work, as a whole, under this License to anyone who comes into possession of a copy. This License will therefore apply, along with any applicable section 7 additional terms, to the...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
paid for a commercial version of a Microsoft product which cannot possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form... There are...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
on this one as I could only embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description....
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
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 needed to create a template in HTML where the first page is a cover page (background image filling the...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I'm...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
i had). This is how to make sure it shows on the template style and how to position it on the image slide show module that comes bundled with the extension.{youtube}qOWGxgyoqA4{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
} return r_ReaderPaymentHandOff; The incoming webhook You now need to receive the Stripe webhook when it comes back into ZohoBooks to record it against the invoice. Note how we added the invoice reference and Zoho ID in the description of the payment...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
line items and created SO (fix to invoice only generated on edit) Date Modified: 2023-03-29 (Joel Lipman) - If an eBay order comes through as cancelled, then void the sales order, void the invoice, delete the package and shipment. - Added chart of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes from a Creator form, no InvokeURL needed c_Form = Form[ID == 1234]; r_Download1 = c_Form.myFieldWithFile; ***/ l_Downloads = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF