This was a weird one. I setup a MS SQL database and forgot to fill in "database" under the CF admin.
I submitted it and it said it was "OK". I thought, OK my database is hooked up, but in my code I kept getting these strange errors basically saying the table you are trying to query is not a valid object. I beat my head agains the wall thinking it was my code, and eventually look back in CF Admin at the database and discovered my mistake. So once I filled in the "database" field in the CF admin it all started working. Why would CF Admin report back that the database connection verified if the database itself could not be connected too? Sound like a bug. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
