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.