Tags → Sql Using

Display Table Script Writer

This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is re...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Generating RSS with ASP

RSS files can be generated using Active Server Pages (ASP). It is OK for an RSS file to have a .asp suffix. In this example an RSS 0.91 file is generated, but it could easily be applied to other RSS versions. Similarly in this case the site stores it...

• Categories
  • ASP →
  • Tips and Tutorials →
  • XML and ASP
• Platforms
  • Linux
• Licenses
  • Freeware

Display an Excel DB

The author writes &"For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.&...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Excel and ASP
• Platforms
  • Linux
• Licenses
  • Freeware

Setting Up a MySQL Based Website - Part I

This is a step-by-step tutorial on how to set up a guestbook using a perl and a MySQL backend. This SQL backend application would be ideal for companies such as GuestWorld who run free public guestbooks.

• Categories
  • CGI and Perl →
  • Tips and Tutorials →
  • Guestbooks
• Platforms
  • Linux
• Licenses
  • Freeware

ASP Data Access for Beginners

The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft''s Active Server Pages, this is exceedingly easy to...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Insert Using SQL

This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Limit query results with the Recordset object

Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a ta...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

ADOdb Database Library for PHP

A PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP,...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • BSD Style

Fun With Stored Procedures...

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as oth...

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Platforms
  • Linux
• Licenses
  • Freeware

Database Normalization And Design Techniques

One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in orde...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• Previous
• 1
• 2
• 3
• 4
• 5
• ...
• 22
• Next