Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 mechanism so you would have to refer to the output without this column before modifying the query to include the page names of your survey. GENERAL was the first page asking for lead/contact name when I have this prepopulated from a ZohoCRM integration....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Converting SQL date in PHP to European date format and vice-versahttp://mail.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your setup. Converts 2001-06-25 09:41:00 to 25/06/2001 09:41:00 And Vice-Versa:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Registration Services (for .co.uk, org.uk, .net.uk, etc): http://www.123-reg.co.uk/ http://www.oneandone.co.uk/ http://www.names.co.uk/ http://www.ukreg.com/ International Domain Registration Services (for .com, .net, .org, etc) - Note you can use the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Create Read-Only Database User in SQL Serverhttp://mail.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx db_accessadmin Members of the db_accessadmin fixed...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Merge the content of two similar tables in MySQLhttp://mail.joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 site and its design is property of SomeoneElse.com Obviously the two above tables are very similar with different column names. I also don't want the data to produce double the number of columns. My Solution SELECT title, intro FROM ( SELECT `title`,...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 long as the page loads in a browser of yours (it will look at it like MS Windows Internet Explorer) it should be ok. Output names for the thumbnails follow the same restrictions as the MS Windows filesystem (so no colons, back/forward slashes, etc). If...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Win32 Constantshttp://mail.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = 1 ;// displayed under a folder (relative) Const SHGDN_INCLUDE_NONFILESYS = $2000 ;// If Not set display names For shell name space items that are Not in the file system will fail. Const SHGDN_FORADDRESSBARConst = $4000 ;// For displaying in the...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 and select "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter"...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Joes Network Transmission Detector (JTD)http://mail.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 background: In Development Read data packets without causing network traffic (tried tcpdump, pcap) IP and resolved host names on double-click without causing network traffic (tried netstat. NTS: try this again with dll calling) Program used to open port...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 16/10/2011 A009 08:00 17:00 Separator Marker */ As I mentioned at the beginning of this article, I am comparing on Day names. The above query generates a last column which is either empty or says "Separator Marker". Based on the CTE above, I now need to...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note:...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Search a database for a value and count matching rowshttp://mail.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 my laziness (replace [myDB1] with name of database 1 and [myDB2] with name of database 2): -- Joins on table and column names, lists diffences if any SELECT t1.TABLE_CATALOG AS [DB1_Name], t2.TABLE_CATALOG AS [DB2_Name], CASE WHEN t1.TABLE_NAME IS NULL...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 adjust, suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will configure my server to receive requests for those domains (along with webspace and emails). Please wait up to 3...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

T-SQL: Parse an XML valuehttp://mail.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Include a carriage return in a column headinghttp://mail.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using carriage return in column names New line Character in column alias

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Excel: convert degrees minutes seconds to decimalhttp://mail.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert foreign characters to English alphabethttp://mail.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the names of places in other countries. This is nice but its search engine doesn't work properly as it thinks "riviere" is different...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)http://mail.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 client library) and is a function sending two requests, the second is the appropriate multipart function which uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1....

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Autohotkey - Chrome Profiles in Alphabetical Orderhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 := A_LoopFileLongPath "\Preferences" ; Get the preferences file from the profile FileRead, OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB