looks perfect SQL, thats what freaks me. example: customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' so that makes that line: AND (customer_contact.phone LIKE '%952%' OR customer_contact.phone LIKE '%651%' ) yeah, no division anywhere and a big ugly query. CF Error, and if I take out my ugly workaround for zipcode or areacode it works fine.
DIAGNOSTIC: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error encountered. The error occurred on line 127. -------------------------------------------------------- Eric J. Hoffman Market Connections 2081 Industrial Blvd. Stillwater MN 55082 http://www.marketconnections.us T: 651.207.1526 F: 651.207.1536 M: 952.210.9060 E: [EMAIL PROTECTED] This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ________________________________ From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wed 3/23/2005 2:38 PM To: CF-Talk Subject: RE: divide by zero error Output #sql1# and #sql2# and see what it looks like. Ade -----Original Message----- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: 23 March 2005 20:30 To: CF-Talk Subject: RE: divide by zero error no, no result sets....just outputting....it dies exactly in the query where I reference sql2 or sql1 as a variable. pull it out, its okay. But doing the loops in the query I couldn't get to work either, because its very hard to program through the pain meds. I don't recommend. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21/03/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
