Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Peter Cort Larsen 421 posts 1038 karma points
    Jan 20, 2015 @ 20:32
    Peter Cort Larsen
    0

    SQL

    Hi,


    I Can't get the SQL pickers to work (Havent tried the others yet).

    Could it be because webforms is used?

    Using for example the nuPickers.SqlDropDownPicker, just gives me an empty select tag.


    And thanks for your work.


    Copy Link
  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Jan 21, 2015 @ 10:44
    Hendy Racher
    0

    Hi Peter,

    If you're using Umbraco v7.1 or above then all the nuPickers should work.

    Can you post your config for your SQL DropDown Picker ?

    Hendy

    Copy Link
  • Peter Cort Larsen 421 posts 1038 karma points
    Jan 21, 2015 @ 12:48
    Peter Cort Larsen
    0

    HI,

    Thanks for your answer.

    I have this setup: enter image description here

    This is when testing a nuPickers.SqlCheckBoxPicker. Its the same problem.

    I use 7.2.1

    Copy Link
  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Jan 21, 2015 @ 12:54
    Hendy Racher
    100

    Hi Peter,

    The SQL expression needs to return a result set containing 'Key' and 'Label' fields, does it work if you change your SQL to:

    SELECT [caseno] AS 'Key', [address] AS 'Label' FROM [dbo].[properties]

    HTH,

    Hendy

    Copy Link
  • Peter Cort Larsen 421 posts 1038 karma points
    Jan 21, 2015 @ 13:02
    Peter Cort Larsen
    1

    Yep, that was it, must have missed that read.

    Thanks.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft