Assuming return is required, the following 182 results were found.
-
simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which is all I need in this case. In my example, I need to submit an Active Directory (AD) username and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
If you want to get an element(s) based on limited criteria, you can use the following 3 methods: getElementById(id) - returns a reference to the first object with the specified ID getElementsByName(name) - Returns a collection of objects with the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
RETURN ; ********************************************************************************************************************************************************************** ; MAIN FUNCTIONS ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
API v0.9 version 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert lat/lng to country) rules are...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_OutputRecord); } } // // for testing I'm doing 3 records at a time if(v_CountTotal > 3) { break; } } info m_OutputAll; return ""; This should give you all the fields that will be pulled from "Goals" and some records with data. Create the Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
responses query showing only the last survey attempt per respondent I'm going to modify the analytics query above to only return the latest responses that a respondent has completed; this means that if they have completed the same survey twice, this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
and FTP upload the files uncompressed, or if you have shell access, upload the zip and extract it to the styles folder. Now return to your phpBB3 Administration Control Panel (ACP), which should be located at something like...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
CURLOPT_POST, 1); curl_setopt($ch1, CURLOPT_POSTFIELDS, file_get_contents($file)); curl_setopt($ch1, CURLOPT_RETURNTRANSFER, true); // set authorization header curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: '.$mime_type, 'Content-Length: '....
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample data): And this is what a Data Viewer...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
ComponentMetaData.Name , String.Format(errorMsg1, input.InputColumnCollection[x].Name) , string.Empty , 0 , out pbCancel); return DTSValidationStatus.VS_ISCORRUPT; } // Check whether each usage type is READWRITE if...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query. The stored procedure compiles successfully and without any...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request to the server xhr.send(); // return contents of target file to JS variable var my_csv_file_contents = xhr.responseText; // split contents into array of rows //...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
StringMid,B,HexString,5,2 R = % "0x"R G = % "0x"G B = % "0x"B R+=0 G+=0 B+=0 RGBString = % R Delimiter G Delimiter B Return RGBString } From RGB to Hexadecimal: RGB2HEX(RGBString,Delimiter="") { If Delimiter= Delimiter=,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I -- to be returned as RowID my_field_name ---------...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Keys Const VK_LBUTTON = $01 Const VK_CANCEL = $03 Const VK_BACK = $08 Const VK_TAB = $09 Const VK_CLEAR = $0C Const VK_RETURN = $0D Const VK_SHIFT = $10 Const VK_CONTROL = $11 Const VK_MENU = $12 Const VK_CAPITAL = $14 Const VK_ESCAPE = $1B Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function is to convert a given SQL date or a European date formatted value: FormatDate(val) { ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
processing (or whatever your script is trying to do). Method #2: FileSystemObject ComObjCreate UserFolder:="C:" -- to return file count in a folder ItemCount := ComObjCreate("Shell.Application").NameSpace(UserFolder).Items.Count FileCount :=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
SET "newName=!oldName: (Copy)=!" ECHO Rename !oldName! to !newName! REM RENAME "!oldName!" "!newName!" ) Save the file Return to the command prompt and type rename.bat This will display all the files to be renamed Return to the notepad (rename.bat) and...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB