Personally I wouldn't be too quick to jump on the idea that this is an FB problem ( don't get me wrong, I'm not an FB advocate or anything ) ... I suppose it could be, but it wouldn't be the way I would hedge my bets. Is this a recently coppied / duplicated app?
I'd check the CF Admin and make sure that the DSN is pointing both to the correct db server and to the correct db on that server. Then make sure the UtilityAdmin table in that db is a DBO.table -- which may also have been changed (even if nobody intentionally changed it -- gotta keep a close eye on DTS in SQL Server) if the app was recently coppied or duplicated to a different db or db server... Have you run a cfquery in a test module? i.e. copy the code from the failing query (absolute values rather than variables) from the act_login.cfm and place it in a test.cfm in the root of the app just to test the query ... I'd be really surprised if it works, but that would verify that it's an FB problem ... Isaac www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
