I'm guessing as it's a SQL error and has a where clause then it is in the SQL !
Also for the length test in CF, I would go for len(tim(variableName) (whether you put 'GT 0' after this test is the subject of another recent thread ;-) ) On 10/5/06, Kris Jones <[EMAIL PROTECTED]> wrote: > Tim, > > I'm not entirely clear on where you're testing for empty fields, > whether it is in the SQL in your query, or whether you are checking > the field after the query has returned. So here's my 2 cents: > > If it's inside the SQL, you can't compare the field name to an empty > string with IS NOT, you must use equals (=), OR if you are comparing > to NULL, then you would use the IS NOT like so: > > select field1, field2 from table1 > where field1!="" > > OR > > select field1, field2 from table1 > where field1 is not NULL > > If you're checking field content in coldfusion after the query has > returned, then it would be something like this: > > <cfif queryname.field1 neq "">blah blah blah</cfif> > > Hope that helps. > Cheers, > Kris > > > 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255651 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4