Friday, February 10, 2012
  Search
Support Forum
This might be an issue or I did something wrong.
Last Post 25 Mar 2007 10:22 PM by Steve Provencher. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Trevor
New Member
New Member
Send Private Message
Posts:5


--
21 Mar 2007 04:53 AM  

If you create a new page in the dnn portal and add an existing module (Form Master 1.5) to the page so it is a reference of the original form.  It causes the files to show as a duplicate.  If you remove the form from the page.  And go back to see the files it shows correctly.

Is this a quick fix?

e.g. Page 1                               New Page
Form Master 1         Reference ->Form Master 1 on Page 1

Shows Files as
ID  File name
1    test.txt
1    text.txt

Remove the refernece on the new page and it fix's the issue.

Steve Provencher
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:681


--
21 Mar 2007 10:42 AM  
I will look into it
Steve Provencher
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:681


--
25 Mar 2007 10:22 PM  

Go to Host --> SQL. Paste the SQL below into the textbox and check the "Run as Script" checkbox then click "Execute" the duplicates will be gone. This will be in the next update.

ALTER PROCEDURE {databaseOwner}[{objectQualifier}C5SLLC_FormGetFilesByModuleId]
@ModuleId int
AS
SELECT
[FileDataId],
[FormDataId],
[PortalId],
[ModuleId],
[ControlId],
[ContentType],
[ContentLegth],
[FilePath],
[OrigFileName],
[FileName],
[InDB],
[CreatedByID],
[CreatedDate],
[LastModifiedByID],
[LastModifiedDate]
FROM
{databaseOwner}[{objectQualifier}C5SLLC_FormFileData]
WHERE
[ModuleID] = @ModuleId
ORDER BY
[OrigFileName]

You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.