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!

SQL Data bind - checkbox group??
Last Post 12-02-2009 10:55 AM by Richard Bailey. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Richard BaileyUser is Offline
going with the flow
going with the flow
Posts:66
Avatar

--
11-24-2009 06:25 PM

    Ugh... frustrated already because I have a checkbox group that is created dynamically (via a sql query) and I can't for the life of me get the column span thing to work right... blargh (please, don't post with links to demos, i've tried them all and all settings like demo 19 and 8)

    This post wants to know if a dynamically generated checkbox group can have the default values checked?

    I'm using a mixture of things, but particularly Demo 14... so I have the Report Module producing a list of previously entered form values with an edit button.

    However, I can not get the checkbox group responses checked on the SQL result.

    Form Fields:

      Text:  Firstname

      Text:  LastName

       Text:  Credentials

       Text:  PartnerID

       ComboBox:  Specialty {Dynamically Generated with number values}

       CheckBox Group:  Measures {Dynamically Generated with number values}

     

    SQL Query Results have all of the above, results are similar to what the below would return

    select 'first name' as Firstname, 'last name' as Lastname, 'PhD' as Credentials, '1234565' as PartnerID, '22' as Specialty, '1, 2, 3' as Measures

    All of the text fields and combo box work fine - but the CheckBox Group defaults aren't check.

    This is driving me nuts!

    Not to mention, I had to create a UDF to build the comma delimited results for the measures field, and then - to make it even more fun, had to make a stored procedure locally because I am actually working via data from a linked server - oh fun!  haha...

     

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

    --
    11-25-2009 05:42 AM
    HI, for your checkbox group binding, what are the values available for the checkbox group? Let's say you edit the field, and you look at the order in which you enter your entries for the checkbox group, your select statement binding should reflect that order.

    If you enable debug mode on the form and fill out the form, check 1,2,3 on the checkbox group and hit submit. What does it reveal as being selected? -- David
    Richard BaileyUser is Offline
    going with the flow
    going with the flow
    Posts:66
    Avatar

    --
    12-02-2009 10:55 AM
    I got this working - the results from the sql query had spaces 1, 2, 3 - I updated the UDF which builds the comma-delimted results to exclude spaces in the returned value and it works great.
    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