Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Bjarne Fyrstenborg 1141 posts 3234 karma points MVP 3x c-trib
    Mar 06, 2014 @ 16:15
    Bjarne Fyrstenborg
    0

    Didn't recieve results in dropdown

    Hi..

    I tried your package in Umbraco v. 7.0.4, but I could get it working to list the results in the dropdown..

    I have a table "people" with columns: id, name, address, email, bio ...

    I am using a SQL Compact database for this local install and when a use the sql in WebMatrix I get the two colums id and name: SELECT id AS Value, name AS Text FROM people

    I am not sure if it require the aliases to be "Value" and "Text" since the html file use this?
    <select ng-model="model.value" ng-options="c.Value as c.Text for c in sqlResult"></select>

    I just get this result:
    <select ng-model="model.value" ng-options="c.Value as c.Text for c in sqlResult" class="ng-pristine ng-valid"> <option value="?" selected="selected"></option>
    </select>

    and a 500 internal server error from the /umbraco/backoffice/SqlDropDownList/SqlDropDownList/ExecuteSql

    )]}',
    {"Message":"An error has occurred.","ExceptionMessage":"Keyword not supported: 'flush interval'.","ExceptionType":"System.ArgumentException","StackTrace":"   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)\r\n   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)\r\n   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)\r\n   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)\r\n   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)\r\n   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)\r\n   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)\r\n   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)\r\n   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)\r\n   at tada.umbV7DataTypes.SqlDropDownList.SqlDropDownListController.ExecuteSql(Object sqlPassed)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4()\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

     

    /Bjarne

  • Zac 232 posts 511 karma points
    Mar 06, 2014 @ 16:23
    Zac
    0

    Hi Bjarne,

    I haven't tested it on anything but SQL Server, so I'm guessing the issue is with SQL Compact.  I have it working on a few installs with SQL Server 2008 and 2012 on v7.0.4 and 7.0.2.

    You don't need to alias the SQL, it will just take the first two fields and use them in the dropdown.  I'll see if I can check it out on SQL Compact sometime and resolve.

     

  • Bjarne Fyrstenborg 1141 posts 3234 karma points MVP 3x c-trib
    Mar 06, 2014 @ 16:32
    Bjarne Fyrstenborg
    0

    Okay :)

    Yes, it might be something, which is not supported with SQL Compact..

    Another thing I was thinking of when the values are listed in the dropdown.. maybe there should be an option the the settings/configuration to choose if you want a default item in the dropdown.. there might be cases where it should be optional to the editors if they want to choose one if the values..

  • Zac 232 posts 511 karma points
    Mar 06, 2014 @ 16:53
    Zac
    0

    Thanks Bjarne.

    Great idea with the default item, I'll look at adding that.

  • Zac 232 posts 511 karma points
    Mar 15, 2014 @ 21:25
    Zac
    100

    Hey Bjarne,

    I uploaded an updated version of the drop down list that should work with SQL compact.  It now uses Peta POCO for the query.  

    I also added options to pre set the selected value and you can now pass in the page id (like you could in uComponents).

    Let me know if it works for you in SQL compact.  Note that you now need to name the fields as Value and Text (previously you didn't need to).

    Thanks

    Zac

  • Bjarne Fyrstenborg 1141 posts 3234 karma points MVP 3x c-trib
    Mar 16, 2014 @ 00:25
    Bjarne Fyrstenborg
    0

    Hi Zac

    It now seems to work great with SQL Compact too :) .. and great to have an option to select the default item..

    Actually I meant with the default was like in Umbraco v4 and v6 go back to select the item "Choose..." and similar in Umbraco v7. However I find that it more seems to be an Umbraco behavior .. and in v7 after you have saved your node the "default" blank item dissapear and you can't select it back to let it be empty/blank like you could in v4 and v6.

    I have created an issue here: http://issues.umbraco.org/issue/U4-4450

    /Bjarne

Please Sign in or register to post replies

Write your reply to:

Draft