mpoeschl 01/12/19 12:03:05
Modified: src/templates/sql/load/sybase val.vm
src/templates/sql/load/postgresql val.vm
src/templates/sql/load/oracle val.vm
src/templates/sql/load/mysql val.vm
src/templates/sql/load/mssql val.vm
src/templates/sql/load/hypersonic val.vm
Log:
Seems the Torque is not quoting LONGVARCHAR's in any of the val.vm
templates. This patch was created off of the val.vm from the MySQL profile.
However, val.vm appears to be generic enough that this patch could be
applied to all db's with no re-write.
patch by Scott Weaver <[EMAIL PROTECTED]>
Revision Changes Path
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/sybase/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/sybase/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/12/14 22:14:06 1.1
+++ val.vm 2001/12/19 20:03:04 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
\ No newline at end of file
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/postgresql/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/postgresql/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/10/27 19:06:17 1.1
+++ val.vm 2001/12/19 20:03:04 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
\ No newline at end of file
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/oracle/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/oracle/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/12/07 08:02:26 1.1
+++ val.vm 2001/12/19 20:03:04 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/mysql/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/mysql/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/08/02 05:08:40 1.1
+++ val.vm 2001/12/19 20:03:04 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
\ No newline at end of file
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/mssql/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/mssql/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/10/27 19:06:17 1.1
+++ val.vm 2001/12/19 20:03:05 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
\ No newline at end of file
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/hypersonic/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/hypersonic/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 2001/10/27 19:06:17 1.1
+++ val.vm 2001/12/19 20:03:05 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR")'$column.Value'#else$column.Value#end
\ No newline at end of file
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
