Assuming each is required, the following 208 results were found.
work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static object and set FixedData to False (ensure all items are set to false or it will error): Save and test on the...
reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each character, -- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS...
(column headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before the carriage return otherwise the column...
Monitoring the monitors Some useful tools: Stu-Talk Monitor Details (SMD): The SITS application audit giving details on each process. Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters. Stu-Talk Monitor Summary (STMS): Specify...
go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include the imported classes near the beginning, so TEST it! Addtional: Problems animating the camera...
with a camera). Regulations different to the UK and US are still being reviewed prior to being added to the database but each country's aviation authority has been added. Earthquake Feed for the past day:...
both to the console). [Optional] To use the keytool: If you know the command prompt, you know that you have to refer to each tool using their full path unless you add it to the PATH environment variable: This allows you to use keytool from any folder:...
// will work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1,...
area I have added the hidden fields in the HTML form (generated in PHP) in the following file: mod_joesearch.php. Simply add each component name separated by a comma (eg. "doc_indexer, weblinks"): // add doc_indexer to search // search weblinks as well...
component: JComments: This will be a copy of two systems running JComments version 3.x The MySQL scripts will copy over each table in turn Configure and Brand your new Joomla site Activate Users Post-Notes: Activating users should be done as the last...
Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English Ordinal...
hourList = hourString.toList("/"); v_includeInPicklist = false; for each index timeSlot in hourList { timeSlotStr = timeSlot.toString(); if(timeSlotStr.length() zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b...
Google Drive REST API v3 Google OAuth 2.0 v4 Google Cloud Platform IAM Google Suite PHP v5.6.35 How? I'm going to go through each section of the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in...
Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added...
DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1;...
to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the following is free...
l_ProductItems = List(); r_InvoiceDetails = Map(); r_InvoiceDetails = zoho.crm.getRecordById("Invoices",p_InvoiceID); for each r_ProductLineItem in r_InvoiceDetails.get("Product_Details") { m_NewProduct = Map(); m_NewProduct = r_ProductLineItem;...
note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection:...
used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table...
options, change any comma to , then in your CRM code to create the record in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in r_DealDetails.get("My_MultiPicklist") { v_PicklistOption = r_PicklistOption.trim().replaceAll(",",...