Search - Joel Lipman .Com

21. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
22. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP ...; Created on 24 September 2015
23. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015
24. Excel: convert degrees minutes seconds to decimal: / Excel /; ... 39°48′40″N 116°42′30″E 39 48 40 N 116 42 30 E 39.81111111 116.708333333 39.81111111 116.7083333 Note that negative numbers should be supported. ...; Created on 06 November 2014
25. Android: Replace return key with done, go, send...: / AndroidOS /; ... Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect textEmailAddress ...; Created on 03 November 2014
26. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... to change the details (lots of numbers!). Tap on Quick Reference image to change image. (if you have a different led, you can take a picture or use a screenshot Tap on the "Save" icon to save all changes ...; Created on 24 October 2014
27. Joomla Development: Possible XML Filters: / Joomla /; ... the value to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters ...; Created on 17 October 2013
28. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing ...; Created on 23 April 2013
29. DataScramble - Randomizing data rows: / Transact-SQL /; ... 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', ...; Created on 07 December 2012
30. Generate Academic Calendar using MySQL: / MySQL /; What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article ...; Created on 27 November 2012
31. Vertically align an asterisk on a line: / Cascading Stylesheets /; What? So I have an unordered list of values (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the ...; Created on 02 September 2012
32. 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
33. Copy a table with structure and data into a temporary table: / Transact-SQL /; Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...; Created on 03 August 2012
34. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again ...; Created on 01 August 2012
35. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
36. SSRS Zero Padding: / SQL Server Reporting Services /; ... & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just get rounded up without the prefixing ...; Created on 10 November 2011
37. MySQL last year week month day trend periods: / MySQL /; ... since becoming an analyst, I do more at the database level now. What follows should be usable mySQL statements to get all the numbers: Yesterdays -- CURRENT: count todays SELECT COUNT(id) FROM ...; Created on 31 October 2011
38. The ReportServer Database: / Databases /; ... aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME) CAST(CONVERT(CHAR, ...; Created on 08 August 2011
39. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered ...; Created on 03 August 2011
40. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... before and after any text. If you haven't specified a name, then it just reverts to using 6 digit numbers. Question Something has happened to my images folder, does it matter? Answer: No, the program ...; Created on 28 June 2011