| Title: | Smart or Stupid (CFLOOP as a GOTO) |
| Date: | 06/28/03 19 Posts |
| Summary: | A CFTRY block may be a good way to handle server-side form validation. If a form field is invalid, simply CFTHROW an error message. Alternative solutions, along with code snippets, are also included. Note that it's best practice to get server-side form validation working before adding JavaScript client-side form validation. |
| Title: | Is There a Way to Test to See if a Data Source Exists? |
| Date: | 06/28/03 15 Posts |
| Summary: | In CF 5, you can test the existence of a data source by using an undocumented function: <CFIF CF_IsColdFusionDataSource("MyDSN")> In Windows, you can check the ODBC data sources in the system registry. You could also run a simple query inside a CFTRY block to CFCATCH a database error. |
| Title: | RDS Error |
| Date: | 06/29/03 6 Posts |
| Summary: | A Homesite+ RDS connection error may be caused by a missing stub file, ide.cfm. The workaround is to create an empty ide.cfm file. |