Search - Joel Lipman .Com

1. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Why? I've written this article as it took a while to achieve. The Zoho People application and its API are documented but there are problems with the documentation at the time that this article was ...; Created on 10 December 2020
2. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an access token used in OAuth2.0 ...; Created on 13 January 2020
3. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
4. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... Addtional: Problems animating the camera to your current location? I had to add the following: LatLng myCoordinates = new LatLng(latitude, longitude); CameraUpdate yourLocation = CameraUpdateFactory.newLatLngZoom(myCoordinates, ...; Created on 10 October 2014
5. Joes Syntax Styler (JSS): / Product Documentation /; Before you ask, I tried Google Prettify and Alex Gorbatchev's Syntax Highlighter but both were causing problems for the sites I wanted to use it on. Mainly because of JavaScript frameworks (like jQuery ...; Created on 06 April 2013
6. SSIS Convert a string into a date: / SQL Server Integration Services /; ... problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had been setting it to "fixed width" but then got problems with it not ...; Created on 14 March 2013
7. Set up Desktop SlideShow in Windows 7: / Windows OS /; ... be a breeze, but that's because I don't implement group policies at home. Why? We get problems with this because none of our staff are full administrators of their local workstation. As IT staff ...; Created on 22 January 2013
8. MySQL day of week ending on Friday: / MySQL /; ... Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the ...; Created on 26 April 2012
9. Strip HTML in MySQL: / MySQL /; Just 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? ...; Created on 06 December 2011
10. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... "Dataset2")) - CDate(First(Fields!REPORTSTARTTIME.Value, "Dataset1")) ) // yields // 00:00:02.1543570 -- problems with adding a string to it? CStr will not work, use .ToString ="Time Taken: ...; Created on 17 November 2011
11. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but unfortunately SSRS process both ...; Created on 04 November 2011
12. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values cannot be used in report parameter expressions" ...; Created on 19 July 2011
13. Newbies guide to be the local computer guy: / IT Support /; ... iPods. Develop a protocol for troubleshooting common problems It’ll save you time. Underpromise and overdeliver. Source: http://www.reddit.com/r/IAmA/comments/9usm7/iama_local_tech_repair_man_i_run_my_own_business/ ...; Created on 28 April 2011
14. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS ...; Created on 29 March 2011
15. PHP & MySQL Search Engine: / Personal Home Page /; ... sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple ...; Created on 09 March 2011
16. Parameters not being used in report processing: / SQL Server Reporting Services /; ... 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format ...; Created on 07 January 2011
17. Connection Strings for SQL Server: / SQL Server /; ... option is available from Connector/NET version 5.0.3. In earlier versions, this option has no effect. Using encryption, alternative Some reported problems with the above one. Try replacing the ...; Created on 05 January 2011
18. Joes Word Cloud (JWC): / Product Documentation /; Installation Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your ...; Created on 13 October 2010
19. Windows 7 Aero Features: / Windows OS /; ... Did anyone else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by ...; Created on 27 April 2010
20. Windows 7: System Clock is constantly going out of sync: / Windows OS /; ... setting as per the below. If you have never used the system registry before, ask someone who has. Additional (intended for Vista users) The following is an excerpt from http://www.howtogeek.com/howto/windows-vista/dealing-with-windows-vista-time-sync-problems/ ...; Created on 28 January 2010