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
NorthWind Sample
Questions and Answers about our "Soup to Nuts" NukeDK sample of the Northwind Database.
Forums > Bi4ce.Modules.ListX > NorthWind Sample
Subject:  problem

You are not authorized to post a reply.   
Author Messages
jengka
Flyweight
Posts:4
10/06/2007 5:25 AM Alert 
<img src='http://dnn.bi4ce.com/desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'> Hai

I want to ask about <select> in the ListX form
Now I am using POstgreSQL database and I try to access data from a table and put it in the <select> .

But no data appear in the <select>

this is the code :

<select class="Tier3DropDown" id="fld_causecodetype" name="fld_causecodetype" > {SUBQUERY,Name="cbocausecodetype",Query="SELECT '' AS \[lu_causecodename\], '' AS \[lu_causecode\]
UNION
SELECT \[causecodegroups\].\[causecodename\] AS \[lu_causecodename\], \[causecodegroups\].\[causecode\] AS \[lu_causecode\]
FROM vocaldata.public.\[causecodegroups\] \[causecodegroups\]
ORDER BY \[lu_causecodename\] ASC",Format="<option value='[lu_causecode]'>[lu_causecodename]</option>",SelectedFormat="<option value='[lu_causecode]' SELECTED>[lu_causecodename]</option>",SelectedField="lu_causecode",SelectedItems="[FORMAT, [fld_causecodetype, Form], {ISEMPTY:[causecode]}]",UseCache="False"} </select>


Please give me advice <img src='http://dnn.bi4ce.com/desktopmodules/ntforums/images/emoticons/biggrin.gif' height='20' width='20' border='0' title='Big Grin' align='absmiddle'>
bgates
Heavyweight
Posts:197
10/06/2007 11:48 PM Alert 
There's an option under General for Debugging. Put a check in that for either "Show Debugging For Super Users" (if you log in as 'host') or "Show Debugging for Admin" (if you log in as an Administrator). The information that gets displayed on the page should help guide you. If not, feel free to respond to this and copy in what you see for this Subquery.

I think what you'll see is that you have too many []. Try removing the [] from around everything, except in the Format and SelectedFormat parts. That is:

<select class="Tier3DropDown" id="fld_causecodetype" name="fld_causecodetype" > {SUBQUERY,Name="cbocausecodetype",Query="SELECT '' AS lu_causecodename, '' AS lu_causecode
UNION
SELECT causecodegroups.causecodename AS lu_causecodename, causecodegroups.causecode AS lu_causecode
FROM vocaldata.public.causecodegroups causecodegroups
ORDER BY lu_causecodename ASC",Format="<option value='[lu_causecode]'>[lu_causecodename]</option>",SelectedFormat="<option value='[lu_causecode]' SELECTED>[lu_causecodename]</option>",SelectedField="lu_causecode",SelectedItems="[FORMAT, [fld_causecodetype, Form], {ISEMPTY:[causecode]}]",UseCache="False"} </select>
Bob Gates
Business Intelligence Force, Inc. (bi4ce)
jengka
Flyweight
Posts:4
10/07/2007 11:48 PM Alert 
I have try to change your code from :


Query="SELECT '' AS lu_causecodename, '' AS lu_causecode
UNION
SELECT causecodegroups.causecodename AS lu_causecodename, causecodegroups.causecode AS lu_causecode
FROM vocaldata.public.causecodegroups causecodegroups
ORDER BY lu_causecodename ASC",



to >>>>>>>>>>>>>>>>>>



Query="SELECT causecodegroups.causecodename AS lu_causecodename, causecodegroups.causecode AS lu_causecode
FROM vocaldata.public.causecodegroups causecodegroups
ORDER BY lu_causecodename ASC",



and it works for postgresql database . thank you
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > NorthWind Sample > problem


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