Re: Net.data

Here's how we do it:


 %{ -----------------------------------------------------
    Fill drop down for Location
    ----------------------------------------------------- %}

 %FUNCTION(DTW_SQL) Location_query (  ) {

 SELECT
 CDCODE, CDCDDS
 FROM xxf99

 where CDCDTP = 'LOCAT'
 order by CDCDDS


   %report  {

 <select name="Location">
     %if ( $(Location) == "*Any")
     <option value="*Any"SELECTED>*Any
     %else
   <option value="*Any">*Any
   %endif
 %row{
   %if ( $(Location) == $(V1) )
   <option value="$(V1)"SELECTED>$(V2)
   %else
   <option value="$(V1)">$(V2)
   %endif
   %}
</select>
 %}

%}


Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100


                                                                       
             "Don Cavaiani"                                            
             <dcavaiani@amereq                                         
             uip.com>                                                    To
             Sent by:                  "Web Enabling the AS400 / iSeries"
             web400-bounces@mi         <web400@xxxxxxxxxxxx>         
             drange.com                                                  cc
                                                                       
                                                                    Subject
             12/14/2006 08:03          [WEB400] Net.data             
             AM                                                        
                                                                       
                                                                       
             Please respond to                                         
             Web Enabling the                                          
              AS400 / iSeries                                          
             <web400@midrange.                                       
                   com>                                                
                                                                       
                                                                       





Good Morning,
Don't know if this is the best place to ask this question? I was wondering
if in net.data it is possible to "load up" a drop down list by reading a
System i database via SQL? Say you had all of the state names in a file, and
the user had to use a drop down list to select their state. Could that drop
down list have been populated with the SQL against the database?
Regards,

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

'Treat every person with kindness and respect, even those who are rude to
you. Remember that you show compassion to others not because of who they are
but because of who you are.'--Andrew T. Somers

"When faced with the choice of being 'right' or being 'kind', choose the
kind option every time."


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.