jmcnally 02/05/20 15:06:48
Modified: src/templates/sql/load/db2400 val.vm
src/templates/sql/load/hypersonic val.vm
src/templates/sql/load/mssql val.vm
src/templates/sql/load/mysql val.vm
src/templates/sql/load/oracle val.vm
src/templates/sql/load/postgresql val.vm
src/templates/sql/load/sapdb val.vm
src/templates/sql/load/sybase val.vm
Log:
patch by Will Glass-Husain <[EMAIL PROTECTED]>
templates/sql/load/*/val.vm (changed for each database)
puts quotes around dates when inserting into a database with project-datasql.
Revision Changes Path
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/db2400/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/db2400/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 9 Jan 2002 15:39:09 -0000 1.1
+++ val.vm 20 May 2002 22:06:48 -0000 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR" )'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:05 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:05 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:04 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:04 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:04 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.2 +1 -1 jakarta-turbine-torque/src/templates/sql/load/sapdb/val.vm
Index: val.vm
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/templates/sql/load/sapdb/val.vm,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- val.vm 22 Feb 2002 22:25:09 -0000 1.1
+++ val.vm 20 May 2002 22:06:48 -0000 1.2
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
1.3 +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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- val.vm 19 Dec 2001 20:03:04 -0000 1.2
+++ val.vm 20 May 2002 22:06:48 -0000 1.3
@@ -1 +1 @@
-#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
+#if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR"||
$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>