Assuming database is required, the following 112 results were found.
-
can then be up to you. To use the following script, you need to change the my_wordpress_db to the name of your wordpress database and change my_joomla_db to the name of your joomla database. Note that your database user should have access to both...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
seconds was just confusing the end-user... 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Restructured extension into an MVC model (fixes H3 and Module Class Suffix issues) - Removed Joomla! Admin Option: Content Database Length - Date Uploaded: Mon, 13th Jun 2011 1.6.3- Core script reverted to v1.5.2 - Styled Joomla! Admin Options into...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I wrote that produces a GUI that takes an external file where column A contains the key/ID of the Contact in the 3rd-party database and column B contains the filename as downloaded from the 3rd-party database. And an internal file where column A is the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
their templates compatible with phpBB. phpBB3 installs similarly to Joomla CMS. As a personal preference, I set up a new database and a new mysql database user which will be used to store the phpBB3 system. For installation purposes, this mysql user has...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
need to remove these and restore your website. I'd suggest joomlapack if you're using a joomla site, backup just the database, do a fresh install of joomla and use the database sql file as the migration script. There are some more details of prevous CB...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
THE BELOW: this works for me and the timetabling system I have, you need to adjust how you get the values from your events database). First get the events from your database and then get the rooms: ), Events AS ( --Create some events to place on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
tools and instead have built a back-end Joomla! administration component that only works in MS Internet Explorer; any database hacks or FTP file uploads immediately corrupt this component. The component itself is sort of good, but file description has...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
skills do. My Setup Windows XP Workstation...needs to open... Excel 2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
you ask, we have several MS Sharepoint sites but we didn't go down the route of uploading 10000+ images into a Sharepoint database though we are still considering it; so this article is more about just getting external images to display when they are...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator rows so ideally we would like: Day ---------------- Monday Monday Monday Tuesday Tuesday...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- 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: *
-
the mySQL add-on for Oracle SQL Developer v3.0.04. Why? I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and then the supplier will implement restrictions...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
you've lost the Joomla CMS and you'll need to restore them from a backup. NOTE: Only restore the files! The images and database were unaffected in our case and could be left as they were. Our last file backup was over a year old but we only needed the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF