Adjust "WHERE 1" to "WHERE 1=1" for compatibility
pcorbett - February 11, 2009 - 19:31
| Project: | ipAuthenticator - authenticates an IP to a role |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | feature request |
| Priority: | minor |
| Assigned: | Unassigned |
| Status: | needs review |
Description
The catch-all "WHERE 1" SQL clause is not universally recognized - SQL Server doesn't know what to do in this case. Changing this to "WHERE 1=1" helps more databases remain compatible.
| Attachment | Size |
|---|---|
| ipauthenticator_where_patch.txt | 956 bytes |