Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: ASP Database Related Delete records with sql statements Tutorial

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.

Tutorial Details:

Delete Records With an SQL Statement

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.

This example is for using forms and makes some assumptions. Be sure to make the necessary changes.

That you want to use a physical path to the database.

That you use the Access driver, your database is named myDB and the path is on the E drive.

That the table in your database is named myTable, one field is named email and that the field in the form is named textbox1.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
ASP Database Related Delete records with sql statements Tutorial

View Tutorial:
ASP Database Related Delete records with sql statements Tutorial

Related Tutorials:

SQLJ: The 'open sesame' of Java database applications
SQLJ: The 'open sesame' of Java database applications
 
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
A beginner's guide to Enterprise JavaBeans - JavaWorld - October 1998
 
Use a RandomAccessFile to building a low-level database - JavaWorld January 1999
Use a RandomAccessFile to building a low-level database - JavaWorld January 1999
 
Publish
Publish event-driven Web content with JSP custom tags
 
Create your own type 3 JDBC driver, Part 3
Create your own type 3 JDBC driver, Part 3
 
Rumble in the jungle: J2EE versus .Net, Part 2
Rumble in the jungle: J2EE versus .Net, Part 2
 
Good introduction to JDO
Good introduction to JDO
 
SQL Database Access with DBTags
SQL Database Access with DBTags In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
 
Developing Your First Enterprise Beans, Part 1
One of the most important features of EJB is that enterprise beans have the ability to work with containers from different vendors. However, that doesn't mean that selecting a server and installing your enterprise beans on that server are trivial processe
 
Developing Your First EJBs, Part 2
the authors walked through what you need to do to develop your first entity bean. This week concludes this series with a look at how to develop a session bean, building on the examples presented in part one.
 
StelsCSV - JDBC driver for text files
StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma separated, tab separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
Primrose - Free J2EE Database Connection Pooling Software
Primrose Primrose is a database connection pool, written in Java. Current containers support are Tomcat 4 & 5, and JBoss 3. There is also now a standalone version of primrose that can be used for applications not running inside a container.
 
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
 
Excellent Guide to Java / Databases, JDBC
JDBC is a Java API for executing SQL statements. Start here, Examples Central Sites Related Sites, Link Collections Tutorials, FAQs, References Company Newsgroups Mailing Lists, General Articles, Special Articles, Interoperability Books util
 
Welcome to Java Developers paradise!
Welcome to Java Developers paradise! T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java
 
First Step towards JDBC!
First Step towards JDBC! Welcome to our JDBC Section First Step towards JDBC This article introduce you with JDBC and shows you how to create a database application to access the databases. Accessing the Database from Servlet This article shows
 
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets. Using MYSQL Database with JSP & Servlets. MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it
 
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page Connecting to MySQL database and retrieving and displaying data in JSP page This tutorial shows you how to connect to MySQL database and retrieve the data from the
 
StelsCSV v2.2 - JDBC driver for CSV files
*StelsCSV* is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (CSV, tab-separated, fixed length etc). Using this driver, you can easily create a simple database consisting of plain text files.
 
DB Visual Architect for Eclipse
DB Visual Architect for Eclipse (DBVA-EC) is a full featured Object Relational Mapping (ORM) plugin for Eclipse that provides the industry\'s best round-trip code engineering support with Java.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.