Scott, There is a new settings to select directo or as a cursor in the advanced tab. My guess is that the "cursor" wouldn't work correctly. You should probably try the "direct" select (or maybe its the other way around ... hmm....).
-mk -----Original Message----- From: Van Vliet, Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 12:53 PM To: CF-Talk Subject: CFMX and SQL 2000 Views Greetings, Has anyone experienced problems on CFMX using the Microsoft SQL Server JBDC Driver to query Views? I have a database with quite a few Views, and every query against a View returns the following error: <snip> [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'vActiveModels'. </snip> Your thoughts? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
