Update Table records from Button

Check this article that explains how to troubleshoot buttons code:

http://xlinesoft.com/blog/2012/05/16/troubleshooting-custom-buttons-in-phprunner-and-asprunnerpro-applications/
You need to print your SQL Query from there to see if it looks correct.

Have tried your suggestion according to the documentation and this is the error I receive. Can you tell me what it means ?
buttonhandler.asp POST 500 Internal Server Error text/html loadfirst.js:2 Script 613 B 286 B 255 ms 255 ms 255 ms

Hi jmack,

try this way:

this should work, if you have an error replace ("Vendor Number") with ("Vendor_Number")
sometimes spaces affect the coding

AND PLEASE let me know if works or if you found other way to do it.

Thank you for the quick reply and suggestion. I added your code as suggested and it still does nothing. No error or message and no table update.
Thank you for the suggestion. I am at a loss.

jmack,
you need to post a screenshot that explains what you see under Response tab, similar to screenshot #2 at http://xlinesoft.com/blog/2012/05/16/troubleshooting-custom-buttons-in-phprunner-and-asprunnerpro-applications/

sorry my bad, i miss the UPDATE on the code:

try it now.

gonzalosb,
Made change but still nothing. Thanks for the suggestion.
Admin, I did screen print of error but when I copy it and try to paste the paste option is grayed out. How do I insert the screenshot ?

Upload it somewhere, to Dropbox or to imgur.com

hmmm, ok try it like this:

or

or the last one without the DoAssigment line
if still not working, replace - Session("Vendor Number") - from the source and all your coding with - Session("VendorNumber") - all together.

Sometimes the phrases like NUMBER by there own confuse the database.

Tried all of your suggestion with NO luck. Table is not updated and no message is displayed. I even tried this code from one of your earlier posts. Strange, I get the message that the records were updated but that's all it does, display the message. It doesn't update the Password field to xxxxxxxx.
dim sql, record

DoAssignment record, button.getNextSelectedRecord()

do while isObject(record)

sql = "Update Userstbl set Password='xxxxxxxx' where ID='" & record("VendorNumber") & "'"

dbConnection.Execute sql

DoAssignment record, button.getNextSelectedRecord()

loop

result("txt") = "Records were updated."
Thanks for your help and suggestions.

that code didnt work for mi ider, this is what i use that work for me

this work for sure but in your case you need to get the username from the login instead of an ID from the table.
OOH!!! try replacing ID=" & record("ID") with VendorNumber=" & SESSION("UserName")

it may be thats why i doesnt work
is the user using his vendor number to login as UserName? if not, replace VendorNumber= with the column name where the Login username is located.

EX: UserName= or LoginName= etc,etc
if still not work, create a separated project only to test the code by it self to be sure nothing is corrupting the code.
Keep diging and keep asking my friend, this code is tricky, take me long to figure it out to me too...

Here is what finally worked: