Search - Joel Lipman .Com

1. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let ...; Created on 02 September 2019
2. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
3. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... [1.7.0] Map: tap the "located" infotip to scan current - [1.7.0] Map: tap and Hold anywhere on the map to scan - [1.7.0] Map: offline redirects to help page - [1.7.0] Map: interface layout over map - ...; Created on 24 October 2014
4. Basic Android App using Google Maps and Current Location: / AndroidOS /; ... yourself located")); } If you are prompted to import the classes then agree by clicking OK: If you are not prompted, you should see some of your code go red like in the following screenshot ...; Created on 10 October 2014
5. Include a carriage return in a column heading: / SQL Server /; ... It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located ...; Created on 07 July 2014
6. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
7. Client Services: Website Development Agreement: / Static Items /; ... can step in when necessary but they will not necessarily match my skillset. My associates only get involved when something goes unexpectedly wrong and I do not have the extra time to allocate. They will ...; Created on 15 November 2013
8. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... buffer it loops through each of the input columns passed into the component // It locates the actual column value (including checking for null) using the index array created in the Pre-Execute ...; Created on 04 October 2013
9. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... is a marker for a value located after Needle1a Needle2a := "" ; Needle2a is the closing marker ; get table HTML Needle1 := InStr( Haystack, ...; Created on 30 March 2013
10. Country Lookup by IP address CSV: / MySQL /; ... allocated country. Our use here was to create a refreshable country by IP address list that we can use when parsing our website logs to check where visitors were from. Note: we also use and love ...; Created on 17 March 2013
11. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... all dialogs to close and save. Additional The affecting TNSNAMES.ORA file for the above setup is located in "C:\app\\product\11.2.0\client_1\Network\Admin". I also checked that the data therein ...; Created on 04 March 2013
12. Quickly update all content in mySQL database replacing a string: / MySQL /; ... find all the articles that need this change: SET @stringtoFind=''; SET @stringtoReplaceWith=''; SELECT `id` , `title` , IF(LOCATE( @stringtoFind, REPLACE(`content_column`, ...; Created on 03 February 2013
13. Cheat Sheet for mySQL vs t-SQL: / Databases /; ... T-SQL Strings String Replace REPLACE(haystack,needle,replacement) REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, ...; Created on 31 January 2013
14. DataTumble - Randomize Data Rows: / Transact-SQL /; ... @UpdateCursor INTO @Data END CLOSE @UpdateCursor DEALLOCATE @UpdateCursor COMMIT TRANSACTION A --print 'committed' END TRY BEGIN CATCH ROLLBACK TRANSACTION A ...; Created on 07 December 2012
15. 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
16. Search a database for a value and count matching rows: / Databases /; ... FETCH NEXT FROM Cursor1 INTO @TableToProcess END CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SELECT * FROM #CountRecordsPerTablePerCol; END ...; Created on 05 November 2012
17. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... CLOSE Cursor1; DEALLOCATE Cursor1; -- Generate final query and execute it SET @SqlToExecute = ' SELECT DISTINCT myValue COLLATE ...; Created on 26 October 2012
18. Search a database with SOUNDEX: / Databases /; ... SET @myCounter = @myCounter + 1; FETCH NEXT FROM Cursor1 INTO @SqlToExecute END CLOSE Cursor1; DEALLOCATE Cursor1; PRINT ' ) AS t1 GROUP BY column_value ...; Created on 11 October 2012
19. Search a database for a string (MySQL, T-SQL): / Databases /; ... FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor T-SQL Source: http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 ...; Created on 08 October 2012
20. Migrate JComments from Joomla 1.5.x to Joomla 2.5.x: / Joomla /; ... parent, CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id, path, level, object_id, object_group, ...; Created on 07 June 2012