Copied to clipboard

Flag this post as spam?

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

  • Peter Alcock 113 posts 176 karma points
    Nov 07, 2019 @ 10:58
    Peter Alcock

    NuPickers SQL Label

    Hi all,

    I am trying to access a value from an external database hopefully using nupickers!

    I have created a datatype sql label, the connection string i need is in there fine. I have used the following query string

    SELECT [REGT_Minutes_Present] AS 'Key', [address] AS 'Label' FROM [dbo].[CID_Attendance]

    In a normal situation i would want the query to be something like

    Select REGTMinutesPresent from CIDAttendance where REGTStudent_ID = umbraco node property field containing student ID which is named studentID

    Hope that makes sense and hope someone can help!

    Essentially i have a node for each student and i want a field that displays their attendance which is taken from an external database.

Please Sign in or register to post replies

Write your reply to: