executing SQL query using ASP?

[Jerome]

Hi,

I've got the following problem and I don't know how to make this (if
it's possible at all):

I want to make a form where the user can enter a criteria and then,
after pushing a button or link, a certain table in a certain DB is
updated. So it's not about updating a single record, but a whole table!
The single update is no problem using Dreamweaver for example.

What I want in fact is simply execute an SQL update query ...

Any help is appreciated

[Roji. P. Thomas]

Open a connection using ADO
execute the Query againest your statement.
--
Roji. P. Thomas
SQL Server Programmer ;)
________________________
"Jerome" <jh***@NOSPAM.mnhn.lu> wrote in message
news:uZ**************@TK2MSFTNGP11.phx.gbl...

Hi,

I've got the following problem and I don't know how to make this (if
it's possible at all):

I want to make a form where the user can enter a criteria and then,
after pushing a button or link, a certain table in a certain DB is
updated. So it's not about updating a single record, but a whole table!
The single update is no problem using Dreamweaver for example.

What I want in fact is simply execute an SQL update query ...

Any help is appreciated

[Jeff Cochran]

On Fri, 21 Nov 2003 09:29:55 +0100, Jerome <jh***@NOSPAM.mnhn.lu>
wrote:

I've got the following problem and I don't know how to make this (if
it's possible at all):

I want to make a form where the user can enter a criteria and then,
after pushing a button or link, a certain table in a certain DB is
updated. So it's not about updating a single record, but a whole table!
The single update is no problem using Dreamweaver for example.

What I want in fact is simply execute an SQL update query ...

Well, stop using Dreamweaver and it's simple. :)

Okay, bad dig. This is simply normal ASP/ADO stuff. Open an ADO
connection, and run the query on that connection. Something along the
lines of:

(Access Database)

dbConnect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("database.mdb") & ";"
set Connect = server.CreateObject("ADODB.Connection")
Connect.Open dbConnect
strSQL = "UPDATE table SET field = 'New Data'"
Connect..Execute (strSql)

As long as you know how to create the SQL query, it's not a big deal
to do the rest.

For other ADO connections such as to SQl Server, look at:

http://www.able-consulting.com/ADO_Conn.htm

Jeff