what is wrong with the code?

longmatch · Feb 20, 2002

I just copy the code from

http://WWW.WROX.COM

website for "Beginning Active Server Pages". It did not work. I have run other code access the database (movies2000.mdb), it works fine. Anybody knows what is wrong?

Thanks

Haijun

<%
Option Explicit
Dim strConnect
%>


<HTML>
<HEAD>
<TITLE>Using SQL's UPDATE Command and the ADO Command Object</TITLE>
</HEAD>
<BODY>
<%
Dim objComm, intNoOfRecords
Set objComm = Server.CreateObject("ADODB.Command&quot

Response.Write "Harry the Ham directs Tarantino films? "
objComm.ActiveConnection = strConnect
objComm.CommandText="UPDATE AllMovies SET Director = 'Harry the Ham' " & _
"WHERE Director LIKE 'Quentin Tarantino'"
objComm.CommandType=adCmdText
objComm.Execute intNoOfRecords
Response.Write "This UPDATE command has affected " & _
intNoOfRecords & " records "

Response.Write "Tarantino returned to his rightful place as director: "
objComm.CommandText="UPDATE AllMovies SET Director = 'Quentin Tarantino' " & _
"WHERE Director LIKE 'Harry the Ham'"
objComm.Execute intNoOfRecords
Response.Write "This UPDATE command has affected " & _
intNoOfRecords & " records "
Set objComm = Nothing
%>
</BODY>
</HTML>

JJR · Feb 20, 2002

You also have the included file DataStore.asp??

Jordi Reineman

longmatch · Feb 20, 2002

Dear Jordi:
Thank you for your quick response. I do have dataStore.asp file included in the same directory as this file.

Haijun

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

what is wrong with the code?

longmatch

Programmer

JJR

Programmer

longmatch

Programmer

Similar threads

Part and Inventory Search

Sponsor