Search
-
Category: (Joomla! Tutorials)
... to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and ...Created on 07 May 2013 -
Category: (Product Documentation)
... SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges. ip_lookup.php: ...Created on 17 March 2013 -
Category: (MS Integration Services)
... data as a Flat File with fixed columns (Ragged Right). -- "Date" is the last column and can be blank in the source. -- "Date" must default to current date if blank for the target database (cannot be ...Created on 14 March 2013 -
Category: (Microsoft)
What? This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged ...Created on 08 March 2013 -
Category: (Oracle SQL)
Applies 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 ...Created on 04 March 2013 -
Category: (MySQL)
What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...Created on 05 February 2013 -
Category: (MySQL)
... that would replace my HTML tags <PRE> with <PRE CLASS="brush:php">. Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table ...Created on 03 February 2013 -
Category: (SQL)
What? So this is a quick article on how to install 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, ...Created on 01 February 2013 -
Category: (General Joomla!)
Sorry just a quick note for myself on accessing the Joomla database using the Joomla classes. Source: Docs joomla org Basic Query - 1 result $db = JFactory::getDBO(); $query = " SELECT ".$db->nameQuote('field_name')." ...Created on 27 January 2013 -
Category: (MySQL)
What? 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 ...Created on 11 January 2013 -
Category: (Joomla)
... 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 ...Created on 19 December 2012 -
Category: (Transact SQL)
What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...Created on 07 December 2012 -
Category: (Transact SQL)
What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...Created on 05 November 2012 -
Category: (Transact SQL)
What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...Created on 26 October 2012 -
Category: (Transact SQL)
... same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding ...Created on 11 October 2012 -
Category: (Transact SQL)
What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular ...Created on 10 October 2012 -
Category: (SQL)
What? I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone ...Created on 08 October 2012 -
Category: (Oracle SQL)
What? This article describes a function that will return random data based on a given value. The function intends to determine the data type and return data that is absolutely irrelevant to the original ...Created on 22 August 2012 -
Category: (Oracle SQL)
What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...Created on 21 August 2012 -
Category: (General Joomla!)
... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...Created on 17 August 2012