Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, December 04, 2008   
Data Springs Product Forums...
Subject: Demo 13 error
Prev Next
You are not authorized to post a reply.

Author Messages
David
Posts:27
going with the flow
going with the flow

06/04/2008 9:21 AM  

I am getting the following error from the Reports module when doing Demo 13 from your website. Please help.

There was an error while executing the configured data source: There is an error in your SQL at line 3: Incorrect syntax near 'go'. The variable name '@ModuleID' has already been declared. Variable names must be unique within a query batch or stored procedure. Incorrect syntax near 'varchar'.

Chad
Posts:2271
river guide
river guide

06/04/2008 9:46 AM  
Hmmm... Are you getting this error on our site directly or when you try and implement the module on your site?
David
Posts:27
going with the flow
going with the flow

06/04/2008 10:27 AM  
When I do it on my site.
One other note - the last error, "Incorrect syntax near 'varchar'" is because (it appears) the text field in the Reports module for the script is limited in the number of characters it will accept. It is cutting off about the last 6 lines.
Chad
Posts:2271
river guide
river guide

06/04/2008 11:47 AM  
Well, are you calling the stored procedure from within the Reports module or are you actually executing the SQL there? Did you already create the stored procedure directly under Host, SQL? You probably need to modify that stored procedure slightly as I see now it shows a static module ID of 1113 which represents our form instance and not yours probably.

I would first create the stored procedure (replace 1113 in that stored procedure with @ModuleID) and then I would test executing it directly under Host, SQL before you move it into the reports module etc...

You are not authorized to post a reply.



ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement