Can someone please tall me why this will not work? The first piece of code tries to create a table New. The second piece trys to set the primary key. However, it does not even make it past the create table query. Thanks for any input in helping me create new tables. I cannot use a custom tag for this. <!--this creates the table and fields--> <cfquery name="createtable" datasource="expansions"> CREATE TABLE NEW (id INTEGER NOT NULL, Quantity INTEGER NULL, Price DECIMAL(8,2) NULL, CardName CHAR(75) NULL, Name CHAR(50) NULL); </cfquery> <!--this sets the primary key--> <cfquery name="create_pk" datasource="expansions"> CREATE UNIQUE INDEX OID_IDX ON New (id); </cfquery> Jordan ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
