recordset

[poopsy]

hi.. i wud like to know how to open the recordset if i hav no select statement in my codes, i have only an insert and an update query
do i have to put
oRs.open con (con is the variable for the connection)
or
oRs.open con, sInsert, and sUpdate (sInsert and Supdate are my queries)

thx

[CroCrew]

Hello poopsy,

I believe only in Access and FoxPro do you have to first select a recode before you can update that record or add a new one. Other databases like Microsoft SQL server you don’t have too.

So all you really need to do is this:

<%
    Set Conn = Server.CreateObject("ADODB.Connection")
        Conn.Open Application("MyConnectionString")
 
    Conn.Execute("INSERT INTO MyTable (FirstName, LastName) VALUES ('Billy', 'Smith')")
    Conn.Execute("UPDATE MyTable SET FirstName = 'Bob' WHERE LastName = 'Smith'")
%>
 

Hope that helps~