Quick login...
 

 

SnowCovered Top Sellers

View Active Social Suite for DNN
Active Social Suite for DNN
 by Active Modules, Inc.
Active Social is customizable social networking solution that fits the needs of a large company, small group, start-up business, or any size interest group. Connect with co-workers, people with similar interests, family, old friends, or meet new ones. Active Social provides a complete communication ...read more
Posted: Thursday, October 29, 2009

View Ultra Video Gallery 3
Ultra Video Gallery 3
 by BizModules.net Solutions
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 and play them in our integrated flash video player....read more
Posted: Friday, February 13, 2009

View Event Calendar and Registration 3.0
Event Calendar and Registration 3.0
 by Invenmanager.com
One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!...read more
Posted: Sunday, July 12, 2009

View Ultra Media Gallery 5.5
Ultra Media Gallery 5.5
 by BizModules.net Solutions
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....read more
Posted: Wednesday, May 13, 2009

View Dynamic Forms 3.1
Dynamic Forms 3.1
 by Data Springs, Inc.
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. ...read more
Posted: Tuesday, September 29, 2009

View Puure // Skin Tuning // DNN + Sharepoint // W3C v1.1
Puure // Skin Tuning // DNN + Sharepoint // W3C v1.1
 by BIND (www.bind.pt)
Puure is the first cross-platform skin pack, with DNN or Sharepoint versions. With Skin Tuning available, it includes Ultimate JQuery Header module free! Discover our DNN Modules Skin Add-On, one you can't miss. 100% W3C CSS/XHMTL1.0 compliant, for DNN4 and 5. NEW! Add-On for Open-Document Library...read more
Posted: Tuesday, November 03, 2009

View Open-DocumentLibrary 4.1
Open-DocumentLibrary 4.1
 by Xepient Solutions
Powerful, Ajax Enabled, Easy to Use. Document Management and Multimedia gallery functionality in one.Open-DocumentLibrary allows DotNetNuke users to organize share and manage documents, offering granular control over Folder and Document access....read more
Posted: Wednesday, April 01, 2009

View Flex2 By DrNuke + EasyMod Module
Flex2 By DrNuke + EasyMod Module
 by DrNuke
The amazing ANY COLOUR Flex2 skin + our unique EasyMod module allowing you to customise just about everything in this skin. DrNuke just re-wrote the rule book again....read more
Posted: Wednesday, May 13, 2009

View Dynamic Registration 3.2
Dynamic Registration 3.2
 by Data Springs, Inc.
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.........read more
Posted: Tuesday, June 17, 2008

View Data Springs Collection  3.0 (23 Modules)
Data Springs Collection 3.0 (23 Modules)
 by Data Springs, Inc.
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....read more
Posted: Sunday, September 27, 2009

Recently Viewed...
DNN Modules
   
    |   Register   |   Wednesday, September 08, 2010   
Hi Everyone!

You'll notice that we implemented a small change where your first and last name are now displaying in the forums.  If you do not wish to display your last name, please update your user profile and add a display name.  You'll find this by clicking on your name at the top of the page (right next to the Logout link).  Thanks!

Data Springs Product Forums...
Subject: DF form complerion query fails
Prev Next
You are not authorized to post a reply.

Author Messages
The Dad
Posts:32
paddling down the creek
paddling down the creek

08/18/2010 5:26 AM  


The DF form completion event submits the query below, but the query will not wotk.  I ran the query under Host/SQL and it works just fine!

How do I resolve this?

Here is what I am running:
Ver:3.3.40.0 / 5.4.4

Here is the error (table name has xxx's):

An error occurred when attempting to run this SQL query:

update xxxxxxxxxxxx set GameDate = '07/31/2010 ', GameTime = '01:45', AMPM= 'pm', GameType= 'Showcase', EventName= 'RCS Unsigned Sr Showcase', EventURL= '', Country= 'United States', VenueState= 'Texas', Venue= 'Harvest Time Church Gym', VenueAddr= '7770 Imperial Valley Dr', City= 'Houston', zip= ' 77060 ', Opponent= 'Other Seniors', HomeOrVis= '', MyTeam = 'Unsigned Seniors', WorL= 'W', GameURL1= '', LinkType1= ' ', LinkType2= ' ', GameURL2= '', LinkType3= ' ', GameURL3= '', OurScore= '87 ', TheirScore= '78 ', Att2s= '7 ', Made2s= ' 4 ', Att3s= ' 2 ', Made3s= ' 1 ', FTAtt= ' 5 ', FTMade= ' 3 ', TotRebs= '7 ', TotPts= '14 ', Assists= '4 ', GameLevel= 'High School', Steals = '2 ', GameNote= 'This is game 1 of 3 games that I will play (#31)' WHERE GameID = '1'

String or binary data would be truncated. The statement has been terminated.

Ryan Bakerink
Posts:235
river guide
river guide

08/18/2010 10:06 AM  
Hello "The Dad",

The following error your getting "String or binary data would be truncated. The statement has been terminated." basically means that one or more of your columns are not large enough to contain what you're trying to insert into the column.

You will need to find the size of your columns by going to your server and look at the table with these columns. Find the datatype and size, my guess is that the field that isn't large enough is "GameNote".

Once you find the field that you need to enlarge in size. Use this query to alter the size of the column:

Alter Table yourTableName
Alter GameNote nvarchar(500)

Then execute under Host-> SQL

Note: First find the column that needs altering.

Thanks,

Ryan
The Dad
Posts:32
paddling down the creek
paddling down the creek

08/18/2010 1:44 PM  
Thanks Ryan,

I will give it a whirl.
Ryan Bakerink
Posts:235
river guide
river guide

08/19/2010 12:41 PM  
Hello,

Please let me know how this works for you.

Thanks,

Ryan
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > DF form complerion query fails



ActiveForums 3.7
DNN Modules
Copyright 2005 - 2010 by Data Springs, Inc.
Terms Of Use | Privacy Statement