If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > update with jet 4 and ado error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-21-04, 21:30
sib121 sib121 is offline
Registered User
 
Join Date: Apr 2004
Posts: 10
update with jet 4 and ado error

update with jet 4 and ado error

I am trying to do a really simple update and keep getting errors whatever method I use.. (have also tried using the connection.execute to update)

Set getEventMembers = Server.CreateObject("ADODB.Recordset")
getEventMembers.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\datetastic\Database\date tastic_database.mdb;Persist Security Info=False"
getEventMembers.Source = "update customers set dt_customer_name = 'sib' where dt_customer_key = 2"
getEventMembers.CursorType = adopenkeyset
getEventMembers.CursorLocation = 2
getEventMembers.LockType = adLockPessimistic
getEventMembers.Open()

I get an ASP Script Error window come up with the yellow exclamation mark triangle saying 'No value given for one or more required parameters'

Please someone help, am at my wits end, I tried an update using the Dreamweaver GUI and its fine and looks no different to my handwritten code.

Many Thanks
__________________
Many Thanks
Siobhan
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On