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!

Multiline/Rich Text Truncated
Last Post 02-19-2008 08:25 AM by Chad Nash. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
James MotleyUser is Offline
wading in the water
wading in the water
Posts:19
Avatar

--
07-30-2007 04:18 PM

    I  am using the the Rich Text editor for a Biography field and it is getting truncated after just a few lines of text. I saw a post about setting the field length in the database, but it already shows NVarChar 3000 in there. What's going on? My version is 3.0.

    James MotleyUser is Offline
    wading in the water
    wading in the water
    Posts:19
    Avatar

    --
    07-31-2007 12:25 PM

     

    FYI - Here has been my experience with trying to work around this issue:

    1 - I tried changing the NVARCHAR on the UpdateDynamicResponse from 300 to 3000 and it allowed me to save the larger text data from my Rich Text field which I had setup for a user Bio. The downside was that it caused the User Directory Module to crash! Something about GetData would truncate the SQL string. I tried to find a way to alter the SP for the User Directory module to help with that but to no avail.

    2 - So since I have my Dynamic Reg Bio field mapped to the DNN Biography Core field, the full text string is getting saved there, it is just getting cut off going into the Dynamic Reg table. So I found the following query in the DNN Forums to get at the DNN Core User Profile data and modified it so that I could use it in the Tailored Text/HTML module (as a SQL Token) to display the Bio!

    SELECT UserProfile.PropertyValue FROM (Users INNER JOIN UserProfile ON Users.UserID = UserProfile.UserID) INNER JOIN ProfilePropertyDefinition ON UserProfile.PropertyDefinitionID = ProfilePropertyDefinition.PropertyDefinitionID WHERE (((Users.UserID)='$(USERID)') AND ((ProfilePropertyDefinition.PropertyName)='Biography'))

    Fortunately the Dynamic Reg form pulls the existing data from the DNN Core Data so when I edit a user's bio it loads all of the text and not the truncated string from the Dynamic Reg table.

    In the future I do suggest fixing that bug just in case someone else is not mapping their field to the DNN Core for some reason.

    This SQL Query could prove very useful for getting Core User Profile data out.

    John ShepherdUser is Offline
    skipping stones
    skipping stones
    Posts:5
    Avatar

    --
    02-15-2008 09:14 PM

    Your FYI will give me a start on fixing a problem with the DNN 4.8 bio and Dynamic Registration. I don't yet have the bio mapped in Dynamic Registration because we really have only a few users for which we need that data. I found that when I entered the text directly for these users while in host or admin, that Dynamic Registration cleared the DNN bio field, even though not mapped. It's sound like that by mapping bio, it may solve that problem.

    We also use a similar script to get all DNN core/profile data, but instead it is a generic cursor script that pulls all fields out in vieworder sequence for all users... Useful for populating a flat table outside of DNN. The one you found looks good for explicit fields like bio.

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-19-2008 08:25 AM
    Thanks... We will also be changing the module in the future to allow for full text column within the responses area and not just 3000 or 4000 etc...
    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