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

Dynamic Registration 4.0

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 4

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.

XMod Pro 2.7 - Forms and Views for Databases

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,

Smith Shopping Cart v3.88

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.

Event Calendar and Registration 4.0

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

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Enhancement for DSParam
Last Post 08-02-2012 07:55 AM by Ryan Bakerink. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
NathanWUser is Offline
going with the flow
going with the flow
Posts:45
Avatar

--
08-02-2012 02:37 AM
    As many of the forms people use will need to use the DSParam variables to retrieve info from the querystring. It would save a bit of time if when DF created a new form it automatically created 3 hidden fields called DSParam1, DSParam2 and DSParam3. I know this can be done manually but it would save time if they were created automatically and if the user does not want or need them they can delete them or leave them as they have no downside of being in the form if they are not used.

    Nathan
    NathanWUser is Offline
    going with the flow
    going with the flow
    Posts:45
    Avatar

    --
    08-02-2012 03:19 AM
    Please ignore the above request as of course everyone will use different variable names. Mad idea of mine, must be having a bad day!!!

    Nathan
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-02-2012 04:42 AM
    Hello Nathan,

    Not a terrible idea at all, when it comes to Initial SQL Binding in Dynamic Forms and using Dynamic Token values, you're required to use a token named either DSParam1, DSParam2 or DSParam3.

    However all other features within Dynamic Forms doesn't have this restriction. Perhaps adding DSParam1, DSParam2, and DSParam3 as a selection under the Question Wizard would be the most appropriate approach.

    We encourage all enhancement ideas that our customers have as this assists us in releasing new features that our customers want. So there's no such thing as a bad enhancement idea.

    Let me know if you have any questions.

    Thanks,

    Ryan
    NathanWUser is Offline
    going with the flow
    going with the flow
    Posts:45
    Avatar

    --
    08-02-2012 04:52 AM
    Ryan, that was the exact reason how I came up with the idea as I was creating an initial bind and though how frustrating it was to always have to have the DSParams1,2 and 3 to use them here. The problem was I then went and started to create some other variables and used the "Get from query string" and through that my idea was stupid so then went back and did the second post. So the upshot is that I do think it would be a great idea in relation to the initial bind part as think you are right to add it to the SQL wizard. What would also be cool is if their was an option in the SQL wizard to also say, "Create initial bind" based on the parameters that you select in the wizard which would save time when creating an edit screen.

    Nathan
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-02-2012 05:04 AM
    Hello Nathan,

    I'm not sure how much time that would save if we added that into the Question Wizard. After all enabling and using the Initial SQL Bind feature requires configuration. Thus if you wish to configure it, you can go straight to Module Configuration -> Advanced Coding Options -> Initial SQL Bind/Rendering and configure this from here. I feel as though this may become redundant if we add this into the Question Wizard as well. It's good to keep most features localized in one central area(Module Configuration) , as if a user has a question where to enable or disable a feature they will know where to go intuitively.

    The Question Wizard is specifically for adding questions to your form to prevent you from doing it manually by individually adding them. If we begin Configuring an Initial SQL Bind from here it won't really be a Question Wizard any longer.

    Let me know if you have any questions.

    Thanks,

    Ryan

    NathanWUser is Offline
    going with the flow
    going with the flow
    Posts:45
    Avatar

    --
    08-02-2012 05:15 AM
    Ryan

    Maybe I didnt explain very well (or maybe it just is a mad idea!!) but I will try again.

    When you use the question wizard one of the options is to create a form based on an sql query which most people will use for some type of edit form for later add data back into the database.

    I am not suggesting and type of config related to the initial bind all I am suggesting is a tick box that say "Auto generate Initial Bind based on SQL fields selected". The wizard would then create the form using the sql fields exactly as it does not but it would also automatically create the "select" query in the initial bind config area.

    I agree the user would then have to go and edit the query to add the "WHERE" part but it would help especially when you are creating large forms that bring in data from a table (initial bind) as the amount of typos / errors becomes a pain and I have never (yet) got it right first time (could just be me being daft).

    Happy for you to say "nah your mad!" if you dont think it is worth adding, I wont be offended

    Nathan
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-02-2012 05:27 AM
    Hello Nathan,

    Hmm.. I think this enhancement just needs some additional ironing.

    Now that you've explained this more thoroughly I can see how this could work.

    Regarding the WHERE part, perhaps a check should be made to see if the User added DSParam 1,2 or 3 to their form. If they did then build the WHERE clause for the user.

    The only thing is if the time and effort was put into adding this enhancement, I'm not sure how much time this feature would save the user building the form. But yes, it would be a nice little tool to get this out of the way at the beginning. However I wouldn't see this as a selling point of Dynamic Forms.

    Also Initial SQL Binding isn't one of the first things that you configure in a Dynamic Form, usually the user is more worried about Adding the fields to the form, configuring validations, inserting the information into a flat table, etc...

    Initial SQL Binding from my experience gets configured later in the development of your Dynamic Form rather than at the very beginning.

    These are just my two cents I use Dynamic Forms 2-4 hours everyday so I can definitely understand where you're coming from in retrospect.

    Thanks.

    Ryan
    NathanWUser is Offline
    going with the flow
    going with the flow
    Posts:45
    Avatar

    --
    08-02-2012 05:37 AM
    Yeah I can see it wont increase sales. I was interested to hear that most users tend to build the form and worry about binding later as I always work the other way round (trust me to be different). You are probably right that the amount of work needed to add it for the saving it will make is probably not worth it, but then again we all know that Chad has nothing else to do at the moment and is probably just drinking coffee and barking orders Now what would be clever is if DF had its own built in Stored Procedure in the database and when the user ran through the SQL wizard it automatically created the initial bind, an insert and update query using the SP so in effect the wizard would build a form that could edit and add new records before the user even has to do any other work. That would be a massive saving of time and effort.

    Nathan
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    08-02-2012 07:55 AM
    Hello Nathan,

    Believe me, Chad is staying very busy with some new stuff.... not to get too specific

    The Stored Procedure Idea is a great idea. However this would require some prerequisites before operating correctly.

    What if users configure the Initial SQL Bind Wizard before having fields on the form. The system won't be able to intuitively figure out the TableName, Stored Procedure contents, etc...

    So I could see this causing issues if not used in the correct order. However this idea is great and can be polished to work effectively.

    I'll throw this idea on our Dynamic Forms enhancement list.

    Let me know if you have any questions.

    Thanks,

    Ryan



    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    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