CREATE command in CFQUERY tag?

2004-10-06 Thread Adrienne Brown
Is it possible to execute code that creates a temporary table using a cfquery tag? Here's the code I'm trying to execute: CREATE TempTable AS (SELECT ENGINEER_SKILLS_ENGINEERS.ES_ENGINEERS_ID,  ENGINEER_SKILLS_SKILLSET.SKILLSET_ID,  ENGINEER_SKILLS_PROGRAMS.PROGRAM_ID,  ENGINEER_SK

Re: CREATE command in CFQUERY tag?

2004-10-07 Thread Michael Traher
I'm not an Oracle expert, but it is possible on most drivers/datasources to prohibit certain commands - i.e. when you run it thru SQL PLUS you have permission to run a CREATE command, but through you CF datasource it may be prohibitted. Just a thought. On Wed, 06 Oct 2004 14:53:30 -0400, Adrienne

Re: CREATE command in CFQUERY tag?

2004-10-07 Thread Janet Schmitt
The syntax is wrong.  It should be CREATE TABLE TempTable. Are you sure this ran okay when you cut and paste it into SQL*Plus? At 09:10 AM 10/7/2004 +0100, you wrote: >I'm not an Oracle expert, but it is possible on most >drivers/datasources to prohibit certain commands - i.e. when you run >i