Professional Web Applications Themes

Insert/Update/Add - Coldfusion Database Access

I want to setup free envornment within microsoft access in permission and security, because I can retrive data for display but I have error when I try to insert/update/. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] You tried to assign the Null value to a variable that is not a Variant data type. How can I sollve this?...

  1. #1

    Default Insert/Update/Add

    I want to setup free envornment within microsoft access in permission and
    security, because I can retrive data for display but I have error when I try to
    insert/update/.
    Error Executing Database Query.
    [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
    Access Driver] You tried to assign the Null value to a variable that is not a
    Variant data type.
    How can I sollve this?

    ysurati01 Guest

  2. #2

    Default Re: Insert/Update/Add

    Doesn't look like a permissions problem to me. Looks more like an attempt to
    assign null to a field that is declared not null.

    To test further, create a new table with one field. Allow null values. Try
    to insert a record using cold fusion.

    Dan Bracuk Guest

Similar Threads

  1. insert,update url_id
    By kabbi~thkek in forum Coldfusion Database Access
    Replies: 4
    Last Post: October 1st, 07:07 PM
  2. Excel UPDATE and INSERT
    By talon1976 in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 12th, 08:55 PM
  3. Insert and Update using ASP/JS Mx v4
    By messiah944 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: March 15th, 06:25 AM
  4. SQL Update, Insert and Delete
    By Lou in forum ASP Database
    Replies: 1
    Last Post: June 22nd, 07:33 PM
  5. INSERT or UPDATE
    By Bingo in forum ASP Database
    Replies: 7
    Last Post: July 31st, 06:55 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