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 Brown
<[EMAIL PROTECTED]> wrote:
> Is it possible to execute code that creates a temporary table using a
> cfquery tag?
>
> Here's the code I'm trying to execute:
> <cfquery name="createTable" datasource="#db#">
> CREATE TempTable AS
>
> (SELECT ENGINEER_SKILLS_ENGINEERS.ES_ENGINEERS_ID,
> ENGINEER_SKILLS_SKILLSET.SKILLSET_ID,
> ENGINEER_SKILLS_PROGRAMS.PROGRAM_ID,
> ENGINEER_SKILLS_CERTIFICATION.CERTIFICATION_ID,
> ENGINEER_SKILLS_TRAINING.TRAINING_ID
> FROM ENGINEER_SKILLS_ENGINEERS
> INNER JOIN ENGINEER_SKILLS_SKILLSET ON
> ENGINEER_SKILLS_SKILLSET.USR_USER_ID = ENGINEER_SKILLS_ENGINEERS.USR_USER_ID
> LEFT JOIN ENGINEER_SKILLS_PROGRAMS ON
> ENGINEER_SKILLS_PROGRAMS.SKILLSET_ID = ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> LEFT JOIN ENGINEER_SKILLS_CERTIFICATION ON
> ENGINEER_SKILLS_CERTIFICATION.SKILLSET_ID =
> ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> LEFT JOIN ENGINEER_SKILLS_TRAINING ON
> ENGINEER_SKILLS_TRAINING.SKILLSET_ID = ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> WHERE ES_ENGINEERS_ID = 1)
> </cfquery>
>
> This code runs just find when I copy and paste into SQL Plus, but when I put
> it in a cfquery tag, I get the following error:
>
> Error Executing Database Query. [Macromedia][Oracle JDBC
> Driver][Oracle]ORA-00901: invalid CREATE command
>
> I find it interesting that I'm not getting a Coldfusion error, which leads
> me to believe that I *should* be able to run this code. Or am I just
> crazy?________________________________
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
