Assuming many is required, the following 63 results were found.
-
To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the Google APIs console (there's so many) when I should be using the App SHA1 (I have now added both to the console). [Optional] To use the keytool: If you know the...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
to: Apple iOS 7 Apple iTunes 11.1.3.8 Microsoft Windows 7 Professional What? Just so many articles out there that did not help me. This article is how I finally did mine. Why? I had paid for some apps on my old phone and realized that if I didn't do a...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first column of the data range...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the "conditional split" task and test one of the columns for a length of greater than 1: Almost! A problem not covered 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Script held in a separate solution which other packages import as a Custom Component Script. (ie. if we use this script in many packages, we can change just this script instead of the ones for every package). Here is the near enough final version of my...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for "NoRowsMessage". This solution hides the entire Tablix which...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
not resetting to blank after the report was run. End-Users were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares against the same parameter....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Workaround #1 Although I'm convinced of a solution considering the ReportServer database will be able to tell you how many milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the report (eg....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant that if in the old...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
can have only one set of allowed values 1 or 2 bytes String Set ('value','value2',...) String object that can have one or many values of a set of allowed values. 1, 2, 3, 4, or 8 bytes Date/Time Date 'YY-MM-DD', 'YYYY-MM-DD', 'YYMMDD' 3 bytes Range...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
database username/password Add the user to the database Create test database with same user Email Setup For you to do: How many email accounts? What will these be primarily used for (restricted on space allocation - usually ~100Mb)? List all email...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
if concept is marketable. Browsable prototype or Vertical slice – normally a few sections of the website are produced with many of the website features in and working, this allows reviewers to get a feel for the site, the level of usability, the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
less than 4 days ago 1 week ago // where event is just over 1 week ago but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I'd recommend anyone who doesn't have a photographic...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
a First-Person-Shooter game where I strafe right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route). Strong Winds:...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *