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!

Question Events on Form Load?
Last Post 06-29-2009 11:24 AM by Chad Nash. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Josh SlaughterUser is Offline
going with the flow
going with the flow
Posts:55
Avatar

--
06-22-2009 09:40 AM

    <!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

    <!--[if gte mso 10]> For Dynamic Fields I have the ability to use the setting to retrieve and pass values of the questions to a session variable.  I have a lengthy form that I split up into 3 smaller forms and I am passing the values to session variables because the very last stage of the process is a single form that has all of the fields and allows the user to review and make any changes to the information before submitting the form. I have some Question Events setup that will show other fields based on a response from other fields.  Since I’m passing values to this form via a Session variable is there some way that the Question Events can fire when the form loads? If Question A’s value is 1 and I have a question event to show Question B if Question A’s value is 1, can this question event get fired when the form loads? 

     

    I want to make sure that the appropriate questions are displayed when the page loads rather than showing all the questions.

     

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-22-2009 01:26 PM

    Josh,

    Check out this thread and see if these help. I think you have to use the parameters (querystring) of DSParam1 thru DSParam3 to fire the events (or maybe that is only with SQL). Or, DSSession1 thru DSSession3 for session variables.

    Question Events w/ Upon Form Load

     

    -Chad

     

    Josh SlaughterUser is Offline
    going with the flow
    going with the flow
    Posts:55
    Avatar

    --
    06-22-2009 02:22 PM
    I think that this will get me closer. I have about 12 fields or so that I would potentially need to show. Using the techniques in the thread above, how can I scale it so that it would work with 12 or more fields, since there are really only 6 parameters that I can use, 3 session and 3 query string?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-22-2009 02:24 PM
    Hi. Well I am not sure, I think those are only required when you are reference them in actual SQL queries for question events, you should be able to reference other short field names without using those parameters. Those parameters are required when queries are ran because more caution is used to prevent SQL Injection.

    -Chad
    Josh SlaughterUser is Offline
    going with the flow
    going with the flow
    Posts:55
    Avatar

    --
    06-22-2009 02:30 PM
    Is there any way to show/hide a field so that the form is already setup, visually, when the page is loaded? When the page is loaded, there isn't a postback so my Questiion events won't fire and I'm not using SQL to do a query of any kind. Is there a way to do it via a SQL query? I basically want to show a couple fields only if there are values in certain other fields, and I'm not quite sure how to do that when the page loads.
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-22-2009 02:33 PM
    Hi. Well you basically create the question event but for the 'Postback' questoin you make it a 'Hidden' field. Then the under advanced field options you set the hidden field to be based from 'Retrieve from querystring' or 'Retrieve from session variable'. This way you can pass ?YourhiddenField=ShowCompanyStuff and then the question event can show the company fields (or whatever). Since the hidden field is rendered on page_load it is working as your post back.

    -Chad
    Josh SlaughterUser is Offline
    going with the flow
    going with the flow
    Posts:55
    Avatar

    --
    06-23-2009 05:58 AM
    I think there is one more step that I'm missing in order to be able to do what I need and I'm having a little trouble figuring it out. I have a checkbox group that has 14 items in the group. I have a Question Event tied to each response. Basically when a user selects an item from the checkbox group an additional textbox is displayed on the form that is specific to the item that they have selected. If they select 5 items from the checkbox group there will be 5 additional questions that show up, etc. I need to be able to track which items have been selected so I create an hidden field for each of the possible responses. I created a Question Event that would set the default value of the hidden field based on the response from the question that contained the 14 items in the checkbox list. If an item is checked, my question event updates the default field of the corresponding hidden field to a "1" and that lets me know that they have made that selection and that when they get to the "review form" the corresponding textbox needs to be displayed when the page loads.

    The problem is that if someone selects an item from the checkbox group and say the selected the wrong item by mistake, it still updates the hidden field. My question is, Is there a way to setup an event of some sort that will fire when a user unchecks a item or changes their selection in a dropdown menu? I need to be able to change the value of the hidden field when a user deselects an option. Can this be done?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-25-2009 06:53 AM
    Hi. I might be confused by the exact form you are creating here... You might setup a quick demo on www.betasprings.com just highlighting the concept and ill check it out, check box lists and other fields types that can 'cause' a postback should be able to fire a postback and the event will fire, so if a user unselected #4 it should fire the event and then field #4 wouldn't show up. The hidden field for question events is really only used when you are trying to initially load a page to show/hide fields from the querystring.

    -Chad
    Josh SlaughterUser is Offline
    going with the flow
    going with the flow
    Posts:55
    Avatar

    --
    06-25-2009 07:02 AM
    I'm getting the following error when trying to create a page on betasprings.com to setup the demo

    Error: Page Management is currently unavailable.
    DotNetNuke.Services.Exceptions.ModuleLoadException: Could not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'BetaSprings' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'BetaSprings' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTab(Int32 PortalId, String TabName, Boolean IsVisible, Boolean DisableLink, Int32 ParentId, String IconFile, String Title, String Description, String KeyWords, String Url, String SkinSrc, String ContainerSrc, String TabPath, DateTime StartDate, DateTime EndDate, Int32 RefreshInterval, String PageHeadText, Boolean IsSecure) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.SaveTabData(String strAction) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    06-25-2009 12:44 PM
    HI Josh, sorry for the inconvenience. It seems like the database size for "BetaSprings" has reached its limit. Chad will need to go in and delete all the log files and compact the database or increase it's filegrowth size limit. In the meantime, I'll shoot you an email and you can send me the XML content of your form for me to diagnose on my local machine. -- David
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-29-2009 11:24 AM
    Hi,

    Has this been resolved? If so can you post some details so that we can follow up on what the solution was.

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