Syntax for a SQL Token in Tailored Text module. > DotNetNuke Module Product Forums > Data Springs Inc.

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...

Engage: Publish 5.2

Content Workflow + Versioning + Categorization + Multiple Display Options = Truly Advanced DotNetNuke Content Management (Requires DNN 4.5.1 or later)

Ultra Video Gallery 2.4

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.

Opt In Email 4.0

'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

Open-DocumentLibrary v3.0

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.

Dynamic Forms 2.7

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 5.4

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.

Data Springs Collection 2.0 (20+ Modules)

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.

Document Exchange 5

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

Minimalist by Evan O'Neil - ALL NEW !

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 . . .

Data Springs Product Forums...

Unanswered Active Topics

Forums Search

Forums > Product Discussion - DotNetNuke Modules > Tailored Text/HTML

Subject: Syntax for a SQL Token in Tailored Text module.

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

Paul
Posts:23

going with the flow

01/21/2007 10:47 PM
I am trying to convert the text value of a series of Query strings sent from Dynamic Forms to the Tailored Text module. I tested the process through a stored procedure in SQL server, but the particular conversion piece is causing the tailored text module to crash, and the entire page fails to load. What I do is have a query string pass from the Dynamic form into the Tailored Text, $(Ques1). What I want to do is to use the answer (Yes or no) to convert into a 1 or 0 value. So what I did was create SQL token, $(N1) containing the following T-SQL snip: If $(Ques1) = 'Yes' BEGIN SET $(N1) = 1 END ELSE BEGIN SET $(N1) = 0 END I’m obviously missing an important part of what is needed for this, or maybe trying to set the value of a token based on another token can’t work. Any thoughts would be greatly appreciated.

Chad
Posts:2244

river guide

01/26/2007 8:51 AM
I will look into this and try and duplicate. The next version of Dynamic Forms will pass along a uniqueID though which should also help. With a uniqueID you will be able to retreive all of the forms responses directly from the ID (within Tailored Text/HTML) without having to pass all of the querystring variables. As far as your token, you might also try putting that in a stored procedure and then calling the stored procedure from the Tailored Text/HTML module instead. -Chad

You are not authorized to post a reply.

Forums > Product Discussion - DotNetNuke Modules > Tailored Text/HTML > Syntax for a SQL Token in Tailored Text module.

ActiveForums 3.7