Assuming from is required, the following 406 results were found.
-
tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the new database. This script will use both databases, reading from the old Joomla database and writing to the new one. To run this script, your user needs SELECT, INSERT and UPDATE...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
MySQL statement will be: `v25_db`.`v25_tablename` -- with the database name and table prefix of database you are READING from (eg. `myuser_joellipmancom_mysitedb`.`lkdjf_content`) `v34_db`.`v34_tablename` -- with the database name and table prefix of...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
of it in new free programs, and that you know you can do these things. To protect your rights, we need to prevent others from denying you these rights or asking you to surrender the rights. Therefore, you have certain responsibilities if you distribute...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, to put them in one place on a website I've bookmarked (my personal site :c)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
// build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles p')); $query->join('INNER', $db->quoteName('#__users', 'u') . ' ON (' . $db->quoteName('u.id') . ' = '...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
"PO Total incl Tax", po."Reference number" AS "PO Custom Ref", po."Sales order ID" AS "SO ID", soi."Item ID" AS "SO Item ID" FROM "Purchase Order Items" poi LEFT JOIN "Purchase Orders" po ON po."Purchase Order ID" = poi."Purchase Order ID" LEFT OUTER...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
the button labeled "Choose Image": I'll select "My Library" and click on the square with a plus sign on it to select images from my device: Now I can select the image(s) I want to upload (unfortunately only 1 at a time): Create an Image Table At this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
by sending money to a friend or relative via these services and show them the receipt. All they need is the tracking number from your receipt and they’ll be able to collect your money. Any requests by strangers to use these services in any way should...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
SET @specifiedDate = (SELECT @GivenDate) SET @specifiedCampus = (SELECT @GivenCampus) -- Get columns SetId and WeekNumber from the weekstructure table based on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE StartDate BETWEEN...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream of mine (see my pinterest) to build a nicer looking computer and I...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have a client who uses their purchase orders and sales orders as part of a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html
JoelLipman.com or send e-mails to us, you are communicating with us electronically. You consent to receive communications from us electronically. We will communicate with you by e-mail or by posting notices on this site. You agree that all agreements,...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
$user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY CONCAT(u.FirstName, ' ', u.LastName) "; Activity...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB