Changeset 323 for trunk/bin

Timestamp:

Apr 24, 2008 5:53:05 AM (16 years ago)

Author:

quinn

Message:

CSS fixes for admin2.inc.css, fixed preselectd but in printSelectForm.

File:

• trunk/bin/module_maker/sql.cli.php (modified) (1 diff)

trunk/bin/module_maker/sql.cli.php

@@ -75 +75 @@
             $c[$field] = "'\" . isset(\$frm['$field']) . \"'";
         } else if ('added_by_user_id' == $field || 'modified_by_user_id' == $field) {
-            // Toggle types.
+            // Expects a user_id.
             $c[$field] = "'\" . \$db->escapeString(\$auth->get('user_id')) . \"'";
         } else if ('added_datetime' == $field || 'modified_datetime' == $field) {
             // DB record insertion datetime.
             $c[$field] = "NOW()";
+        } else if (preg_match('/date_|_date/', $field)) {
+            // This is a date field. Convert to SQL date.
+            $c[$field] = "'\" . \$db->escapeString(strToSQLDate(\$frm['$field'])) . \"'";
         } else {
             // Default. Just insert data.