One of the tricky issues in entity relationship model is the recursive relationships. Sometimes an entity needs to refer to itself. For example, think of an organisational chart for the roles of employees in a company; each employee is managed by a manager, each manager manages 0 or more employees. The records of all the … Read moreRecursive Relationships in Databases
I had an opportunity to work on a Magento implementation and checked its database. I had heard about its adaptability to almost any online e-commerce business in almost any country. So, I had a chance to see how it is achieved on the database level. For example, when we want a system which is adaptable … Read moreAdaptable Database Design
XAMPP is just another package of: Apache HTTP Server, MySQL, PHP + PEAR + Zend Framework, phpMyAdmin, Perl, FileZilla FTP Server, Mercury Mail Server, OpenSSL, Webalizer, etc. like WAMP, EasyPHP (the first of its kind I’ve known), and others: http://en.wikipedia.org/wiki/Comparison_of_WAMPs XAMPP 1.7.3 includes: — Apache 2.2.14 (released in October 2009) and PHP 5.3.1 (released in … Read moreTo upgrade or not to upgrade XAMPP 1.7.3
Just an idea, possibly not a new one, and I promise, it is not another “framework”: Is it worth to create a class library as a DLL for a business model and use that DLL in PHP? What are the advantages and disadvantages? As soon as we say DLL, it is a solution that can … Read moreClass Library as DLL for Business Model to be used in PHP
Recently, I have struggled to get Oracle Text working on Linux. It was supposed to be a simple addon based on a very simple idea: + already installed Apache 2.2, PHP 5.3, Firebird 2.0; which are working fine + install Oracle 10g Express Edition + create a simple table to store candidate ID and document … Read moreCreating a CV indexing facility using Oracle Text
Go to your Oracle binaries folder and export environment variables, if they are not set already. Then, run SQL*Plus command line utility with option /nolog .
[root@localhost /]# cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/
[root@localhost bin]#. ./oracle_env.sh
[root@localhost bin]# sqlplus /nolog
SQL> connect myuser/mypassword@localhost/xe
SQL> select count(*) as c from mytablespace.mytable
I hope this helps some beginners.
Before continuing the rest of the installation process we started (/wp/index.php/2009/07/setting-up-a-web-application-on-centos-5-3/), I must mention my appreciation for the “yummy” tool Linux developers provided: yum (.. an automatic updater and package installer/remover for rpm systems). I love using webmin (.. a web-based interface for system administration for Unix) as well. The other day I only clicked … Read moreSetting up a web application on CentOS (continued)
Another CMS and e-commerce project from Creativezones and Argeus is FindFashions.co.uk. You can get further 10% discount if you register ASAP! Clothes from famous designers and brands are on SALE!
On MS Access applications, usually I use subreport objects with SQL queries of their own, linked to the main report which includes the subreport. Classic example of such master-detail reports is invoices: + master (main report) section includes invoice date, invoice number and details of the customer account such as name and address lines. + … Read moreShow MS Access Subreports With No Data