Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) Month, SUM(IF(t1.VisitorBrowser='MSIE', 1, 0)) 'IE',...

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 it what date it is on 2012-07-10 and it doesn't have a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have...

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

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

28 June 2011 stopped providing, or just because it's easier for me. This program can be downloaded by visiting www.joellipman.com and selecting "Features", then "Downloads", then "Standalone programs" (or click here). There is no charge, you just need your own...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 should only enable thumbnail refreshes at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher...

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

Basic Oracle Function Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 OR REPLACE FUNCTION fn_get_sref_from_adname (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId...

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

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 of red tape and bureaucracy. This is an article to describe an alternative method then "right-clicking on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to...

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

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 program Open SQL Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you downloaded earlier Create a new database connection (or click on the plus sign in the connections tab), select the...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some...

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

SSIS Multiple Lookups in onehttps://www.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 query which returns all the joined tables and displays the decode name. Let's pretend the info we want is rather simple: SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], [student_country_birth_code],...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 I'll give the run through using the country of domicile with the pipe delimiter as the example: &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ("»") next to...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 I've written this article. Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the Android OS: Add an activity to Mobile: select Google Maps Activity:...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label (desktop / start menu) Select Properties Click on Change settings or Advanced system settings Select the Advanced tab Click on the Environment...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 user. For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 Attached Files in CRM Setup a workflow that when SO Ref changes, the tick box is unticked Form Workflows > New Workflow Select your form Run when Created or Edited When to trigger: User input of a field Choose Field: ZohoBooks Sales Order Ref Name it...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 mapping, it needs the CRM Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules" Enable "Invoices" (by ticking the box and clicking on "Save") Hover the...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 (Original) I want to run some deluge (snippets below) every time the form loads, so I Go to Workflows > Form Workflows > Select your form Click on New Workflow Choose form (the one your radio tabs group exists on) (Record Event) Run when a record is...

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

ZohoCRM: Template: not being able to edit a text boxhttps://www.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 customer who's boss). Now click on the pencil icon of the cloned template Right-click on the text box causing the issue and select "Inspect" (if you don't have this see alternative steps below on "Inspect page Elements in Chrome"). In the Developer...

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

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 other products with the same name (set in order of oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit " + v_PerPage};...

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