|
 |
access_asp thread: help!!! Object required error
Message #1 by "Steve" <sathey@c...> on Thu, 25 Apr 2002 23:08:47
|
|
I was wondering as I'm trying to use your code to update a record in my
access DB.
I have been getting this error and I can not seem to find it.
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/osatpi/SPR_DCR/update_caiso_id.asp, line 14
Could you help:
I have included the code Below:
<% @Language=VBScript%>
<% Option Explicit %>
< !--#include file="adovbs.inc"-->
< !--#include file="connection.asp"-->
<%
Dim ID, MyConn, RSMain, CAISO_ID, Requester, DisplayName, ShortDescription,
LongDescription, Status, State, Status_Log, Priority, Est_Com
%>
<%
CAISO_ID = trim(request.form("CAISO_ID"))
Requester = trim(request.form("Requester"))
DisplayName = trim(request.form("DisplayName"))
ShortDescription = trim(request.form("ShortDescription"))
LongDescription = trim(request.form("LongDescription"))
Status = trim(request.form("Status"))
State = trim(request.form("State"))
Status_Log = trim(request.form("Status_Log"))
Priority = trim(request.form("Priority"))
Est_Com = trim(request.form("Est_Com"))
ID = trim(request.form("ID"))
Set RSMain = MyConn.execute("UPDATE Main SET CAISO_ID = ' " & CAISO_ID
& " '
, Requester = ' " & Requester & " ' , DisplayName = ' " & DisplayName
& " ',
ShortDescription = ' " & ShortDescription & " ' , LongDescription = ' " &
LongDescription & " ' , Status = ' " & Status & " ' , State = ' " & State &
" ' , Status_Log = ' " & Status_Log & " ' , Priority = ' " & Priority & " '
, Est_Com = ' " & Est_Com & " ' WHERE ID = " & CAISO_ID & " ")
%>
<html>
<head><title>Edit User</title></head>
<body>
You have successfully updated a user. <a href="users.asp">Click here</a> to
continue.
</body</html>
Looking forward to your help.
thanks!
Steve Athey
"Growing Older But Not Up!"
Message #2 by Spencer Saunders <spence@s...> on Thu, 25 Apr 2002 21:11:07 -0400
|
|
Assuming that line 14 is one of the lines where you are setting a variable I
would guess that it might be something as simple as a typo.
check your fomr field names and be sure that you haven't mispelled anything
between the actual form page and the page you list below.
s[pen]ce
on 4/25/02 11:08 PM, Steve at sathey@c... wrote:
> I was wondering as I'm trying to use your code to update a record in my
> access DB.
> I have been getting this error and I can not seem to find it.
> Error Type:
> Microsoft VBScript runtime (0x800A01A8)
> Object required: ''
> /osatpi/SPR_DCR/update_caiso_id.asp, line 14
>
> Could you help:
> I have included the code Below:
>
> <% @Language=VBScript%>
> <% Option Explicit %>
> < !--#include file="adovbs.inc"-->
> < !--#include file="connection.asp"-->
> <%
> Dim ID, MyConn, RSMain, CAISO_ID, Requester, DisplayName, ShortDescription,
> LongDescription, Status, State, Status_Log, Priority, Est_Com
> %>
>
> <%
> CAISO_ID = trim(request.form("CAISO_ID"))
> Requester = trim(request.form("Requester"))
> DisplayName = trim(request.form("DisplayName"))
> ShortDescription = trim(request.form("ShortDescription"))
> LongDescription = trim(request.form("LongDescription"))
> Status = trim(request.form("Status"))
> State = trim(request.form("State"))
> Status_Log = trim(request.form("Status_Log"))
> Priority = trim(request.form("Priority"))
> Est_Com = trim(request.form("Est_Com"))
> ID = trim(request.form("ID"))
>
> Set RSMain = MyConn.execute("UPDATE Main SET CAISO_ID = ' " & CAISO_ID
> & " '
> , Requester = ' " & Requester & " ' , DisplayName = ' " & DisplayName
> & " ',
> ShortDescription = ' " & ShortDescription & " ' , LongDescription = ' " &
> LongDescription & " ' , Status = ' " & Status & " ' , State = ' " & State &
> " ' , Status_Log = ' " & Status_Log & " ' , Priority = ' " & Priority & " '
> , Est_Com = ' " & Est_Com & " ' WHERE ID = " & CAISO_ID & " ")
>
> %>
> <html>
> <head><title>Edit User</title></head>
> <body>
> You have successfully updated a user. <a href="users.asp">Click here</a> to
> continue.
> </body</html>
>
> Looking forward to your help.
>
> thanks!
>
>
> Steve Athey
> "Growing Older But Not Up!"
|
|
|
View Cart
