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!

Pulling multiple SQL values in one SQL statement
Last Post 04-02-2009 08:11 PM by Tim Johnston. 13 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Tim JohnstonUser is Offline
wading in the water
wading in the water
Posts:16
Avatar

--
03-09-2009 06:04 AM

    I guess this is more of a feature request, but having a bunch of SQL tokens is ineffecient.

    Do you think you can add the ability of either allowing statically defined labels/columns to be used (like the DSParam1, SPParam2 etc) from a single SQL statement pulling multiple columns or even better, being able to define tokens at the SQL column level, so a page with 12 items of data only calls the db once instead of 12 times..

    Thanks, TJ

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-14-2009 06:22 PM
    Tim,

    Hi. We have an updated version of Tailored Text/HTML coming out probably around 4/1 (about 80% coded but following the new versions of Dynamic Login and Dynamic USer Directory this week).

    Anyway, there are several new features including the ability to pull in extended fields within DNN and also the ability to use a SQL Binding feature seperate from the standard SQL token feature (or use a combination). With this new feature you can pull in a single row of data and columns all at one time similar to Dynamic Forms etc...

    -Chad
    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-15-2009 09:22 AM

    Sounds good, any hints on whats coming out with the new versions of login & directory? I'm working on a directory myself but what with some of the limitations of the module(s) I'm bouncing back and forth between using Ventrian Propery Agent, Dynamic Directory & Tailored text or a hybrid between them both...

    TJ

    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-15-2009 05:44 PM

    I also think I've found a bug in Tailored Text, it seems like when the module searches the DataSprings_TailoredHTMLToken table, it's only searching for a match on the Token Name and not honoring the module id it was defined in, consequently if you have used the same token name in multiple modules it finds and uses the first one it comes across...

    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-23-2009 08:14 AM

    Any word on the new version release now that login & directory have been released? Also will the bug listed above be fixed in the new version? And finally, can you create an annoucements forum so we can subscribe to it - I have to keep checking back here and Snowcovered to check for updates / releases..

    Thanks, TJ

    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    03-23-2009 08:38 AM
    Hi Tim, Tailored Text is progressing nicely and is still scheduled for release on 4/1/2009. That's a good suggestion you made. We'll see what we can set up regarding announcements. Thanks! -- Candace
    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-23-2009 09:57 AM
    Will the unique token name bug be fixed in the next release (has it been confirmed as a bug)?

    TJ
    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    03-23-2009 12:59 PM

    Hi Tim.  I just installed the latest Tailored Text module on our test site, www.betasprings. com and wanted to invite you test it out there.  Please use host / dnnhost to log in and set up your own page using Tailored Text as the parent page.  We'd love to hear your feedback.  Thanks!

    Candace

    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-23-2009 07:57 PM
    I couldn't find the sql binding/multi-value feature as discussed in this thread, also when i tried to update profile fields with rich text (to test display in tailored text), it wouldn't stick (tried on a new user account as well as the admin). Aside from more default fields in the template, what has changed? Has the bug I reported been fixed?

    Thanks, TJ
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-24-2009 12:52 PM
    Tim,

    Hi. I did verify that the updated version was posted for the 2.1 beta and the SQL binding is there in settings, can you tell me what page you are testing on?

    -Chad
    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-25-2009 09:51 AM
    Goto http://www.betasprings.com/Tailored...fault.aspx it's entitled "Tims Tailored Text".

    If you pass a querystring var of "StaffID" with a value of 1 or 2 you'll see what I'm doing (just pulling user info), e.g. http://www.betasprings.com/Tailored...fault.aspx

    There is no mention or documentation as to how to pull multiple values at once, and I was unable to test displaying RTF text as when I tried to update any users profile field with rich text data it never saved...

    TJ
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-31-2009 11:19 AM
    Tim,

    Hi. Thanks for your feedback. We plan to have a fully released version of Tailored Text/HTML by the end of April (should be ready by the 15th but documentation sometimes takes about one week). Yes, we have not yet added documentation or details on the settings page for how to use the Initial SQL Databind feature (although it is there). Basically the way it works is that it will reference each column name from the SQL database query.

    For example, lets say you checked the box to enable initial SQL databind such as this:

    SELECT * FROM YourTable WHERE UserId=$(StaffID)


    And you had a querystring token (as you do) called StaffID. This would then pull in all of the column names from that table and for each column name, they could be referenced as $(ColumnName) within the Tailored Text. Initial Databind columns will not actually be listed in the Tailored Text/HTML module directly since they are very dynamic. But the good news is that you will not have to create SQL tokens for every single column you want to return (which is a headache!).

    -Chad
    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    03-31-2009 12:51 PM
    Good to know, thanks Chad. Has the Rich text/Html rendering issue been fixed in this release? i.e. displaying html that was written in Dynamic Registration or Forms? I really need that to work and I have a project due very soon that needs this to be working, otherwise I need to code around it... And if it has, do you think I could get hold of a pre-release in a week?

    Thanks, TJ
    Tim JohnstonUser is Offline
    wading in the water
    wading in the water
    Posts:16
    Avatar

    --
    04-02-2009 08:11 PM

    In addition to the above, can you also confirm the token name issue has been fixed in the new version (4th post in this thread, but here it is for clarity)... TJ

    I also think I've found a bug in Tailored Text, it seems like when the module searches the DataSprings_TailoredHTMLToken table, it's only searching for a match on the Token Name and not honoring the module id it was defined in, consequently if you have used the same token name in multiple modules it finds and uses the first one it comes across...

     

    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