Assuming this is required, the following 575 results were found.
-
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem?...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
like so that my post-staging phase can be developed as it will know what the data and label fields look like. How? I had this in my training environment but not in my development environment. I had to create a Data Exchange Format first: Run the DEF...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. How? Basically don't have the following declared more...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
like this video to show to clients regarding why advertising and mobile apps are generating funds {youtube}CjUcq_E4I-s{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
Calculate Aspect Ratiohttps://www.joellipman.com/graphic-design/calculate-aspect-ratio.html
So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
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 quickest I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
m_Payload.put("prompt","login"); Great! What follows is the code I'm using to convert this: v_Endpoint = "https://api.joellipman.com/myapi"; l_UrlParams = List(); for each v_Key in m_Payload.keys() { l_UrlParams.add(v_Key.toString() + "=" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This article is a quick note on how to change your Joomla CMS "Read More" to "Register to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html
end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF