Anonymous

My feedback

  1. 103 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  2. 24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  3. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared this idea  · 
  4. 8 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  5. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
    Anonymous commented  · 

    I did a crude patch for MySql As Follows:

    public static int Save(T record)
    {
    var sqlToExecute = "";

    using (var Db = GetConnection())
    {

    try
    {
    var insertSQL = Db.ToInsertStatement(record);
    var updateSQL = Db.ToUpdateStatement(record);

    // strip out the UPDATE 'tablename' SET ....
    updateSQL = updateSQL.Replace(Db.GetQuotedTableName<T>(), "");
    updateSQL = updateSQL.Replace(" SET", "");

    // remove trailing WHERE <PK=Id>...
    updateSQL = updateSQL.Substring(0, updateSQL.IndexOf(" WHERE `"));

    //lastly something weird with nulls = '{}'
    sqlToExecute = (insertSQL + " ON DUPLICATE KEY " + updateSQL).Replace("'{}'", "NULL");

    Db.ExecuteSql(sqlToExecute);

    return 1;
    }
    catch (Exception e)
    {

    Log.Error(0, $"Error saving record, sql={sqlToExecute}", e);

    return -1;

    }
    }
    }

    Anonymous shared this idea  · 
  6. 129 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Feature Requests  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous commented  · 

    +1.. Cluster has been out 2 yrs...

Feedback and Knowledge Base