cannot get result in dropdown

[vikas_gopal]

Hello Everyone,
I have the following simple xml code but nothing is appearing in the dropdown. Please help me with the code.

| dbquery "Finance Database" "select book_type_code from fa_deprn_periods" book_type_code=$book_type_code$ | fields book_type_code

Select series
<![CDATA[ | dbquery "Finance Database" "select book_type_code from fa_deprn_periods"]]>
Any

Thanks in advance

[vikas_gopal · Accepted solution]

Finally I crack this and i did not believe it was just a silly mistake. I just mentioned field name in "" in the dbquery which is "bookcode".So keep this in mind whatever you are mentioning in the fieldforvalue and fieldforlable should be similar to ur field name in dbquery that is it.
here is my code

<!-- Define a simple dropdown form driven by a search -->

Select series

<![CDATA[| dbquery "Finance Database" "select distinct book_type_code "bookcode" from fa_deprn_periods where period_name='JAN-09' and book_type_code='CORPORATE USA'" ]]>

[vikas_gopal]

Please help...any solution..?