Javascript to delete a record in SQL server

[Tony WONG]

i wish to make use of javascript to delete a record by clicking a button,
what's wrong with the following 3 lines? Thanks a lot.

function confirmYes()
{
var adoConnection = Server.CreateOb ject("ADODB.Con nection");
adoConnection.O pen("driver={SQ L
Server};Server= ABCD;Database=A AA;UID=BBB;PWD= CCC");
adoConnection.E xecute("update dbo.out set Schedule_Time = null where out_id
=<%=oMyObject%> ;");
}

[nic.j.roche]

Could be any number of things:
1. security on client machine
2. ODBC set up on client machine
3. Server side code mixed in with client-side: have you debugged what
<%=oMyObject%wr ites
3. are the DB objects ok?

Are you sure you want to evoke this code on the client?

Nic

Tony WONG wrote:

i wish to make use of javascript to delete a record by clicking a button,
what's wrong with the following 3 lines? Thanks a lot.

function confirmYes()
{
var adoConnection = Server.CreateOb ject("ADODB.Con nection");
adoConnection.O pen("driver={SQ L
Server};Server= ABCD;Database=A AA;UID=BBB;PWD= CCC");
adoConnection.E xecute("update dbo.out set Schedule_Time = null where out_id
=<%=oMyObject%> ;");
}