Search - Joel Lipman .Com

21. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- ...; Created on 18 August 2014
22. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014
23. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connec: / MySQL /; ... "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears ...; Created on 28 July 2014
24. 301 Redirect using htaccess file: / Web-Development /; What? There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. ...; Created on 03 April 2014
25. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... letter in addition to the above specification. I am storing it here so that I can work on improving it: /* Microsoft SQL Server Integration Services Script Component * Write scripts using Microsoft ...; Created on 04 October 2013
26. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
27. Export/Import Database using MySQL Workbench: / MySQL /; What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...; Created on 05 February 2013
28. Access MySQL databases using Oracle SQL Developer: / MySQL /; ... all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013). ...; Created on 01 February 2013
29. JDatabase: using the Joomla database with examples: / Joomla /; What? Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation ...; Created on 27 January 2013
30. Free Translator API using Google: / Google /; ... exists. Just don't try to exceed your free quota: Visit http://translate.google.com/manager/website Sign in using your Google APIs developer's account (FREE). Copy the JavaScript they give you (eg. ...; Created on 08 January 2013
31. Generate Academic Calendar using MySQL: / MySQL /; ... acyear.SetID FROM joes_weekstructure acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using ...; Created on 27 November 2012
32. List last modified files using FTP Command-line: / File Transfer Protocol /; ... do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" ...; Created on 20 November 2012
33. Inline Labels in Form Fields using Javascript: / JavaScript /; ... spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison ...; Created on 21 August 2012
34. First and Last Entry on a Page using Modulus Remainder: / Personal Home Page /; So I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what ...; Created on 26 September 2011
35. What's the problem? Amusing computer issue: / Web-Development /; If you're not an IT person, you may want to avoid reading the rest of this article in case you're easily offended. It's just an amusing stab at customers computer issues. Note that most of the below were ...; Created on 28 April 2011
36. CSS Background Without Causing Scrollbars: / Cascading Stylesheets /; Quick note in case I spend as long as I did again. A Client had some clouds on the background of his photoshop file for his website. They were to be positioned in the top right corner with the leftmost ...; Created on 23 April 2011
37. Increment a column in MySQL using the UPDATE query: / MySQL /; Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the ...; Created on 18 February 2010
38. Using K2 with jezReCaptcha plugin causing errors: / Joomla /; ... supported anymore so I wouldn't recommend using the JezRecaptcha plugin. In fact I'm not impressed with Recaptcha as it's sound alternative doesn't work and the text form is hackable. I will be changing ...; Created on 25 September 2009
39. Using MetaMod to hide buttons from logged in users: / Joomla /; ... works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I wanted to make it bit more in-depth for this specific use. I'd love to ...; Created on 22 September 2009
40. Using a HTML form and PHP to upload a file: / Personal Home Page /; The Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The ...; Created on 17 September 2009