Ask a Question related to ASP, Design and Development.

  1. #1

    Default Update method

    I use the following to update:

    Dim rsEdit1
    Set rsEdit1 = Server.CreateObject("ADODB.Recordset")
    rsEdit1.ActiveConnection = MM_shop_STRING
    rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12"
    rsEdit1.CursorType = 2
    rsEdit1.LockType = 3
    rsEdit1.Open()

    rsEdit1.("authorMemo") = "TEST" *Error message from this line
    rsEdit1.update

    rsEdit1.Close()
    Set rsEdit1 = Nothing

    The problem is that I keep getting the following error message :

    "Microsoft VBScript compilation (0x800A03F2) Expected identifier"

    Can anyone help ?


    Poppy Guest

  2. Similar Questions and Discussions

    1. Is creationComplete=method() or initialize=method() theright solution for such kind of problem or ...?
      Hi everybody, I am using web service in my flex application and I want to visualize some data from collection of objects taht I receive from my Web...
    2. Preferred method of doing an update within Asp using Access
      I was wondering what is the best method of accomplishing an update within Asp using Access? I was going to going to use the update method of an ado...
    3. method name exists, property value exists, calling method fails
      I have a class object I am calling in another class: class Stuff { var $myObj; function Stuff($myObj) { $this->myObj = $myObj; }
    4. Update method error
      I use the following to update: Dim rsEdit1 Set rsEdit1 = Server.CreateObject("ADODB.Recordset") rsEdit1.ActiveConnection = MM_shop_STRING...
    5. update problem in DataGrid's UpdateCommand method
      Hi, anyone can help me to solve this little problem that i've spent a lot of time to solve it!! but i can't!!!! actually, i use a DataGrid, and...
  3. #2

    Default Re: Update method

    Please post to one newsgroup onlye

    Answered in asp.db

    Cheers
    Ken

    "Poppy" <paul.diamond@NOSPAMthemedialounge.com> wrote in message
    news:OXoL8CImDHA.684@TK2MSFTNGP09.phx.gbl...
    : I use the following to update:
    :
    : Dim rsEdit1
    : Set rsEdit1 = Server.CreateObject("ADODB.Recordset")
    : rsEdit1.ActiveConnection = MM_shop_STRING
    : rsEdit1.Source = "SELECT * FROM products WHERE pautoid = 12"
    : rsEdit1.CursorType = 2
    : rsEdit1.LockType = 3
    : rsEdit1.Open()
    :
    : rsEdit1.("authorMemo") = "TEST" *Error message from this line
    : rsEdit1.update
    :
    : rsEdit1.Close()
    : Set rsEdit1 = Nothing
    :
    : The problem is that I keep getting the following error message :
    :
    : "Microsoft VBScript compilation (0x800A03F2) Expected identifier"
    :
    : Can anyone help ?
    :
    :


    Ken Schaefer Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139