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!

Initial SQL Binding not working as described in forum or documentation
Last Post 12-07-2012 06:51 AM by Ryan Bakerink. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
CynthinaUser is Offline
wading in the water
wading in the water
Posts:21
Avatar

--
11-27-2012 08:06 AM
    I am using a stored proc for the initial sql binding to a form that incorporates a guest detailed profile.  The guest profile table can be retreived by using the username (a core dnn token).  I have followed the docuentation for using the DSParam1 in the initial javascript but no available.

    I have set the variable default for DSParam1 = 'host' and it displays correctly as a hidden value.  However, the sql binding will not work unless i explicitly have the username typed in...

    Exec "getguestprofile"  where @username='host' ---- that is the only time it works. 
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    11-27-2012 08:33 AM
    When you are using this with the token are you still keeping the ' marks around it?

    So it would be:
    Exec "getguestprofile" where @username='$(DSParam1)'


    -Chad
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    11-27-2012 09:01 AM
    Yes I sure am....I have done with or with out.  I even set it in the initial javascript area with a direct declaration (i.e. $(DSPARAM1) ='host'; and no avail....

    Also, I found out that my update stored proc is not working with the given DSPARAM1 either.

    I am at a loss on why it is not working.  It works when I use the actual value.

    any ideas?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    11-28-2012 08:13 AM
    Hi Cynthia,

    Well I don't think the initial JavaScript would help because that is on the client side. You might end up needing to create a hidden field type called DSParam1 and set the "Retrieve value from querystring" property however I know this is used very often so I am not sure what the difference would be. Have you already checked out demo's 14, and demo 21 at http://www.datasprings.com/formdemos?

    Thanks,

    Chad
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    11-29-2012 10:44 AM
    OK ---- I did it that way too and it did not work either. I finally figured out what was making it happen. I had added the panels options to break up the form to be visually pleasing and I deleted that. It did not work even if I had disabled it. So I deleted the panels.

    Any ideas why? It is now working fine without panel options. hmmmmmm.
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    11-29-2012 10:51 AM
    OK ---- I lied....its not working. Even with the query string method.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    11-30-2012 06:44 AM
    Hello Cynthina,

    To get SQL Binding to work with a Dynamic Form, all columns that are returned must share the exact name as the short field name of the respective questions on your form.

    If you return a column in SQL Binding named "FullName", then you'll need to have a Question on your Form with the shortfield name of "FullName".

    Also SQL Binding only accepts the following variables: $(DSParam1), $(DSParam2), $(DSParam3), $(DSSession1), $(DSSession2), and $(DSSession3)

    If you try to use any other tokens, the SQL Bind will not work as expected.

    So you'll want to have a hidden field on your form with the following:
    * Lowest sort order of all Questions
    * Shortfield name of "DSParam1", "DSParam2", "DSParam3", "DSSession1", "DSSession2", or "DSSession3"
    * Enable Retrieve value from Querystring variable if using: DSParam1, DSParam2, or DSParam3
    * Enable Retrieve value from Session variable if using: DSSession1, DSSession2, or DSSession3.

    Note, that he SQL bind will attempt to fire every page load whether the querystring variable / session variable is present or not.

    To keep SQL Binding from firing all the time you should look into the "Only enable when Querystring value is Present" feature of SQL Binding(Page 154 of the User Guide):
    http://www.datasprings.com/userguid...rGuide.pdf


    Let me know if you have any questions.

    Thanks,

    Ryan

    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    11-30-2012 11:09 AM
    Hi Ryan -

    I have done EVERYTHING you have suggested and IT STILL is NOT WORKING. I have spent hours trying to find which way would it work. I understand everything you have said and did multiple ways.

    I am at my wit's end to make this work.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    11-30-2012 01:11 PM
    Hello Cynthina,

    The only way I can see this getting resolved is if we jump on a quick call to see if I can locate the issue.

    However I won't be able to do so until 12/6/2012.

    Post any questions that you have here in the meantime.

    Thanks and hope you have a great weekend.

    -Ryan
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    12-01-2012 04:16 AM
    Yeah!!!! Found what was the issue. It was the order of the variables. When I put as the first one --- it worked like a charm. Your trouble-shooting list really helped in going through what needed to happen.

    Is there a place that we can go to for other trouble-shooting functions and features of the modules?

    Thank you!
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    12-07-2012 06:51 AM
    Hello Cynthina,

    Great to hear that you got this to work.

    When it comes to trouble shooting the best thing to do is to put the Dynamic Form in DEBUG mode. This way you can see everything that you've configured that executes behind the scenes. Good tool for SQL and JavaScript if you added in custom stuff.

    Then you can copy your SQL Bind Query to Host -> SQL and execute it. You would use Host -> SQL as a method to validate that your SQL Statement is valid and is returning information.

    Seems like 10 out of 10 times, it's a user error when it comes coding SQL or JavaScript. So by using this tip, you can verify that your SQL statements are valid and return information.

    With the Form in Debug mode, you're able to see the exact query that's executing with the token values rendered. Or if the Tokens aren't rendering that's an indication that the token doesn't exist.

    Unfortunately the User Guide just outlines what Initial SQL Binding is and how it can be used(assuming valid SQL is provided).

    Hope this helps.

    Thanks,

    Ryan
    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