I am wondering is anyone can help me on the sytna for a not equal to value using a cfc? I wrote this query in sql server and it works fine, but my cfc doesnt like the '<>' for not equal to. Does anyone know the correct way to write this?
Thanks, *******my query******** SELECT OptionValue FROM dbo.OptionLOV WHERE (OptionType = 'CostCat') AND (OptionValue <> 'Total') -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
