Does anybody know why this happens? Is it really no longer valid to pass a valid sql statement that doesn't produce a recordset? So ... How do I use a query to create a table, etc?
-------------------------------------------- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No ResultSet set was produced. The Error Occurred in C:\CFusionMX\wwwroot\tapestry43e\netap\components\addr emove\tapestry\dbserver\mssql2000\0000.0020.drop.triggers.cfm: line 14 Called from C:\CFusionMX\wwwroot\jdbc.cfm: line 8 Called from C:\CFusionMX\wwwroot\tapestry43e\netap\components\addremove\tape stry\dbserver\mssql2000\0000.0020.drop.triggers.cfm: line 14 Called from C:\CFusionMX\wwwroot\jdbc.cfm: line 8 12 : if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trLibraryUpdate]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) 13 : drop trigger [dbo].[trLibraryUpdate] 14 : </cfquery> 15 : 16 : <cfquery datasource="#attributes.dsn#" username="#attributes.dsnusr#" password="#attributes.dsnpwd#"> s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
