diff options
| author | jakefeasel <jfeasel@gmail.com> | 2013-06-28 13:39:49 -0700 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2013-06-28 13:39:49 -0700 |
| commit | ebda11ade3168cf7b1707c2225c8085d42c44589 (patch) | |
| tree | b3783395c0b1e9890184c1f64e69ab81acf816b0 | |
| parent | a7220349d8ccc0254d0eeca92a8896aad54ea3e6 (diff) | |
| download | sqlfiddle-ebda11ade3168cf7b1707c2225c8085d42c44589.zip sqlfiddle-ebda11ade3168cf7b1707c2225c8085d42c44589.tar.gz sqlfiddle-ebda11ade3168cf7b1707c2225c8085d42c44589.tar.bz2 | |
Fixing the column query too
| -rw-r--r-- | src/main/webapp/models/Schema_Def.cfc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/webapp/models/Schema_Def.cfc b/src/main/webapp/models/Schema_Def.cfc index b2f44f9..281d031 100644 --- a/src/main/webapp/models/Schema_Def.cfc +++ b/src/main/webapp/models/Schema_Def.cfc @@ -114,7 +114,7 @@ <cfif db_type.simple_name IS "Oracle"> <cfquery datasource="#this.db_type_id#_#this.short_code#" name="local.columnsList"> - SELECT column_name, data_type as type_name, DATA_LENGTH as column_size from all_tab_columns where owner = Upper(<cfqueryparam value="user_#this.short_code#" cfsqltype="cf_sql_varchar">) + SELECT column_name, data_type as type_name, DATA_LENGTH as column_size from all_tab_columns where owner = Upper(<cfqueryparam value="user_#this.db_type_id#_#this.short_code#" cfsqltype="cf_sql_varchar">) AND table_name = <cfqueryparam value="#table_name#" cfsqltype="cf_sql_varchar"> </cfquery> |