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


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

    Error using Sql datasource

    Questions/Suggestions
    Umbraco 7

    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
Please Sign in or register to post replies

Write your reply to:

Draft