ABTG: Addresses Grid Error
Today I corrected an error that occured when loading address grids. The row limiting criteria was set to filter on customer name, but I forgot to escape possible quotes in the customer name.
This was a quick fix thanks to the elog. I checked it for the last error, pasted the sql statement I found in the post eval field, and checked the error message i got.
So, instead of = '%txtCustomerVar', it is now = '%Replace(%txtCustomVar,"'","''")' within the grid conditions.
Edit: 5 minutes after publishing this post, I noticed the same error in ABTG_Addresses_Page.asp, which allows users to add new addresses.
This was a quick fix thanks to the elog. I checked it for the last error, pasted the sql statement I found in the post eval field, and checked the error message i got.
So, instead of = '%txtCustomerVar', it is now = '%Replace(%txtCustomVar,"'","''")' within the grid conditions.
Edit: 5 minutes after publishing this post, I noticed the same error in ABTG_Addresses_Page.asp, which allows users to add new addresses.
0 Comments:
Post a Comment
<< Home