I dont think creating tables on the fly is good programming or relational
database
structure.
Your could try this, if you really have to...
<cfquery Name="CreateTable" Datasource="Test">
Create tableName (Firstname varchar(50), LastName varchar(50), age Num(3))
</cfquery>
You should use an account that has table creation permisions..
based on the user input.
hope this helps
Joe
----- Original Message -----
From: "Jesse" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 4:22 PM
Subject: how do you create new DB tables and Columns with CF
> say I had a access database with one table in it, and I wanted to
dynamiclly
> create new tables within that DB based on user input. and once the new
> tables are created how can I create the columns in that table based on
user
> input?....
>
> Is this even possible?
>
>
> -------------------------------------------------------------------------
-----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
