Dynamic SQL: cannot write to MYSQL
Last Post 11-06-2012 11:24 AM by Ryan Bakerink. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Rob NiessenUser is Offline
skipping stones
skipping stones
Posts:7
Avatar

--
07-13-2012 06:44 AM
    Hi,

    I am running DNN 5 .x on MSSQL
    with DF : 3.40.50

    I am trying, without success, to write to MY-SQL using completion event Dynamic SQL.


    Keep getting this error:

    "Non-negative number required. Parameter name: count"

    Using cn:
    Server=10.11.10.54,3307;database=Kopie;UID=User;Pwd=pwd;Connection Timeout=900;

    sql:
    INSERT INTO  tblDynamicFormsResults
    (
    [Remarks]
    )
    VALUES 
    (
    'rob'
    )


    Any ideas?
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    11-06-2012 11:24 AM
    Hello Rob,

    It sounds like you may have a CHECK Constraint on your SQL Table "tblDynamicFormsResults". You're trying to insert only into the Remarks column, but if there is a CHECK Constraint, perhaps it's not happy that you're not providing a value for the CHECK Constraint column.

    Thanks,

    Ryan


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi