Andy
going with the flow
Posts:38
 |
| 10-05-2007 10:54 AM |
|
Need help with short name variables not being set properly.
I am populating a list of selections with a query from a small table that has ID and Text. The selections come back fine but when the form is in turn submitted, I insert all the form values to another table. The standard fields are inserting but the values from the selection list are not.
I have tried selecting "Pass values of this question to querystring variable" AND "Pass values of this question to session variable" but the values are still not being inserted.
???
|
|
|
|
|
Chris Sigmon
going with the flow
Posts:58
|
| 10-06-2007 04:53 AM |
|
Make sure you are setting the QuestionOptionValue correctly. Have you tested the SQL Query to make sure it is returning the proper value?
Chad, when we click "Test SQL" it may be helpful to see the value we are setting as well. |
|
|
|
|
Chris Sigmon
going with the flow
Posts:58
|
| 10-06-2007 05:04 AM |
|
After I read your post again, I think I gave you the wrong advice. I have seen my "ShortName" not show up before. I think I had spaces in it or it was duplicated. I always stay away from common used field names like "ID".
Sorry for the initial mis-read. |
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-18-2007 11:46 AM |
|
Still unable to get this to work. It appears that fields that are 'triggered' to contain data based on another field (question event), those values do NOT get set or inserted to the db.
I have one field called 'Environment' (shortname 'env') based on that selection, I query a table for a list of servers that belong to that environment and the full list populates a drop down list of available servers. The server is selected (shortname 'servername'.).
On submit, the $env variable puts a numeric value in the table but the $servername is blank (not NULL).
I have pass values to querystring and session checked but it is still not working...
What might it be? |
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-18-2007 12:35 PM |
|
Follow up: On the servername issue mentioned above, I was not setting the QuestionOptionValue, just the QuestionOption from the table items. The ones that are still NOT working properly are where multiple selections are available. I have a few fields such as directory selections '$(dirselect)' where I provide a checkbox group list of 5 primary directories that can be selected. I think the issue is with the fact that multiple options can be selected but still they should still be inserted into the table column as dir1,dir2,dir3,dir4, etc.
|
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-19-2007 11:38 AM |
|
Still no word back on this... I'm really stumped here. I guess what I need to know is when I populate a listbox from a table and the dynamic question is 'varname1', if multiple items are selected, what are the variable names that are getting set?
If there are three options; item1, item2 and item3 and the user selects them all what would be the resulting variable(s)? What would $(varname1) contain? 'item1,item2,item3'? Only one? Nothing? As far as I can tell, it's nothing.
|
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-23-2007 06:44 PM |
|
At least tell me this: If I have a multi-select list called variable ($varname1), and the user checks off item1, item2 and item3, what should be the result???? I'm getting nothing and I need to know all 3 items (or 1 or 2 whatever they pick). I CAN'T figure out a way to create 3 separate checkboxes ($varname1, $varname2 and $varname3) as individual items because they are populated into the selection list from an existing table that gets more options added to it from yet ANOTHER table (item 4, item 5, etc.). If you know of a good way to do this, please tell me. I need to present the options, let the user pick and assign those three options to another table (or four, or five if the other table is expanded with more options). Be a good sam today, help a newb....  |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-23-2007 08:02 PM |
|
Ok,
Well fields that utilize CheckBoxLists and Listbox's function a little differently than other field types.
Right now with radio buttons and dropdownlists for email/sql events it returns the VALUE of these fields for SQL Events and Email Events etc... Now in the next minor or incremental release (just not released for v2.5) there is the option to include $(ShortFieldName_Text) which will be able to bring in the text value for a radio button or dropdownlist.
Now... For CheckBoxList and Listbox Fields it generates a list of items followed by line breaks. For for a Checkbox list if you use the token within a SQL or Email event it would display...
Option One
Option Two
Option Three
etc...
We might want to change this in the future to display like this if you choose $(CheckBoxList_Text) within the email or SQL Event and otherwise maybe display a comma separated list of values such as "1,2,3" etc... Everyones implementation is different though so keep in mind that this is just how it functions now and we can review (especially if popular and needed for many implementations) other possible ways to display these field types.
-Chad |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-23-2007 08:08 PM |
|
Also, depending on what you need the data for you might consider changing the columns to be nvarchar instead of integer etc... This will at least insert the data there and if you had to you could even have a SQL Statement execute that would update the table to reflect the appropriate values for whichever text was inserted into those tales.
i.e.
Update YourTable Set Value = '1' where Value = '
Option 1' etc...
Just a thought / work around though...
-Chad
|
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-23-2007 08:36 PM |
|
Yeah, I created the columns as nvarchar(255) just to accept whatever came in when multiple items were selected, hoping I could figure out how to parse those entries later like; select jobtypes from tableA where tableB columnC contains value1 or value2 or value3 (knowing that's a bogus query), but still, on the initial insert, I end up with an empty column. Whether I select one, two or three values, the column is populated with 'blank' as opposed to the default . Single entry selections insert fine to columns A and B, but the multiselect column(C) is blank. I'll try the 'Update table set value where value=option' you mentioned above and see if that gets 'er done. Thanks!
|
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-24-2007 09:22 AM |
|
Problem with the above suggestion is not being able to know precisely what the options might be because they can change.
Right now, I do the following (and many more):
Insert into dnn.dbo.mytable (timenow,fname,lname,dirnames)
values
(getdate(),'$(fname)','$(lname)','$(dirnames)')
It is the dirnames that is ending up blank. But the dirnames 'list' can change frequently depending on whether or not that particular list (table) is changed or added to. How would I 'not care' what the dirnames list contains and insert whatever options the user selects into the dirnames column? If I manually insert 'val1,val2,val3' I (think) I get the results I want. You mention this above as being a consideration the future but is there something I can modify locally to make this happen? |
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-25-2007 10:29 AM |
|
Nope. Still no luck here. I added the $(varname) to the notification email to see if the values appeared at all and they do not. The values are simply NOT being created. The notification email replaces the single selection variables (Dear $(firstname), etc.) but NONE of the listbox or checkbox group variables are getting set. Please enlighten me... |
|
|
|
|
Andy
going with the flow
Posts:38
|
| 10-25-2007 10:32 AM |
|
Oh, and I checked the regular "View Form Results" and NONE of the multi-select variables are posting there either. The version of Dynamic Forms I have installed is 2.30.70... is that the problem????
|
|
|
|
|