Update DB with SQL

[Cheech]

Maybe I am missing something.

I need to update a database using a SQL statement made up from passed information and such. Making the SQL statement was fun, but I need my asp page to just go ahead and update the database without further intervention???

Any one got any ideas??

I dont want to go to Chelsea!!!

 

[Bastien]

Hi Cheech,

using SQL is easy...


strSQL = " * from table where [Criteria] = something"
' to place a record in the DB use "Insert into table where values = something"

'set the connection and open that DB for the query
set objRS = server.createobject("adodb.recordset&quot

objRS.open strSQL, "data connection info"

hope this helps...

Bastien