Assuming those is required, the following 64 results were found.
-
if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun). The Apple documentation iOS: Transferring information from your...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a bit over the top for something that should be so simple. Hey presto, I...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
to see ALL connected processes as well. Why? For every DBA this is a doddle and doesn't warrant its own article but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of systems and not as an invite for suggestions on how my business should be run. How? So...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Note how I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL (think it's optional for most SQL forms). I found that to add...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER 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:...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Developers will have told the system what to do when newline, carriage returns and tab characters are entered in the data. Those who are security-conscious will also make their system escape apostrophes (') and double-quotes ("). But who can honestly...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
all marketing, promotional material (can include fonts, images, word documents, etc) We can accept most formats except for those exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: Assess allocated server space -...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
midnight into the next day... But what system doesn't do this (no Microsoft jokes 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...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
passwords) Level of Security Testing (XSS and SQL-Injection at least?) Referenced common files / global assets (especially those used in every page) Expert/Testing/Resistant users (contact details and informally their technical knowledge/skills)...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- 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: *
-
full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days ago 1 week ago // where event is just...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
within the containing element in an instance document keyref Specifies that an attribute or element value correspond to those of the specified key or unique element list Defines a simple type element as a list of values notation Describes the format of...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
change when you copy the formula to other parts of the spreadsheet (ie. not relative). Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
I reckon they should make drones that go right a tipped over car or bring it back to the track... Then again, couldn't those cars self-right themselves? Ok. back to work.
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *