Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Getting Values from SQL Query
Last Post 01-05-2010 12:56 PM by Chad Nash. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Wesley GelandUser is Offline
going with the flow
going with the flow
Posts:37
Avatar

--
02-16-2009 09:58 PM

    Hi Guys

    I've got DR installed on this portal with DUD and Tailored Text as well.

    What I am trying to do is. Have a list of Users on one side. This will be Dynamic User Directory and once you click on it. It populates the Tailored Text /HTML with the User Details that was clicked on, on the right. I got it working but only have the ID value displaying in the tailored text module.

    I need a SQL query that will allow me to pull User information with All properties that Dynamic Registration created. I know u dont know all the properties. But i just want to understand where i can pull them from?

    Lets say i have properties Firstname, lastname, age and country as Dynamic fields.

     

    Hope this mad sense.

    Thanks in advance.
    Wesley

     

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-17-2009 03:13 PM

    Check out the main user directory page.. Specifically links such as this which take you to the Tailored Text/Html page.

     

    http://www.datasprings.com/default....UserID=787

     

    -Chad

     

    Wesley GelandUser is Offline
    going with the flow
    going with the flow
    Posts:37
    Avatar

    --
    02-17-2009 09:01 PM

    Thanks Chad.

    I think I understand how it works now. So for each Custom Property I would have to create a SQL Token. I have quite a bit of properties and do not really want to pass it via the querystring token.

    So i would have to specify i.e Select Response from DynamicRegistrationQuestions..... where QuestionID = (The QuestionID of the property i want.) and UserID = the [UserID].

    I hope you understand what I mean.

    Thanks again
    Wesley

    Len QUser is Offline
    wading in the water
    wading in the water
    Posts:17
    Avatar

    --
    12-14-2009 06:29 AM
    This doesn't seem to be working for me. I have a form that sends values via querystring to a Tailored HTML module and nothing happens. I want to convert a checkbox value to verbatim text. So if checkbox 1 is marked then a SQL lookup to an answers file will display the verbatim on the Tailored Text page.
    The Tailored Text page has a Token $(Cal01) and has the SQL statement:
    SELECT Verbatim FROM co3_CalciumAnswersFile WHERE ShortName = 'cal01' AND Yes = $(cal01)

    The answers table (co3_CalciumAnswersFile) has the columns "ShortName," "Verbatim," and "Yes." The ShortName column has values matching the shortnames from the Dynamic Form the end user is filling out. The Verbatim column is what I want written on the Tailored Text page. The Yes column is all "yes" to verify which shortname is passed via the querystring.

    When I run the test nothing happens. What is the "right" way to do this? I will have about 20 fields like this.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    12-16-2009 06:36 AM
    HI, can you change your token name from "cal01" to "DSParam1" and see if this works?
    Note that you can only have three token variables for comparison / retrieval purposes (DSParam1,DSParam2,DSParam3) for your SQL queries so your query would look like this instead:

    SELECT Verbatim FROM co3_CalciumAnswersFile WHERE ShortName = 'cal01' AND Yes = '(DSParam1)'

    -- David
    Len QUser is Offline
    wading in the water
    wading in the water
    Posts:17
    Avatar

    --
    12-16-2009 07:20 AM
    found a work around late yesterday.

    I want to convert checkbox value (Yes) to verbatim text I store in a table (co3_CalciumAnswersFile). That table has 3 columns: ShortName, Yes & Verbatim. I always think in Excel and what I want to do is, 'if cal01 is checked then write text from verbatim else display nothing'. Therefore, if I pass the checkbox value as a Session Variable from the Dynamic Form, then in Tailored HTML I just need (2) tokens to convert the value. One is a Session Token and the other a SQL Token.

    Here is what I did:

    I passed the checkbox 'cal01' as a Session variable from a Dynamic Form and in Tailored HTML settings I made a Session Token called 'cal01' with the TokenKey 'cal01'. Then I made a SQL Token called 'calcium01' and the TokenKey of:

    SELECT Verbatim FROM co3_CalciumAnswersFile WHERE ShortName='cal01' and Yes = $(cal01)

    In Tailored HTML contents I added $(calcium01) for the SQL Token and got the verbatim text I was looking for.

    I am sure this could also be done with a Stored Procedure which is what I am working on now. It just took me a WEEK to figure out this step! If anyone knows the RIGHT way to do this (or a better way) PLEASE let me know!! I have about a thousand fields in this application I need to do this with!

    By the way, before I added the Session Token having just the SQL Token actually crashed the Web Server somehow!
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    12-16-2009 07:32 AM
    Strange that the SQL token would crash your web server. If you checked the Admin / Event Viewer log, does it give any detailed message as to why it would crash? -- David
    Len QUser is Offline
    wading in the water
    wading in the water
    Posts:17
    Avatar

    --
    12-30-2009 07:41 AM

    Sorry to respond so late, but the only thing in Event Viewer is 'Application Start' everyday beginning December 23, 2009 until today except for December 25.

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-05-2010 12:56 PM
    Len,

    Thanks for posting the solution you used. I am sure it will be very helpful for others. I would think you would need ' around the $(cal01) token unless it was an integer. I also think that Tailored Text/HTML and also Dynamic Forms binding requires that each column be brought it with a unique column name. Not sure if that mattered in your case but I spent some time working with a client on a problem and figured out it was because we were bringing in two columns with the same name into the query.

    -Chad
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi