Ask a Question related to Coldfusion Database Access, Design and Development.

  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. Similar Questions and Discussions

    1. Excel UPDATE and INSERT
      Hi, I'm tryin to update/insert data into an excel datasource using CFMX7, had no problems using CF6 cause of the direct link to excel, butnow i am...
    2. Insert and Update using ASP/JS Mx v4
      Hi, Does anyone successfully done a insert into table A and at the same time update to table B using the same form X? I'm using ASP/JS on MX 4....
    3. SQL Update, Insert and Delete
      Why do I get the message "Operation must use an updateable query" on an Update, Insert and Delete. Mind you the site worked fine before a recent...
    4. IIS Hangs on Update or Insert from ASP
      I am having the following issue with IIS/ASP. Setup: Windows 2000 SQL Server 2000 IIS 5.0 (All running on same machine.) For some reason,...
    5. INSERT or UPDATE
      Hi there. I have this problem here : I want to insert a record if it does not already exist, or to update it if it does (based on index of...
  3. #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

Posting Permissions

  • You may not post new threads
  • You may 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