I quick edited the response on my way out of the office last night and just wanted to get the post out there. The actual code does NOT end in a comma, rather it has 12 fields instead of 3. I was attempting to make this easier to read. I am forced to do this from a CF document because I am attempting to have an automatic table creation if a user has not yet created a table for themselves. Thus, the first time they log into the particular system, a table gets created and sequenced and triggered. So apart from attempting to do this in a hurry, can any one suggest feedback?
-----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 6:29 PM To: CF-Talk Subject: RE: Trigger and Sequences Last I knew you couldn't end a CREATE TABLE command with a comma.... Why in the world are you doing this from CF??? -----Original Message----- From: Langford, Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 4:40 PM To: CF-Talk Subject: Trigger and Sequences Hi all, I am trying to create a table on a CF page and then create a sequence and a trigger on the same page. Every time I try to run the page the page times out and kills my server to boot. Which is no fun. Here is the basic stuff <cfquery name="two" datasource="ncc"> create table #answtable# ( FLDUNIQUE_ID number(10), FLDID number(11), FLDFIRSTNAME varchar(50), FLDLASTNAME varchar(50), </cfquery> <cfquery name="three" datasource="ncc"> create sequence #answtable#_ID_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE CACHE 20 </cfquery> <cfquery name="four" datasource="ncc"> create or replace trigger BI_#answtable# before insert on #answtable# for each row begin select #answtable#_ID_SEQ.nextval into :new.FLDUNIQUE_ID from dual; end; </cfquery> Any Suggestions? Bryan Langford Web Info Specialist National Customer Operations Enterprise Services & Strategic Planning Training Development and Design Team. Desk: 714-695-4824 Cell: 714-270-8451 <?import namespace = t urn = "urn:schemas-microsoft-com:time" implementation = "#default#time2" declareNamespace /> ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
