Copied to clipboard

Flag this post as spam?

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


  • aaeda 104 posts 136 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

  • Hendy Racher 859 posts 3821 karma points MVP 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)
    
  • aaeda 104 posts 136 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

Please Sign in or register to post replies

Write your reply to:

Draft