When you pick the DSN to use for client variables, uncheck the box that says "create client tables" before you submit the form. CF's kind of dumb and doesn't check for the existence of the tables automatically - you have to explicitly tell it whether to skip that step.
cheers, barneyb On Mon, Feb 7, 2011 at 12:17 PM, daniel kessler <[email protected]> wrote: > > I had my client table set up by going to client variables and selecting my > data source through the dropdown. I clicked Add and then Submit Changes. > All was fine. > > Then I went messing around. Yknow, learning. > > So, I deleted my datasource. Then I readded it. When I went to back to > Client Variables, the one that I had created with the temporarily deleted > data source was gone. Since the datasource was back, I found it again in the > dropdown, selected it, clicked add and then clicked Submit Changes. > > However, it thinks that the previous client variable is still there. It > gives me the error "Unable to create client tables > If they already exist, you should uncheck Create Client Tables." > I checked the list of client variables on that same page, but it does not > show up. I can't re-add it and it doesn't show up. > > What do I need to do to be able to re-add the client variable? Does a file > need to be edited? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6920 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
