nick way wrote: > is there a way to create new columns in tables (and even to create > new tables perhaps) via CF so i dont have to do this downloading / > uploading procedure to my mdb documnet (i'm using an access database > by the way) >
What you are looking for is the Data Definition Language (or DDL) for Access ...with that you would do something like this... <cfquery datasource="blah"> ALTER TABLE MyTable ADD COLUMN new_variable yesno </cfquery> Unfortunately, I have found Access DDL to not be as well documented as SQL Server, but there are a few good articles on it, such as... http://support.microsoft.com/default.aspx?scid=kb;en-us;180841 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
