2. ASPRunnerPro General questions
  3. Editing multiple worcords using insert button feature
This topic is locked

Editing multiple worcords using insert button feature

 		5/18/2010 4:15:04 PM
ASPRunnerPro General questions
M
 mfred author

This relates to an earlier post of mine. BUt I thought that it would be simpler to start a new topic. I need to use the insert button feature to edit displayed displayed records at once. I tried using the inline edit but IE would not work when I tested inline edit of around 100 records. So it appears that I needto do a button that will do the updates. The field that I need to change is called "status". When a specific search displays a batch of records, I need to change the group of records from undelivered to delivered. I'm not sure how to program the inserted buton to do this. Any assistance will be appreciated.
Sergey Kornilov admin 5/18/2010

http://xlinesoft.com/asprunnerpro/docs/inserting_button.htm

See Example 2
M
 		mfred author 5/18/2010

Example 2 appears to relate to emailing the records. I need to change information in a field. I'm sorry if I am missing something.
J
 		Jane 5/19/2010

Hi,
ID of selected values are stored in the keys array on the 'Server side' in the custom button.

Here is just a sample:

for each val in keys

strUpdate = "update tablename set fieldname='value' where KeyField=" & val("KeyField")

CustomQuery(strUpdate)

next
M
 		mfred author 6/9/2010

I thought that I understood. I added the following code in the server tab. However, it seems to get stuck "Sending request to server...". I experimented with changing strUpdate = "update MailQuery1 set Status='Delivered' where ID=" & val("ID") to strUpdate = "update MailQuery1 set Status='Delivered'". But that changes all the table entries to delivered.
for each val in keys
strUpdate = "update MailQuery1 set Status='Delivered' where ID=" & val("ID")
CustomQuery(strUpdate)
next