Ian, Well, that could happen as well. Obviously the tag itself can throw errors unrelated to the DB - like syntax errors etc.
-Mark -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 11:32 AM To: CF-Talk Subject: RE: CFQueryParam and Error Handling Ok...I'm going to try type "Database" again. That's was my first thought, but it didn't seem to be working. That I was getting error's that weren't of type "Database"..and when I dump the errors, CFCatch.ErrorType is "Unknown". Ian -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 9:23 AM To: CF-Talk Subject: RE: CFQueryParam and Error Handling Ian, The <cfqueryparam> tag will throw errors of type "Database" when any values that are not of the correct type are passed into it. This actually works pretty much the same as when you are not using the tag. For example, passing an int (like 50) to a character field using the "char" type will work - naturally. Passing a non numeric character string to a numeric field will not work etc. <cfqueryparam> does not cause huge changes to error trapping. -Mark. -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 10:59 AM To: CF-Talk Subject: CFQueryParam and Error Handling I'm trying to step up my coding standards and start using <cfqueryparam>'s in my Database calls. What I would like to know is how I should catch error's thrown by improper data passed to the queryparam? I've scanned through the <cftry><cfcatch> and the <cferror> documentation, but I'm not readily understanding how to use either one to catch error's in data passed to a <cfqueryparam> and provide logic to handle it. Thanks Ian Skinner Web Developer Blood Source ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
