Search - Joel Lipman .Com

21. MySQL: Find all non-alphanumeric rows: / MySQL /; What? 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? ...; Created on 09 September 2013
22. Things to Check if Joomla Password Reminder email not being sent: / Joomla /; What? A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things ...; Created on 09 May 2013
23. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... matched the TNSNAMES.ORA file located in "C:\ORACLE\product\11.2.0\client_1\network\admin". Furthermore I've been asked why aren't all our Oracle databases the same version? It's due to the fact that ...; Created on 04 March 2013
24. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; What? I misunderstood what was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following ...; Created on 09 November 2012
25. UNC Paths in Sharepoint 2007 links: / SharePoint /; Applies to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. ...; Created on 08 November 2012
26. Search a database with SOUNDEX: / Databases /; Why? Data Consistency. I was tasked with finding variations of our default values. End-users were complaining that some default values get listed twice because their system was case-sensitive despite ...; Created on 11 October 2012
27. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012
28. Print Directory Contents to a File: / Windows OS /; Why? A friend asked me if there was a quick way to simply right-click on a folder in Windows Explorer and it would generate a text file with the contents of the directory he right-clicked. What? ...; Created on 19 July 2012
29. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked ...; Created on 27 April 2012
30. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull off. After much umming ...; Created on 16 January 2012
31. MediaWiki: MySQL to extract path to images: / MediaWiki /; ... for my own benefit as it's unlikely I'm asked for an entire export. Should yield something like: img_name img_size img_user_text img_timestamp img_path img_path_with_file ============== ============== ...; Created on 06 December 2011
32. T-SQL Record Separator: / Transact-SQL /; I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" ...; Created on 11 October 2011
33. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... by dragging the curser over the webpage. Frequently Asked Questions What is a pwb? - A variable that contains a pointer to the web browser object (Internet Explorer). Here ...; Created on 05 July 2011
34. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... doesn't care. Question How can this be 100% FREE? Answer: I'm being asked why not charge for this. First of all it's incredibly difficult to charge for a program that integrates other people's code; ...; Created on 28 June 2011
35. SSRS Hide results table if empty: / SQL Server Reporting Services /; Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value ...; Created on 29 March 2011
36. PHP & MySQL Search Engine: / Personal Home Page /; ... flexible with us as some customers have asked how does it get that word and why is it relevant? (when it isn't, the sound matches and then it's a typo on the sound so it matches words that are vaguely similar ...; Created on 09 March 2011
37. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing ...; Created on 30 January 2011
38. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the below expression: Delete Order Column: Ok the expression and BIDS will add the parent group ...; Created on 14 January 2011
39. K2 Items disappear: / Joomla /; ... where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired ...; Created on 27 August 2010
40. Running Internet Explorer 6, 7, 8 as standalones: / Windows OS /; ... I only have the one workstation :eek Still I've been asked to test some web applications (???) so I had to find a solution to suit me. I'd done this before IE7 (so a long time since). My ...; Created on 18 May 2010