Thomas Born
going with the flow
Posts:78
 |
| 06-18-2009 11:40 PM |
|
Hi;
We are using several mutliple checkbox fields for information like Hobbies or Interests. We have some users that like to check many boxes. The data is then stored as follows:
Hobby1,Hobby2, Hobby3 etc.
There is no space after the , resulting in the text going passed the border of our div element that contains the data. Is it possible to change this so the data is stored with a space after the comma?
Or do you have any other suggestion how we can force a line break? You can see what I mean by following this link:
http://www.clickalifecoach.com/Sear...fault.aspx
Thanks
Thomas |
|
|
|
|
David To
river guide
Posts:2719
|
| 06-25-2009 01:22 PM |
|
HI Thomas, are you referring to the checkbox group on "hobby interest" that strings together and goes beyond your skin layout?
Cooking,Dancing,Driving,Hiking,Jogging,Movies,Music,Networking,Reading,Swimming,Travelling,Walking,Yoga
Problem with checkbox group is that it strings together all the values that you checked and thereby, does not know when to break.
However, that comes to an interesting question: How are you storing your data? To an SQL database table column? And retrieving the result in DUD? You may consider seperating the "Interests" to have sub-categories and store them as sub-categories as opposed to combining everything into one column. That way, the results won't be as long even if the user checks everything.
You might possibly create an SQL insert/ update statement to add in HTML break tags after certain amount of characters before storing / after storing the data. -- David
|
|
|
|
|
Thomas Born
going with the flow
Posts:78
|
| 06-25-2009 02:16 PM |
|
Hi David;
Thanks for your response.
Yes I am referring the hobby interest checkbox group. The data is stored in one field in the propertyvalue table, that is what DR created by default.
I tried to add a space in after comma, which works fine in the display. The downside is that when a member tries to edit his/her profile the data does not bind correctly to the checkbox group. Only the first item that was selected will be selected the other selections are not recognised.
I guess an improvement in your module would be to place an empty space after the comma and ensure this is handled correctly when updating form data. Or even cater for both cases when binding, with and without space.
I am happy changing the data via SQL inser/update as long as you can give me a solution as how to handle the data when doing the update.
Thanks
Thomas |
|
|
|
|
David To
river guide
Posts:2719
|
| 06-26-2009 05:12 AM |
|
HI Thomas, I'm a little confused. Do you have one checkbox group field tied to a DNN core property? If so, when the user updates registration by picking some other selections in the checkbox group, it should update correctly. Are you saying their profile isn't updating correctly or your DUD listing is not showing it correctly after they update? -- David |
|
|
|
|
Thomas Born
going with the flow
Posts:78
|
| 06-26-2009 12:36 PM |
|
David;
No the DNN core fields are updating correctly. What I am saying is the the values are stored back to the DB in a comma seperated list which is correct. Unfortunately when DR builds the string, it does not place a space each comma causing the list to appear as one big word causing it to flow over a division element if many options were selected.
Your idea was to put a break (or space) charater in via an SQL Update event, which would work for the display. But when the user then tries to edit their records, the data is not correctly bound to the check box control, because DR does only recognise the first value as a match, when matching the records to bind them back it thinks the space is part of the actual value. As there is no value in the list (on which the check box based on) that has a space as the first character, the value can't be found.
It would be nice that somewhere in your logic where you seperate the individual values for the binding operation, that you strip any empty spaces at the beginning and end of the data. Hope that makes sense now.
Thomas |
|
|
|
|
David To
river guide
Posts:2719
|
| 06-27-2009 06:16 AM |
|
HI Thomas, another option is in your DR module, instead of linking the hobbies checkbox group to a DNN core property field directly, use an SQL stored procedure to insert / update the DNN core property field of the user in ther userprofile table. In the SQL stored procedure, you can modify the checkbox group data by replacing "," with anything you like. That way, when using DUD to showcase, it will appear more like what you want. -- David |
|
|
|
|
Thomas Born
going with the flow
Posts:78
|
| 06-27-2009 02:23 PM |
|
Ok, I think I understand now. Does this mean DUD shows the values that are stored in the DNN Core field and DR shows the values that are stored in the DR tables?
Thomas |
|
|
|
|
David To
river guide
Posts:2719
|
| 06-28-2009 06:22 PM |
|
HI Thomas, not exactly what I meant. There are two important tables relating to DNN cores (profilepropertydefinition and userprofiles). You can create a DNN core property, and then in DR, instead of linking a field to the DNN core under "Advanced Field Options", which I presume you are doing at the moment, simply leave it not linked to any DNN core field. Then use an SQL stored procedure to insert / update the data into the userprofile table (passing the parameters userid and checkboxgroup shortname) to the stored procedure. Within the stored procedure, you will then manipulate the checboxgroup data by adding spaces or HTML
tags to the data so that it will be rendered the way you want it when DUD display the core field. Check out this forum (particularly the last entry on page 3 where the stored procedure resides) and you can see something similar to this effect.
Feel free to try out this method and if you problems, simply respond and we can continue to help you out or someone else on this forum will respond. -- David
|
|
|
|
|