phishyman2
asked on
Object required: ''?????
Why do I keep getting this error:
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/don_sched/add_event_confi rm.asp, line 23
while using this code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<%
strConn = "dsn=don_sched;uid=don_sch ed;pwd=car ter;"
set Conn = Server.CreateObject("ADODB .Connectio n")
Conn.Open strConn
edate = request.form ("edate")
eprojname = request.form ("eprojname")
eprojman = request.form ("eprojman")
eprojdraft = request.form ("eprojdraft")
etask = request.form ("etask")
eprojnum = request.form ("eprojnum")
eprojclient = request.form ("eprojclient")
strSQL = "INSERT INTO master (edate, eprojname, eprojman, eprojdraft, etask, eprojnum, eprojclient) Values('" & edate & "','" & eprojname & "','" & eprojman & "','" & eprojdraft & "','" & etask & "','" & eprojnum & "','" & eprojclient & "')"
response.write strsql
set rs = connGlobal.Execute (strSQL)
%>
<body>
</body>
</html>
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/don_sched/add_event_confi
while using this code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<%
strConn = "dsn=don_sched;uid=don_sch
set Conn = Server.CreateObject("ADODB
Conn.Open strConn
edate = request.form ("edate")
eprojname = request.form ("eprojname")
eprojman = request.form ("eprojman")
eprojdraft = request.form ("eprojdraft")
etask = request.form ("etask")
eprojnum = request.form ("eprojnum")
eprojclient = request.form ("eprojclient")
strSQL = "INSERT INTO master (edate, eprojname, eprojman, eprojdraft, etask, eprojnum, eprojclient) Values('" & edate & "','" & eprojname & "','" & eprojman & "','" & eprojdraft & "','" & etask & "','" & eprojnum & "','" & eprojclient & "')"
response.write strsql
set rs = connGlobal.Execute (strSQL)
%>
<body>
</body>
</html>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry
set rs = Conn.Execute(strSQL)
I left of the first part
set rs = Conn.Execute(strSQL)
I left of the first part
@Carlmahon - I wasn't trying to correct you. It was a late duplicate. I think you made your point well in the first comment.
bol
bol
ASKER
Sweet. Thanks for the help
b0lsc0tt, thanks for the tip but my second post was done without knowledge of your answer. If I would have seen it then I wouldn't of posted because you gave phishyman2 a good cut and paste answer.
@Carlmahon - That makes sense. I certainly didn't mean to imply that you got anything from me. Sorry if it seemed that way. :)
@Phishyman2 - Your welcome! I'm glad that I could help you. Thank you for the grade, the points and the fun question.
bol
@Phishyman2 - Your welcome! I'm glad that I could help you. Thank you for the grade, the points and the fun question.
bol
should be Conn.Execute (strSQL)