Assuming function is required, the following 184 results were found.
-
privileges on the new database (only SELECT on the old database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
dance about but are noteworthy: The only anti-code injection facility in this example is the "mysqli_real_escape_string" function applied to a number. You will need to be more vigilent. Variables are all cleared and redefined. To pass a value to this...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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
-
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: *
-
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
-
key. Remember: This will not work with the numbers at the top of your keyboard unless you are on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
now have the task of finding all the variations of the default values which we found we could do with the built-in SOUNDEX function. How? Lets assume the following, we have a table containing: StudentID StudentDetail Soundex -----------------...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- 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: *
-
are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no rows without erroring (ie. where rownum/rowcount = 0). Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber StartDate --------- ---------------- ----------------------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
WHERE my_id IN ('1', '2', '3') The Solution I must confess that the bulk of this work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
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
-
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: *
-
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: *
-
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
-
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: *
-
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: *
-
is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *