Hello, I have a page in my member-admin area where the member can edit their service area (zip codes). This page contains a cfgrid (format:flash) with the only editable column being zipCode. The action page that this grid subt to uses cfquery method to update, delete or insert records. All of this works ok except the possibility exists that the same zip code could be entered more than once under the same memberID. I must be able to prevent that. However, the same zip code must be allowed multiple times within the table because other members may have that zip as well. 1 member can have >100 zips in their area.
Here is what I have tried without success:
<cfelseif Form.grid2.rowstatus.action[counter] is "I" and form.grid2.zipCode[counter] neq form.grid2.original.zipCode[counter]> Problem here is originals are not read on value 'I'.
I think I need to put the members existing zip codes into some kind of array on the insert page and only insert if NEQ array. Problem is, I have never worked with this type of problem. Thakns, Andy