Ask a Question related to Coldfusion Database Access, Design and Development.
-
kishoreb #1
creating dynamic table in oracle
Here is the bit causing problems:
create table tempTAble (case_id) as
SELECT case_id from feedback where feedback.status=1
Its giveing me the follwing error
Oracle JDBC Driver]ORA-01027: bind variables not allowed for data definition
operations
the query perfectly works in TOAD, is there any limitation on creating dynamic
tables using CF
thanks
kishore
kishoreb Guest
-
Creating an Oracle Datasource
I am trying to create an Oracle Datasource under CF MX7 Standard Edition. I selected other and used the JDBC URL and Driver Class of: ... -
Oracle Table Access With Oracle OLEDB Driver
If I use the Oracle client to access the Oracle database with DW 2004, it does not display any tables. If I use the Microsoft client it does work. ... -
creating a dynamic table with subcategories
Hello, I am trying to organize videos by date and category. I want it to look like this: June 9th 2004 Animals -funny cat on roof - dog... -
How to create a table with dynamic table name
<html><div style='background-color:'><DIV> <DIV class=Section1> <P class=MsoNormal style="mso-layout-grid-align: none"><FONT face="Times New Roman"... -
Dynamic Table with Dynamic LinkButtons
Looks like I'm not the only one to come across this. Found a post 9 months old that deals with the same thing. Here's the fix: Add line:... -
CF_Oracle #2
Re: creating dynamic table in oracle
Just do this:
create table tempTAble as
SELECT case_id from feedback where feedback.status=1
CF_Oracle Guest



Reply With Quote

