Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Friday, December 05, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
Samples and other shared info.

Forums > Bi4ce.Modules.ListX > Samples and other shared info.
Subject: Drop Down List Sample Question

You are not authorized to post a reply.   
Author Messages
sundownr
Featherweight
Posts:14
04/29/2008 8:05 PM Alert 
<select name="frm_field" class="FormDataA" id="frm_field">
<option value="NULL">*None</option>

{SUBQUERY,
Name="qry_category",
Query="Select uc.user_choice_string_name, uc.ordinal from dbo.user_choice_choices uc
JOIN dbo.user_choice_names un on uc.user_choice_names_id = un.user_choice_names_id
WHERE un.user_choice_name = 'LIST NAME HERE' order by ordinal",
Format="<option value="[user_choice_string_name]">[user_choice_string_name]</option>",
SelectedFormat="<option value="[user_choice_string_name]" selected="selected">[user_choice_string_name]</option>",
SelectedField="user_choice_string_name",
SelectedItems="[FORMAT,[frm_field,Form],{ISEMPTY:}]",
UseCache="False"}
</select>

Looking at the above code... the SUBQUERY I understand but not being good with script I am having problems the requirements of the <select> tag.

Where in the scheme of ListX would I insert this code?

Also does class="FormDataA" refer some kind of css formating for the extracted list data? If so where is
the FormDataA class located?

Thanks for any help.

sundownr

pmanda
Superweight
Posts:267
04/30/2008 9:34 AM Alert 
You can specify your subquery either in the listitem or in no query section. Concerning to the class="FormDataA" it refers to the css class, you can specify the css class in the Admin/Site settings and in the style sheet editor you can add the class.
Praveena Manda
Software Engineer
Bi4ce,Inc
sundownr
Featherweight
Posts:14
04/30/2008 9:53 AM Alert 
Praveena

Thanks a whole bunch... your information was ideal.

I am an 'ole' C++ dog and it is hard to learn new tricks.

Have a great day.

sundownr
sundownr
Featherweight
Posts:14
05/08/2008 5:03 PM Alert 
Praveena

I tried putting the script into listItem and no query but could not not make it work.

I am having no problem marking lists and adding choices but I do not know how to insert a dropdown list and connect it to the script.

Could you please be more specific on how to insert a dropdown list into a DotNetNuke pane... and then hook in the associated script?

Thanks...

sundownr
svedire
Cruiserweight
Posts:107
05/08/2008 9:22 PM Alert 
Hi,

Your SUBQUERy code looks fine. You could put your SUBQUERY in the listitem detail if you have any results from your main query and your need to escape the fields in your SUBQUERY in that case because there might be an overlap with the main query.

You could put in the no query section if you dont have any main query.

Did you try debugging the SUBQUERY? (You could go into General Settings and turn on debugging).

Please let us know the result of the debugging if the problem continues.

Hope this helps.

Thanks,
Sindura
R2integrated
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > Samples and other shared info. > Drop Down List Sample Question


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation