Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveySurvey 04.00.70 with DNN 4.5.1 accepts only single submitionSurvey 04.00.70 with DNN 4.5.1 accepts only single submition
Previous
 
Next
New Post
5/9/2007 4:14 AM
 

I  started using  the DNN 4.5.1, it is totaly great, but I had problem with the survey module. 

 When I add a question with a  "single selection", the survey accepts only one submistion.  I tried from many computers with deffirent IP's and freed  the cache but never succeed, the selected answer  accepts only one submission as maximum. For example, I made survey with the asnwer: excellent, good, bad. The situation is like this: Excellent (1 vote) - good (1 Vote) bad (1 vote), inspite that more that 100 persons particpated in this survey.

Any body can help please.

Thanks,

Marwan

 
New Post
5/9/2007 7:45 AM
 

It's  a bug. I logged it:

http://support.dotnetnuke.com/issue/ViewIssue.aspx?id=5632

I will fix it in the next week. For now you can log in as host, go to SQl and run this script:

 

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}AddSurveyResult]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure {databaseOwner}{objectQualifier}AddSurveyResult

GO

create procedure {databaseOwner}{objectQualifier}AddSurveyResult

@SurveyOptionID int,

@UserID int

as

update {objectQualifier}SurveyOptions

set Votes = Votes + 1

where SurveyOptionID = @SurveyOptionID

insert into {objectQualifier}SurveyResults ( SurveyOptionID, UserID )

values ( @SurveyOptionID, @UserID )

 



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
5/9/2007 12:39 PM
 

Thanks Adefwebserver, 

I run the scripts ( Host - SQL), it worked 100%. I have not problem now.

You stated that you will fix the problem by the next week. Have I to install the new survey version? or this is enough and ended the problem?

Thanks for the great help

Regards,,

Marwan

 
New Post
5/9/2007 1:26 PM
 

When the new survey comes (version 04.00.80 or higher) out you will just install it and then run the script at the end of this post and you will be set. Right now if you set the survey to be one vote per user, a user can vote twice for the same choice.

When the new survey comes out (it may take 3 weeks to go through the release process) it will prevent this and also fix the bug you found.


if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}AddSurveyResult]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
 drop procedure {databaseOwner}{objectQualifier}AddSurveyResult
GO

/** Create Stored Procedure **/
create procedure {databaseOwner}{objectQualifier}AddSurveyResult @SurveyOptionID int, @UserID int as
DECLARE @i int
Set @i = (SELECT COUNT(*) AS records
FROM {objectQualifier}SurveyResults
 WHERE (UserID = @UserID) AND (SurveyOptionID = @SurveyOptionID))

 if (@i = 0)
begin
update {objectQualifier}SurveyOptions set Votes = Votes + 1
 where SurveyOptionID = @SurveyOptionID
 insert into {objectQualifier}SurveyResults (SurveyOptionID, UserID)
 values (@SurveyOptionID, @UserID)
 end



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveySurvey 04.00.70 with DNN 4.5.1 accepts only single submitionSurvey 04.00.70 with DNN 4.5.1 accepts only single submition


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out