Search - Joel Lipman .Com

21. Protecting your Joomla Administrator Section: / Joomla /; ... me on Joomla websites in general and prevents the administrator URL showing up at all in the stats (unless you were using it). Leaving this unchecked means that the crackers/hackers will get through ...; Created on 23 October 2015
22. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
23. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... type (default is PNG) (eg. PNG to JPG -> means module has to re-download thumbnails into JPG format) - Fixed Bug: Weblink hit counter now works through Joomla! CMS- Date Uploaded: Wed, 13th Jul 2011 ...; Created on 07 September 2015
24. List of Font Awesome: / Web-Development /; ...  fa-meanpath [] 4.3  fa-medium []  fa-medkit [] ...; Created on 04 September 2015
25. Android OS: Add GoogleMap as fragment: / AndroidOS /; ... The previous article meant that the Google map was your main activity and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item, it would need ...; Created on 25 November 2014
26. Android: Replace return key with done, go, send...: / AndroidOS /; ... IME_ACTION_DONE // the action key performs a "done" operation, typically meaning there is nothing more to input and the IME will be closed. IME_ACTION_GO // the action key performs ...; Created on 03 November 2014
27. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... equipment by virtual means. Tap on any equipment, photo or detail to change it. I have pre-loaded it with my own Quadcopter's details but feel free to change them to match your configuration. Tap ...; Created on 24 October 2014
28. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgrade: / Quadcopters /; ... legs, the tall ones mean my phantom won't fit in my backpack Need a small philips screwdriver here Noting damage from previous landings Marking direction So not recommended but leftover ...; Created on 04 September 2014
29. DJI Phantom FC40 - First Flight: / Quadcopters /; So I just started another YouTube channel which I'll try to transfer my Joomla videos over to but in the meantime you can be subjected to my quadcopter videos. Here are a few quick ones, the Hubsan H107C ...; Created on 28 August 2014
30. SSIS Multiple Lookups in one: / SQL Server Integration Services /; ... convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could ...; Created on 05 August 2014
31. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... this means the full path is used as just putting the file name did not work). Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 ...; Created on 13 June 2014
32. Excel: Find values in one column that are not in another: / Excel /; ... in B2 down all the list as per the following screenshot. A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the formula ...; Created on 06 March 2014
33. Joomla Component: Set default params on installation: / Joomla /; ... } } Additional: ACL during install My component is editable by registered users only. This meant that everytime someone installs the component, they would usually need to go into ...; Created on 24 October 2013
34. Split a row into multiple rows based on a column value: / Transact-SQL /; ... day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system. What we have: SELECT ...; Created on 23 August 2013
35. Leap Motion and AR Drone: / Quadcopters /; Leap Motion is a USB gesture control device you can connect to a computer which behaves much like a mouse or trackpad but in 3 dimensions. Available July 2013 for public release (you can pre-order if ...; Created on 17 May 2013
36. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... 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 ...; Created on 14 May 2013
37. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables, the Needlemarker tells the function ...; Created on 30 March 2013
38. SSIS Convert a string into a date: / SQL Server Integration Services /; ... error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there ...; Created on 14 March 2013
39. Preg_Replace all strings between two tags: / Personal Home Page /; ... shady and varies from language to language, I've written this article as a quick reference point. How? Well you use this in your PHP scripts, the examples below are meant to help but feel free to ...; Created on 07 February 2013
40. 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