Assuming else is required, the following 121 results were found.
-
connection:"my_workdrive_connection" ]; info "Workdrive Member Added: " + v_RecipientEmail; } } info r_WorkdriveFolder; } else { v_WorkdriveFolderID = m_SubfolderNames.get(v_WorkingFolderName); } // ====================== // upload the file to this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Workdrive
- Language: *
-
" + input.Hexadecimal + ";}"; v_CssStyle = v_CssStyle + ""; input.Note_ColorPicker_Css = v_CssStyle; } else if(!isNull(input.Color_Picker) && input.Color_Picker.contains("button")) { // // inject some CSS v_CssStyle_Popup = ""; v_CssStyle_Popup =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } else { // add here line items to delete / remove / omit m_NewLineItem = Map(); m_NewLineItem.put("id",m_LineItem.get("id"));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ ZDK.UI.getElementByID("Tab_SalesPipeline").setVisibility(true); ZDK.UI.getElementByID("Tab_SalesPipeline").setActive(); } else if (v_DealPipeline == "Hire Pipeline") { ZDK.UI.getElementByID("Tab_HirePipeline").setVisibility(true);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on Next have a quick glance of the preview and then click on Next First row contains column names = Yes, leave everything else as plain text except for Description which you should change to a Multi Line Text. Click on Create. You should end up with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
{ if(!isNull(m_JobData.get("Total Score"))) { v_SurveyTotalScore = m_JobData.get("Total Score").toLong(); } } break; } } } else { return "ERROR: Could not export analytics chart for email: " + v_ContactEmail + ". Please check that the contact has...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
invoice line items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
after you submit it, or if you wanted to change the default text that is displayed "Thank you for your e-mail" to something else I will explain how in this guide. I cannot be 100% sure this guide will work for people who have certain extensions...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
checked_out_time, editor ) SELECT id, 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,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status', 'open' comment_status, 'open' ping_status, '' post_password, alias 'post_name', '' to_ping, ''...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
' ' AS 'user_url', a.registerDate AS 'user_registered', ' ' AS 'user_activation_key', CASE a.block WHEN 0 THEN 2 ELSE 0 END AS 'user_status', -- NOTE THAT THIS IS DEPRECATED IN WORDPRESS 3.X a.name AS 'display_name' FROM my_joomla_db.jos_users a ORDER...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
read line ; do match=$(echo "${line}" | egrep -o 'run-parts (-{1,2}\S+ )*\S+') if [[ -z "${match}" ]] ; then echo "${line}" else cron_fields=$(echo "${line}" | cut -f1-6 -d' ') cron_job_dir=$(echo "${match}" | awk '{print $NF}') if [[ -d...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
= (ImageView) findViewById(R.id.hangar_aircraft_photo); myPhotoImage.setImageBitmap(imageBitmap); // if choosing } else if (requestCode == RESULT_LOAD_IMAGE && resultCode == RESULT_OK && null != data && TAKE_OR_PICK == 2) { Uri selectedImage =...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
is Microsoft.SqlServer.Dts.Pipeline.ColumnIsNullException || e.GetBaseException() is System.NullReferenceException) { } else throw new Exception(e.ToString()); } } } } Allowing me to simply tick columns to apply this to (note that some of the images...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
hour of the day SET @EndTime = @GivenDate + ' 17:30:00'; --First time of the day (required to display empty rooms) END ELSE BEGIN --First hour of the day SET @StartTime = @GivenDate + ' 00:00:00'; --Last hour of the day SET @EndTime = @GivenDate + '...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
them to load) to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the textbox basically (execution time is kinda irrelevant when you get 0 matches) We...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, Parameter Value = [@StudentReference] - NOTE THE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
xp machine so if the error happens again, I'll try fixing it on my windows 7 setup and update this article. I found someone else on the Internet who doesn’t use the “remove device safely” blab and he got the same error. He (unless Andy is a girls name)...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
as this was not my idea but quite ingenious and worth a mention. Did anyone else have any problems with Aero effects when they first installed Windows 7? What’s your favourite Aero feature or do you even use them? Let us know by leaving a comment.
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT ' union all ' + @SqlToExecute; SET @myCounter = @myCounter + 1; FETCH NEXT FROM Cursor1 INTO @SqlToExecute END CLOSE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB