Assuming than is required, the following 169 results were found.
-
which isn't included in the examples above because the function was only going to be applied to names and titles rather than addresses, but here it is anyway, add this after the "loop through exception cases" while clause: -- Now for some UK (British)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
first to return the ID of the student, and then to use this number in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
How? So there are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in,...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
with 1&1 (oneandone.co.uk) and I would strongly urge Joomla developers to avoid them like the plague. They have been less than helpful and when I only had one Joomla site with them, they still would block me thinking I was trying to hack into their...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from -128 to 127 1 byte...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
local report within BIDS connecting to remote servers. If you want the report to be viewable on a specified Reporting Server than you'll need to deploy the report. If you get the following error (like I did) when you view the deployed report on the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will NOT be adding these rows to... SET @count:=0; SELECT '2012/2013' AS SetID,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is less than the "From date" then add 1 day to the date: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession']));...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
for a number of occurrences within a specified range. For example, to find where 'a' occurs at least 3 times and no more than 5 times, you use the following regular expression: a{3,5} This expression matches all of the following sequences: aaa aaaa...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?). Why? We have a row on a website of three boxes made of div layers. When viewed normally on a 15" Laptop, all was good using...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
and vertically in a screen/viewport in pure CSS (no JavaScript allowed). This CSS centers it by its center point rather than the top/bottom/left/right outline. Why? On a mobile, a client's site uses an external page embedded by iframe. When the app...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
name of the field, its entity and dictionary. My example below will use the Decision/date and Response/date fields (rather than the CAP_IDRC). This demo will use the key fields from the Course Application (CAP) entity/table. Create the XML Exchange...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Add the xmlns:xsi namespace in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
Force no underlines on words. - Date Uploaded: Thu, 11th Nov 2010 1.2.3 - Fixed bug: counts international characters rather than bytes. - Fixed bug: renamed functions so as not to conflict with any pre-existing ones (eg. utf8_strlen) - Date Uploaded:...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more than 5 invoices in a scheduled task because Xero only allows 5 concurrent connections at one time... And Zoho was trying to send...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
the report to Excel and on extra blank columns will appear in the worksheet. NOTE: Fields formatted so they are much wider than the actual size of the data can cause blank columns. Make sure the field width is just wide enough to display the longest...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
lines) if(column_values[0] != ''){ // remove any/all double-quotes in this column value // found this method more reliable than using regex removed_quotes = column_values[1].split('"').join(''); // populate my array with an object obj_temp.push({...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB