I've almost finished building a login page for a chatroom in CF. The last thing I need to fix is on the registration page. I've setup the MySQL login's database to have the unique attribute for the login id. Now the problem is that when someone tries to register a login that already exists I get a messy ODBC error.
So what I need to know is how can I test whether the login id already exists? This will allow me to put up a nice HTML page tell the person that the login id is already taken, that would be much better and understandable than a messy ODBC error message. I think my question is how can i find the success/error status of a SQL query from within CF? Thanks. Paul ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
