Professional Web Applications Themes

Simple Dumb Question - Null for Date/Time Field - Coldfusion - Advanced Techniques

using cf mx ms sql 2000. i have an update form that contains a field for date a procedure was signed. the problem is if the procedure was not signed, the user doesn't enter anything into the date field. but when they click the update button the update query inserts 1900-01-01 00:00:00 into the field in the db....

  1. #1

    Default Simple Dumb Question - Null for Date/Time Field

    using cf mx ms sql 2000. i have an update form that contains a field for date a
    procedure was signed. the problem is if the procedure was not signed, the user
    doesn't enter anything into the date field. but when they click the update
    button the update query inserts 1900-01-01 00:00:00 into the field in the db.

    Paulie579 Guest

  2. #2

    Default Re: Simple Dumb Question - Null for Date/Time Field

    inside the update query you could do something like this

    <cfif form.updateddate neq "">
    Updateddate = '#form.updateddate#'
    </cfif>
    only when updateddate is fill it would update the date field


    jorgepino Guest

  3. #3

    Default Re: Simple Dumb Question - Null for Date/Time Field

    thanks
    Paulie579 Guest

  4. #4

    Default Re: Simple Dumb Question - Null for Date/Time Field

    Another option would be to use the <CFQUERYPARAM> tag. Something like:

    <cfset updatedate_null = not IsDate(form.updatedate)>

    <cfquery>
    update Table
    set Updatedate = <cfqueryparma value="#form.updatedate#"
    null="#variables.updatedate_null#">
    where ...
    </cfquery>

    That way an actual "null" will be sent if form.updatedate is not a date.

    Hope this helps,
    Sean

    ssawka Guest

Similar Threads

  1. Get current date/time? Use them in hidden field?
    By EvolvedDSM in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 10th, 07:10 AM
  2. Syntax error when trying to update date/time field
    By hazalj in forum Coldfusion Database Access
    Replies: 3
    Last Post: January 31st, 10:17 PM
  3. Date/Time field default values!
    By RayBan12 in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: July 18th, 06:22 PM
  4. date & time in form field
    By dthatsme in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: March 11th, 06:18 AM
  5. Separated date and time or one datetime field
    By Krzysztof Piotrowski in forum PHP Development
    Replies: 0
    Last Post: April 24th, 07:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139