I found what was causing the problem and maybe someone can explain why - -the field was originally set as a text field... I changed it to nvarchar and the error went away using:
where members.speakers <> '' the error appeared using the above code until I made that field data type change -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 05, 2006 9:08 AM To: CF-Talk Subject: RE: CF SQL question > I hope this is an easy one. using SQL Server 2000.. Have a > query trying to test for empty fields. tried the following > and other variations but no luck: > > where members.speakers IS NOT "" > > Get this error: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot use > empty object or column names. Use a single space if necessary. Use single quotes to delimit literal strings in SQL. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4