D.A. sorting and search issues. WA Search not working
I'm getting an error when I use the search feature after using the D.A. sort feature. This is my error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'applicationID'.
Because the query uses five different tables, two of which contain a field called applicationID, I specified the table in the code. This, however, is not working and I receive the ambiguous column name error. I'm attaching the page in a ZIP file. Thanks!