Setup: No experience with ASP, IIS V5 (I think. I can not tell.), Windows 2000, If you need more info please ask.
I am tying to update an Oracle data base by calling a stored procedure from a web page. Everything appears to run smoothly except no data is ever inserted.
I need help debugging what might be going wrong.
Here is the source:
Code:
<%@ Language=VBScript %>
<!--
include alert.asp
-->
<%
response.buffer = TRUE
response.expires = TRUE
On Error Resume Next
dim queryStr
queryStr = request.QueryString("action")&request.form
Set Comm = Server.CreateObject("ADODB.Command")
Comm.connectiontimeout = 60
comm.ActiveConnection = "dsn=telus2_iasdb;uid=reports;pwd=reports;"
comm.commandtype=4
comm.commandtext = "log_hits"
set param = comm.createparameter("InPut",200,1,500,querystr)
' set param = comm.Parameters
' param.append comm.createparameter(querystr,200,1)
comm.parameters.append param
'Pass the input value
' comm("InPut") = querystr
comm.execute()
response.redirect(querystr)
%>
I do not get any error messages. The IIS server logs show that the request for log_hits() is received. (See below). But my function never gets executed. Can some one tell me how I can check the reponse code from
comm.execute. If any one sees anything else do not be bashful.
Thanks.
Log output
2004-12-15 22:02:35 10.89.44.97 - 10.26.70.244 80 POST /hits/log.asp action=http://frasier:88/ows-bin/rwcgi60.exe? 302 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+T312461 ;+.NET+CLR+1.1.4322)
2004-12-15 22:03:19 10.89.44.97 - 10.26.70.244 80 POST /hits/log.asp action=http://frasier:88/ows-bin/rwcgi60.exe? 200 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+T312461 ;+.NET+CLR+1.1.4322)
dBforums
>
help a non-ASP programmer with debugging ASP program
12-16-04, 12:14
Linear Mode
