Hi,
I was looking over your stored procs and I see there is a way to pull responses by userid (with questionid) or by just question id.
I would like to suggests new option for an upcoming release.
I am trying to pull some of the dynamic profile data (not attached to the core fields) and I don't want to hard code the question id, since I will be testing on my dev server and don't want to have to change my module code when moving to the live site since the Question ID will be different.
So, I have writting my own SQL pull, which gets data based on the user id and the "shortfieldname" of the question.
Personally I think this should be included with your module.
Here is my example:
"select Q.DynamicQuestionID, Q.Question, R.Response from dbo.DynamicRegistration_Question AS Q
left
outer join dbo.DynamicRegistration_QuestionResponse AS R
ON
Q.DynamicQuestionID = R.DynamicQuestionID
where
Q.ShortFieldName = 'Title' and R.UserID = 3 And R.InActive=0"
Just a thought though, obviously you can ignore it :-)
Thanks!
Gary