Assuming function is required, the following 178 results were found.
-
BY calendar.weekNumber For those of you who are familiar with this, I am simply using an alternative to the DATE_FORMAT() function in mySQL. Should yield: AcademicWeek Mon Tue Wed Thu Fri CalendarWeek -------------- ----------- ----------- -----------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Description: Stored Procedure to scramble Data in a column of a table. ** ** The process will mix the Data using a random function. ** ** Once the Data has been scrambled it won't be possible to get the original set of Data. ** ** ** ** Usage Examples:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string. Why? Because my understanding with regular expressions is shady and varies from language to language, I've written this...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
be error messages posted before this with more information about the failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
is allocated a given IP address, this is what I use. The scripts in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download»...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor: Soundex: Built-in function to list matches that sound like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Version: 1.0.47.06 ; Language: English ; Platform: Win9x/XP ; Author: Joel Lipman ; Date Created: 15-July-2014 ; ; Script Function: ; Just a countdown for my last days at BU. ; ;...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
instructed: Change the Java file to open on your current location, find the MapsActivity.java file and open it: Change the function setUpMap() to the following code private void setUpMap() { mMap.addMarker(new MarkerOptions().position(new LatLng(0,...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java (readFeed) and replace with private List readFeed(XmlPullParser parser) throws...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
v, int actionId, KeyEvent event) { boolean handled = false; if (actionId == EditorInfo.IME_ACTION_GO) { openMap(v); // do function on pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases,...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
will only document the process of sending data under the server IP address. We're going to use a PHP script with the cURL function to receive and send the data. cURL is a standard feature on most LAMP setups. If not you can install it from here:...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays a google map in a module using the Google Maps API v3 styling features which includes Points of Interest...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
3.1 AdrianaV/Vincent- Enhancement: Does not display more images then are available. - Enhancement: Auto-Check for cURL functions enabled on server. - Fixed Bug: cURL_Init uses encoded weblink URL in case of spaces. - Fixed Bug: Auto-Update via Joomla...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
; https://autohotkey.com/board/topic/67917-get-folder-size/ ; function to loop through files/subfolders and total the file sizes GetFileFolderSize(fPath="") { FolderSize := 0 if InStr(FileExist(fPath), "D") { Loop, %fPath%\*.*, 1, 1 FolderSize +=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this is response = zoho.creator.updateRecord( ownerName, appLinkName, formLinkName, id,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
changed into a string of only letters, numbers and underscores. Note that the PHP doesn't need a database connection here: function getUrlAlias($p_Name){ // lowercase and trim preceding/trailing spaces $v_Output = strtolower(trim($p_Name)); // replace...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and programmatically....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the invoice line items with their respective sales order item id value. For our client's purpose, we are running a custom function off the invoice module which: creates a sales order checks the returning sales order line items cycles through the invoice...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Send mail attachment: creator file upload field value as attached file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
h%Height% x10 y10 Return ; -------------------------------------------------------------------------------------- ; Function: CountExistingInColumn2: Find in list view occurrences of new names column CountExistingInColumn2( v_Filename ) {...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF