HomeHomeDotNetNuke Forg...DotNetNuke Forg...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 1: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 4: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 9:39 AM
 

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 10:26 AM
 

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
HomeHomeDotNetNuke Forg...DotNetNuke Forg...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


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

Attend A Webinar
Free Demo Site
Download DotNetNuke Professional Edition Trial
Have Someone Contact Me
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

DotNetNuke Scoop!

Sponsors

DotNetNuke Corporation

DotNetNuke Corp. is the steward of the DotNetNuke open source project, the most widely adopted Web Content Management Platform for building web sites and web applications on Microsoft. Organizations use DotNetNuke to quickly develop and deploy interactive and dynamic web sites, intranets, extranets and web applications. The DotNetNuke platform is available in a free Community and subscription-based Professional and Enterprise Editions with an Elite Support option. DotNetNuke Corp. also operates the DotNetNuke Store where users purchase third party apps for the platform.