Categories
Tags → Sql Example

MyPagina (pagination) class

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information...
DETAILS

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
DETAILS

Bf.Forums Express

Add robust, threaded, easy to use ASP based forums to your website. Uses ODBC, and has been tested against MS Access and MS SQL Server. Download package comes with the component, object reference (documentation), quickstart guide, and an example im...
DETAILS

JSP Hit Counter

This counter uses MS SQL Server to store hits. I have used a custom stored procedure to add and display hit. This is a very good example using stored procedures with JSP.
DETAILS

Speck CMS

Speck is an open-source content management framework built as a library of ColdFusion custom tags which is used to build Internet content management systems. It is distributed with an example CMS that provides a set of out-of-the-box content manageme...
DETAILS

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.
DETAILS

Delete records with sql statements

Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
DETAILS

Access and SQL Server DSN-LESS connections

There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server c...
DETAILS

Edit records with sql statements

Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
DETAILS

Add records with sql statments

Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
DETAILS

Page:
©2003-2019 jCay.com