Assuming another is required, the following 149 results were found.
-
against this database because it involves linking a lot of tables and outputting... just articles and their titles. I have another table holding the audit trail of content approvers on the system. Approvers can e-sign an article (approving it) by...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
article for Joomla CMS version 3.x on resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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
-
Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert,...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Typing an ASCII character In DOS: Hold down the key while typing the decimal number on the keyboard keypad. (Example: 178) In Windows for a DOS character: Hold down while typing the decimal on the keyboard keypad. (Example: 230) In Windows for a WIN...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
What? Quick article here as googling/binging for how to refer to Joomla articles after versions 1.5.x wasn't obvious. This article is to demonstrate how to write the webaddress for a Joomla article even when you have Search-engine-friendly website...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in implementing multiple desktops. So if you have a Mac or Linux system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
these services in any way should sound off alarm bells and shouldn’t be followed. An email allegedly from «CompanyName» (or another company) asking for your personal details - logins/passwords/credit card details. You get an email that claims to be from...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth --------- ------------ ----------- 1 Fred Bloggs 1964-02-18 2 Another User...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
with regards to functionality and record editing when compared to API v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) FROM...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
compatibility and disabled access) Explain balance of scope, quality, time and cost. (focusing on one element means less on another) Search Engine Optimization constraints and standards Domain Registration This is so that you as the client retain...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
How? Here's one method I used based on the services available to my client: Copy all files of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main site to another...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
and data but without using a for loop. What I have: {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} What I want: First NameLast NameID JoelLipman1 AnotherPerson2 How? This is a bit of a dirty...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ADDRESS ------------------- ------------------- Test Company Joels PO Box 1 Test Street 1 Different Street Test City Another City Test State Test Zip Another State Another PostCode Test Country A different Country But the packing slip would display the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and should be about 3.57Mb). I have tried other rescue programs which caused even more errors (had to return the pen for another and another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
and add a new set, it will put these dates in automatically. Herein lies the problem The reason I'm doing this is for another system which decided to "cleverly" use the exports from CMIS Facility so that all the weeks correspond to the rest of the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
some developers never check the errors log? By the time, I started maintaining the project, a revamp had been agreed with another web team. This has been delayed somewhat and still after 2 years there is no new site (blamed on the customer for not...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *