Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • aaeda 117 posts 150 karma points
    Mar 06, 2018 @ 13:21
    aaeda
    0

    Error using Sql datasource

    Hello

    I am having an error message when using nuPicker: SqlDatasource. the SQL script is as follows: SELECT id, dataNvarchar FROM cmsPropertyData WHERE (propertytypeid = 206)

    And the error says: Incorrect syntax near 'dataNvarchar'

    Do you have any idea what's wrong?

    Thanks

    Copy Link
  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    Mar 06, 2018 @ 13:27
    Hendy Racher
    100

    Hi,

    The SQL DataSource expects a Key and a Label field in the result set - does the following work ?

    SELECT id AS 'Key', 
       dataNvarchar AS 'Label'
FROM cmsPropertyData
WHERE (propertytypeid = 206)
    Copy Link
  • aaeda 117 posts 150 karma points
    Mar 06, 2018 @ 15:00
    aaeda
    0

    Hello

    Yess! that worked..but it did not when I tried it before.

    Thanks a lot

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies