Categories
Tags → Sql Query

AddCriteria Simplifies SQL Queries

AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function.
DETAILS

Inserting Records into the Database using Java Servlets.

An article on inserting records into the database with Java Servlets. Every step from establishing a Connection to executing the INSERT SQL query is explained in detail. Online demo available.
DETAILS

Integrating User Search with ASP and SQL Server Full-Text Search

This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000. Full source code available for download.
DETAILS

ASPDB-Ax

ASPDB-Ax is an ASP application for connecting to instantly Design, Search and Edit all your Access and SQL Server databases on the web. Features: A pure HTML/ASP/ADO based solution to ensure 100% Cross Browser Compatibility, Full ADO Paging Support, ...
DETAILS

DataBrowser

The DataBrowser is a cross-database, cross-platform data access tool. It inlcludes features such as a schema treeview, table editor, sql query window, and results tableview. The DataBrowser includes pre-formatted connectors for Oracle, SQL-Server, D...
DETAILS

UltraTree

UltraTree is a fast navigation tree builder based on PHP and MySQL. Features: unlimited depth, though you can set a limit; makes only one SQL query to draw the tree; draws all the ascending branches; you can easily add it to your scripts; UltraTree g...
DETAILS

Dynamically Generated HTML Forms

This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.
DETAILS

Online Wizard for Converting HTML Table to Delimited Text File

This is an ASP/DHTML-designed online wizard for converting HTML table to text file with user specified delimiter. You may use this wizard to convert html table generated from SQL Server in an internet or an intranet system to text file with a user sp...
DETAILS

SQLmap

SQLmap is a small application valuable for those who is responsible for building or maintaining a web site and SQL Server database. This application helps to access all servers and then access all databases stored in each server. Then with the interf...
DETAILS

Accessing a Microsoft SQL Server database from PHP running under Linux

This article describes how to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box.
DETAILS

Page:
©2003-2019 jCay.com