Woohoo! One thing I sometimes do (which in retrospect I might have mentioned) is to try deleting the bit with the error and seeing if the error goes away. In this case it wouldn't have, which would have been good to know.
-----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 January 2005 11:30 a.m. To: CF-Talk Subject: Re: Query Larry White wrote: > Well, you have contradictions in your SQL: > WHERE atty_id <> 8787445854777 , indictes atty_id is numeric (no quotes) > yet the valuelist for atty_id is enclosed in quotes. It can't be both > ways. Yep, I *finally* figured that out! The error message kept pointing to the "Where" line though, which was throwing me off. The actual query on the page is almost 30 lines long - stupid me just lost it while searching for that one thing throwing it off.... Doh!!! Thanks! -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191745 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
