Azeem Huda wrote: > > Syntax error (missing operator) in query expression 'CASE WHEN > bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.
Sounds like your database does not have support for CASE statements. You need to check the manual for some other type of IF support. > Can you explain "CAST (0 AS VARCHAR)". Btw, at this stage of development i > am using Access2000 but will be changing to SQL2000 soon, so the bug_type > field is simply "text". The normal datatype of 0 is some numberic type. But bug_type is some text type. Since they will be in the same column, their datatype *has* to be the same. CAST() will override the default datatype and cast it to some other datatype so they are the same. But again, I am not sure if your database supports the cast statement. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
