Well if the database is there but CF says it isn't... I'd make sure you are using the datasource that you think you are. :-)
Dump #application.cfg.msgboarddsn# to make sure that it is what you expect it to be. Then try something simple like simple like <cfquery datasource="#application.cfg.msgboarddsn#" name="tmp"> select * from cf4em_bannedips </cfquery> <cfdump var="#tmp#" /> ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Mallory Woods [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2008 11:29 AM To: cf-talk Subject: Re: Best Open Source Message Board? --- Error Text --- Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'cf4em_bannedips'. The error occurred in C:\websites\cf4em\cfcs\cf4em.cfc: line 61 Called from C:\websites\cf4em\cf4em.cfm: line 21 Called from C:\websites\cf4em\cf4em.cfm: line 1 Called from C:\websites\cf4em\index.cfm: line 11 Called from C:\websites\cf4em\cfcs\cf4em.cfc: line 61 Called from C:\websites\cf4em\cf4em.cfm: line 21 Called from C:\websites\cf4em\cf4em.cfm: line 1 Called from C:\websites\cf4em\index.cfm: line 11 59 : or 60 : ( 61 : #ipnumber# between startipnumber and endipnumber 62 : and 63 : endipnumber > 0 -- End Error Text -- This is right out of the box.. no modification on the code. The table is there as created by the script Thanks On Wed, Oct 29, 2008 at 11:22 AM, Will Tomlinson <[EMAIL PROTECTED]>wrote: > >I am working on getting cf4em setup but its throwing lots of errors > >for > some > >reason. > > What errors are you getting? > > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
