<img src='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='desktopmodules/ntforums/images/emoticons/biggrin.gif' height='20' width='20' border='0' title='Big Grin' align='absmiddle'>

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>

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