Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Joining Question & Results Tables to get responses
Last Post 01-10-2008 05:40 AM by Jereme Downs. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Jereme DownsUser is Offline
Posts:4
Avatar

--
01-09-2008 01:47 PM

    I am trying to find how to join the dynamicforms_question and dynamicforms_questionresponse tables so I can determine what questions the answers are related to. I found a previous post by Chad that uses a DynamicQuestionID field, but I don't have this in either of these two tables. I'm running Dynamic Forms v2.30.70 and DNN v4.06.02

    Thanks,
    Jereme
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-09-2008 08:22 PM
    Hi. I believe there should be a DynamicQuestionID in both of those tables but if you view the column in DotNetNuke (under host, SQL) that feature of DNN does not have the ability to display GUID columns. You will need to cast or convert the column to nvarchar or use something like SQL Query Analyzer / SQL management studio.
    Jereme DownsUser is Offline
    Posts:4
    Avatar

    --
    01-10-2008 05:40 AM

    I was using the SQL tool under Host. Casting this field to varchar did the trick. I didn't have direct access to the DB at the time, so I was forced to use the built-in SQL query tool. Thanks Chad!

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi