Using a little bit of jQuery we can upload images without the suck.
Click here for the complete tutorial.
We already discussed the methods to use TOP functions in MySQL and in MSSQL.
In Oracle we make use of the ROWNUM function in the WHERE clause.
To take our names table again in this example, to get the first 5 rows, make use of the following query:
SELECT firstname,lastname
FROM names
WHERE ROWNUM <= 5
This will retrieve the first [...]
After I explained the MySQL method for getting the TOP N rows in a query it is time to explain the same for MS-SQL.
Here we use the TOP function.
To retrieve the first 5 rows from the names table, use the following query:
SELECT TOP 5 firstname,lastname
FROM names
If you want to retrieve a certain percentage (for example [...]
On the web I see a lot of questions of developers who are wanting to know how they can retrieve only the first N records in their queries.
The answer is simple, LIMIT
For example, if you only want to select the top 5 names from a names tables, use the following query:
SELECT `firstname`,`lastname`
FROM `names`
ORDER [...]
As promised in my previous post with usefull PHP articles and tutorials, now it’s time for some cool and handy SQL articles!
Here we go:
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this.
Author Divya Agrawal shows a technique [...]
Many users of Google Chrome do not know about the Omnibox, the adressbar which also enables you to search the web.
Google has made a video with an instruction how to use the Omnibox in Google Chrome, you we can all use this cool feature of Google Chrome!
I had some cool PHP articles in my RSS reader, which you should really read because it will give you usefull information when developing applications and websites with PHP!
Magic features of PHP
PHP contains magic methods, magic constants and a magic function, which are special features of the PHP language and can be used for various [...]
In Ubuntu the default text editor is vim.
I can imagine that you want to use for example nano or ed.
This is a very small how to on how to edit your default text editor in Ubuntu so you can edit for example your crontab file with your favorite text editor:
1. Open a terminal window.
2. Type: [...]
Yesterday I started an old Ubuntu Vmware machine to get some code I developed on that machine.
There was only one problem, I couldn’t remember the password!
I found a way how you can recover your password in a easy way:
1. Boot your system.
2. When your system is booting, press the ESC button to enter [...]