Professional Web Applications Themes

Help with updating in SQL - Coldfusion Database Access

Removed by Administrator...

  1. Moderated Post

    Default Help with updating in SQL

    Removed by Administrator
    HongKongSunny Guest
    Moderated Post

  2. #2

    Default Re: Help with updating in SQL

    Just a guess, but you may be trying to insert a text value into a numeric
    field. For example, WHERE MemberID = '1': is MemberID really a text field?
    Also, it might be that 'false' should have the single quotes removed, depending
    upon how the fields are defined in the database.

    jdeline Guest

  3. #3

    Default Re: Help with updating in SQL

    Looks like you missed RelationShip2 (see in your code RelationShip1 = '#Form.Relationship2#'). Then if this is the case and RelationShip2 is NOT NULL field then it throw an error.
    CF_Oracle Guest

Similar Threads

  1. Updating Updating site map or archive dynamically
    By RooZam in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: September 15th, 04:45 PM
  2. CSS Not Updating
    By emersonbsmh in forum Macromedia Contribute General Discussion
    Replies: 2
    Last Post: August 16th, 04:24 PM
  3. Updating 3.0 to 3.1. Or not.
    By tim in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: June 18th, 03:02 AM
  4. Updating AI Files causes position to 'bounce' when updating in Quark
    By Chris_Tod@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: May 6th, 07:29 PM
  5. Updating from 9
    By Derrick Bettiss in forum Macromedia Freehand
    Replies: 4
    Last Post: April 6th, 07:39 AM

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