Assuming using is required, the following 332 results were found.
-
link at the bottom of the left menu Click on the “All People” link at the top of the left menu Find yourself in the list by using the iccle arrow next to the 0-100 (top right) Click on your own name or picture to see your profile page Click the “Edit...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml =...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE (...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
you open other similar files in the same environment? Is a colleague experiencing the same issue? Can you access the service using a different workstation? Was the last time you used the service recent? Has anything been installed on your workstation...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
will allow the user to specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given SQL date to the standard...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":";...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what the resulting XML will...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
was using this for a password security-level checker: Source: www.wikipedia.org
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
brilliant Tim Minchin using my favourite book as a response to "the Big Fat Quiz of the Year" show hosted by Jimmy Carr. {youtube}CZ7U3Cu4Mr4{/youtube} https://www.youtube.com/watch?v=CZ7U3Cu4Mr4
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
Using a DJI Phantom FC40 to film a part of Angeles City, Pampanga, Philippines. {youtube}B9afOeBUqpg{/youtube}
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *