You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-dev@jakarta.apache.org by ho...@apache.org on 2002/04/14 04:22:12 UTC
cvs commit: jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql UpdateTagSupport.java QueryTagSupport.java
horwat 02/04/13 19:22:12
Modified: standard/src/org/apache/taglibs/standard/tag/common/sql
UpdateTagSupport.java QueryTagSupport.java
Log:
Set null parameter values to the SQL value NULL.
Bugzilla 7758
Revision Changes Path
1.15 +6 -1 jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql/UpdateTagSupport.java
Index: UpdateTagSupport.java
===================================================================
RCS file: /home/cvs/jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql/UpdateTagSupport.java,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- UpdateTagSupport.java 12 Apr 2002 22:36:29 -0000 1.14
+++ UpdateTagSupport.java 14 Apr 2002 02:22:12 -0000 1.15
@@ -280,7 +280,12 @@
if (parameters != null) {
for (int i = 0; i < parameters.size(); i++) {
// The first parameter has index 1
- ps.setObject(i + 1, parameters.get(i));
+ if (parameters.get(i) == null) {
+ ps.setNull(i + 1, java.sql.Types.NULL);
+ }
+ else {
+ ps.setObject(i + 1, parameters.get(i));
+ }
}
}
}
1.19 +6 -1 jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql/QueryTagSupport.java
Index: QueryTagSupport.java
===================================================================
RCS file: /home/cvs/jakarta-taglibs/standard/src/org/apache/taglibs/standard/tag/common/sql/QueryTagSupport.java,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- QueryTagSupport.java 12 Apr 2002 22:36:29 -0000 1.18
+++ QueryTagSupport.java 14 Apr 2002 02:22:12 -0000 1.19
@@ -315,7 +315,12 @@
if (parameters != null) {
for (int i = 0; i < parameters.size(); i++) {
// The first parameter has index 1
- ps.setObject(i + 1, parameters.get(i));
+ if (parameters.get(i) == null) {
+ ps.setNull(i + 1, java.sql.Types.NULL);
+ }
+ else {
+ ps.setObject(i + 1, parameters.get(i));
+ }
}
}
}
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>