Databases
Pagination in Zend Framework 1.12
One day, when I was creating application in Zend I came accross problem with display a lot of records from database. All the ... and so on. Some of them You send to the view.
You may change either index.phtml view file. Paste its code for it:
Trees
Database application in Zend Framework 1.12.3 in Netbeans 7.4 get data from several relational tables.
In last post You create Zend project: magazine. Lets open in Your project application.ini file( application/configs folder). ... s action index controller. It’s name is authors.
In layout.phtml file add code with links for authors and articles websites.
Connection to MySQL database from Zend framework 1.12.3 in Netbeans
First create in MySQL server country_db database with only one table country. I do it by means of phpMyAdmin.
You write in e ... try
continent
Here You run Your project.
How create MySQL database contains 2 relational tables in phpMyAdmin?
First create in MySQL server database with animals name. We do it in phpMyAdmin.
Click on Databases tab in phpMyAdmin.
In Cr ... constraint name as fk_animal_classes and select cascade for on delete and for update. Save settings clicking on Save button.
In Zend Framework 1.12 Application error: No adapter found for Application Model DbTable
I met last time situation in that I run my application with error: No adapter found for Application_Model_DbTable. What’s wr ... tion.ini file and paste it before [staging : production] section:
Running application You see list of animals from database.
CRUD Zend Framework application in Netbeans.
If You would like to create CRUD application first You must create database with
tables. CRUD means: create read update dele ... urces.router.routes.create.defaultAction = "createform"
And in index view add on the end of file link for adding new animal:
JNDI DataSource SQL Server used in Web Application created in Netbeans and GlassFish server
In this post I describe you how configuring JEE application to connect to SQL Server database through DataSource. In my last ...
People
It is new content index.jsp file:
Run application.
How use uniqueidentifier datatype in SQL Server?
This post describe what is uniqueidentifier and how use it?
The uniqueidentifier is datatype in SQL Server. It stored hexade ... into ident12(name) values('Brazil');
The error don’t display so You may try value for this record.
select * from ident12;
Create the Data Source in the Report Builder
Let’s start to run Report Builder in Start on Windows OS.
You see Report Builder window. Close Getting Started window,
Rig ... Connection Result window and then in main window.
On the left side in the Report Builder window you see your Data Source.
How install DBDesigner on Windows OS?
Go to http://fabforce.eu/dbdesigner4/ download open source tool for modelling and design databases. Download DBDesigner4.0. ... n to start installation process.
Click the Finish button to end this process.
It is how lokks like the icon this application:
Sorted data in tables in SQL Server using COLLATE clause
The COLLATE is a clause apply to the database, column or string expression, set collation for data.
The COLLATE clause inher ... RDER BY name COLLATE Polish_CI_AI
BIN :
SELECT[id],[name]
FROM [BazaTest].[dbo].[person]
ORDER BY name COLLATE Polish_BIN
Create database model in DBDesigner
After install DBDesigner( I describe this process in my last post) You may run this application.
You see window as below:Clo ... lation and choose from menu Edit Object.
You see Relation Editor window.
In Relation Editor change data.
Click the OK button.
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
Begin with creating i ... one NULL value. If You would like to constraints this field for NOT NULL, You may add NOT NULL to column with UNIQUE clause.
The CASE expression in SELECT statement in SQL Server 2012
The CASE expression is used in SELECT, UPDATE, DELETE statement
and in WHERE, IN, ORDER BY and HAVING clause.
The CASE expres ... ]
WHERE [Title] is NOT NULL
AND [LastName] LIKE 'Va%';
The next post will be about use CASE expression in other statements.
The LEAD and LAG functions in SQL Server 2012
The LEAD function provides value from the next row in result of query.
The LAG function provides value from the previous row ... BY p.name ORDER BY s.value) as prev,
p.name, s.year, s.value
FROM person p
JOIN salary s on s.id_person_fk = p.id ;
TOP clause in T-SQL
Using TOP in T-SQL select given number of rows. It limits the rows returned in a query result set.
Let begin with TOP clause ... be use only in SELECT statement and with ORDER BY clause. The TOP is used in SELECT, INSERT, UPDATE, DELETE, MERGE statement.
How install Oracle Express(XE) 11g on Windows 64-bit?
The first step is go to website:
Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
And down ... process installation start.
Click the Finish button.
On the Desktop you see this icon:
In the Start->Programs you see:
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
Begin with creating i ... one NULL value. If You would like to constraints this field for NOT NULL, You may add NOT NULL to column with UNIQUE clause.
In Zend Framework 1.12 Application error: No adapter found for Application Model DbTable
I met last time situation in that I run my application with error: No adapter found for Application_Model_DbTable. What’s wr ... tion.ini file and paste it before [staging : production] section:
Running application You see list of animals from database.
Create table in pgAdmin 4 with autoincrement column
Open pgAdmin tool. Expand nodes in your database and go to the Tables node. Right click the Table node and choose Create-> ... ing the property icon.
And to watch result, right click the name of table and choose View Data->View All Rows.
It is data: