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
SQL Driven Value for a TextBox
Last Post 04-20-2010 11:20 AM by David To. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
shaun BajadaUser is Offline
wading in the water
wading in the water
Posts:17
Avatar

--
09-21-2009 09:12 PM

     

    Hi
    I have a 2 form set up where I pass on the UniqueCompletionID to the second form.
     
    On the first form I have a SQL event firing to write an insert statement to a Table I have created this writes the UniqueCompletionID to my table. That has an Auto increment procedure attached to it to dish out subscriber numbers.
    When this SQL event is completed and the second form is rendered I have the following:
     
    A hidden field that will show the auto increment subscriber number which I will then create an email completion event to the user.
     
    I have the following in my SQL Driven  statement on my hidden field:
     
    SELECT SubscriberNumber AS DefaultValue
    FROM PRusername
    Where UniqueCompletionID = '$(UniqueCompletionID)'
    This should work and render the auto increment subscriber number.   
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    09-22-2009 06:23 AM
    HI, yes this method should work. If not, you could also use SQL default driven question event as well. -- David
    shaun BajadaUser is Offline
    wading in the water
    wading in the water
    Posts:17
    Avatar

    --
    09-28-2009 04:22 PM

    all good now just used the $(DSParam1) to grab the active data session.

     

    thanks

    t-boneUser is Offline
    river guide
    river guide
    Posts:77
    Avatar

    --
    04-16-2010 10:47 AM

    I'm having a problem with the SQL Default Driven question event..

    I can use the select (select description as DefaultValue from kdata_classes where classcode = 3).. works fine..

    but when I put in the $(shortfieldname).. it gives an error..  "cannot deserialize empty string"... the field is not empty though..!?


    I have a combobox, that i'm pulling the value from and putting into a field (client side) for the SQL driven default, then firing the question default question (SQL driven) event..

    any help would be appreciated!

    Tony
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-16-2010 12:53 PM
    HI, okay so your SQL driven default works fine for the combobox? Then you use client side javascript to place the value chosen into a textbox field? I'm I correct about what you are doing? -- David
    t-boneUser is Offline
    river guide
    river guide
    Posts:77
    Avatar

    --
    04-20-2010 07:29 AM
    I have a combobox... a hidden field.. and a visible text box. I'm using SQL to populate the combobox, this works fine. When the user picks an option from the combobox, it writes (via client-side event on combo) the value to the hidden field. I then have a question event, that is supposed to set the default value of the visible field.. like so "Select [value] as DefaultValue from [table] where [field] = $(hiddenfield)" (minus the quotes). I get the strange "cannot deserialize..." error. I can substitute the $(hiddenfield) with a real value, and it works okay.. I just can't seem to get the question event to work properly with the shortfield name in the "where" statement of my SQL statement.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-20-2010 08:55 AM
    HI, your method will not work. What you want to achieve in your case is dependent drop down list box. Please check out demo 11 at:

    http://www.datasprings.com/Products...fault.aspx

    -- David
    t-boneUser is Offline
    river guide
    river guide
    Posts:77
    Avatar

    --
    04-20-2010 08:59 AM
    All I need is for a value stored in SQL to be pulled to a text box.. based on what the user picks in the combobox. So that the user can edit the value.. then re-save it.. or delete it (from SQL). It's not meant to be a drop down list, just a text box (only 1 value).

    Is there a tutorial for that somewhere?
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-20-2010 09:22 AM
    In that case, there's a much easier way to do this:
    1) leave your combobox the same way it is now
    2) leave your textbox the way it is now
    3) in your combobox, under advance field options, have client side method: $(textboxshortname) = $(comboboxshortname);
    4) create an SQL completion event, call a stored procedure to update or delete the record from the SQL table listing

    -- David
    t-boneUser is Offline
    river guide
    river guide
    Posts:77
    Avatar

    --
    04-20-2010 09:30 AM
    The combo basically is a lookup to the "key" field in the table, but doesn't contain all of the values for the record in the table.. I was hoping that there was a way to pull all of the data in the table to individual text boxes (after a value is selected in the combobox), then at that point the user would edit the values (if they wanted to), then save them.. then, yes, i'd use an SQL completion event.. but i'm not to that point yet.. i just need to retrieve values from a record in an SQL table and put them into text boxes on the dynamic form.

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-20-2010 11:20 AM
    Okay, so I see what you are trying to do. Here's a way to accomplish this with only Dynamic Forms. You will need to have two dynamic forms module on the same page.

    Module 1 (top module)
    1) just have the combobox and with shortname of DSParam1. Under advance field options, make sure to pass and retrieve from querystring variable.
    2) also create a hidden field called DBUpdate (set default value to True) and pass querystring variable

    Module 2 (bottom module)
    1) under Module Configuration / SQL Rendering Bind, make sure to enable SQL binding on DBUpdate querystring
    2) your SQL would be: select * from tablename where columnname = '$(DSParam1)'
    3) create all your fields with same shortname as the column names of the SQL table that you want the user to edit
    4) create an SQL completion event, either using a stored procedure or an update statement to modify the record in the SQL table

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