Assuming might is required, the following 63 results were found.
-
wasn't able to select the performance modules (Client Review and Placement Tech Survey having been disabled)... How? So this might seem obvious but after trying to scan the meta data (snippets at the bottom of this article), the simplest way was right...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
"Themes", and "Imagesets", my first phpBB3 index page with the affinity template finally worked!!! Chuffed to bits as you might imagine but clicking on any other link returned an error something along the lines of "template tpl load file styles...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Joomla CMS and if it helps anyone else out there. How? There aren't too many steps but this is what I went through and I might amend this if I see any new issues: Preamble Set up a new folder in my public_html\joellipman_site\ for my 2025 production...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
button. When that's done, Right-click on the new phone and select "Restore from Backup..." Select the backup you just made (might default to a different backup so click on the dropdown to make sure it's the one you just made). Enter the password you...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
(-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, TRUE); END sp_get_studentdetails_from_ad; Permissions on this SP Might need to give permission for your SSRS user (specified credentials in data source) to run this stored procedure. CREATE PUBLIC SYNONYM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
* 60 minutes * 24 hours * 1 day. I wouldn’t recommend setting this to anything less than 4 hours worth, or your computer might get banned by the time servers. Change Your Firewall Settings Third party firewalls will often block the time servers, causing...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Drop If Object Existshttps://joellipman.com/articles/else/database/t-sql/drop-if-object-exists.html
at the bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID (...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
1 2011/2012 1 2011-07-18 00:00:00... 52 2011/2012 52 2012-07-09 00:00:00 Joe you're an idiot! You might say to me why not run the CMIS Facility application and add a new set, it will put these dates in automatically. Herein lies the problem The reason...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') OR `fulltext` LIKE CONCAT('%',@stringtoFind,'%') You might get some errors talking about some empty rows but don't be deceived as the update will have happened anyway. Other Searches Search and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Importing Before importing a SQL file, check that nothing in it instructs it to use a specific database (otherwise you might overwrite your LIVE/production database). Click on the Data Import/Restore link in the left panel.
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
linear-gradient(to bottom, #f7f7f7, #f4f4f4); background-clip: padding-box; border-radius: 0 0 5px 5px; Harmless you might say. Works fine on a small page but I have discovered limitations with the majority of browsers when having to spread gradient...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
'_', url_counter); set url_counter = url_counter + 1; end while; END; | DELIMITER ; Note that running this in PhpMyAdmin might show as an error, possibly due to the delimiters, but you can run it anyway. Additional Note(s): The trigger only runs if...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
to: Microsoft Windows 7 Enterprise 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....
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
of DATE_OF_BIRTH is blank or null yields // -- errors How? I could correct this using SSIS but with all the data in XML, we might as well stick with the technology and we're going to keep our XSLT with some slight modifications. First let's look at the...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
VIEW ON *.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Suggestions? I'm all up for any suggestions people might have on how this can be improved but it's the one I'm going on for the moment which works fine.
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
work from home offers can be pyramid schemes which require you to recruit other members to get paid. For example, an ad might say that you can make £100 an hour by stuffing envelopes. But to make that money, you need to sell the system to others. For...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *