Changeset 496

Timestamp:

10/02/09 15:32:00 (15 years ago)

Author:

bhilburn

Message:

Fixing SQL comma splice.

Files:

• vtcross/trunk/src/include/vtcross/cbr.h (modified) (2 diffs)

vtcross/trunk/src/include/vtcross/cbr.h

@@ -132 +132 @@
     command = "CREATE TABLE " + tablename + "(";
     for(size_t i = 0; i < numColumns; i++) {
-        command += _cols[i] + " FLOAT ";
+        command += _cols[i] + " FLOAT";
 
         /* If this column is not the last entry, add a comma to the command in
@@ -162 +162 @@
     command = "CREATE TABLE " + tablename + "(";
     for(size_t i = 0; i < numColumns; i++) {
-        command += _cols[i] + " FLOAT ";
+        command += _cols[i] + " FLOAT";
+
+        /* If this column is not the last entry, add a comma to the command in
+         * preperation for the next entry. */
+        if(j != _primlen - 1)
+            command += ", ";
     }