Incubating

Thursday, August 03, 2006

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.

0 Comments:

Post a Comment

<< Home