Date:  01/27/2006 12:01:28 AM Msg ID:  002830
From:  Jasper de Graaf Thread:  002755
Subject:  Re: Drop list populated by a DBF table
This code works for me. Option group filled by data in cursor/table mw_sets. Current id in lcGroep will be selected. Data is submitted onhange!
 
Response.Write([<FORM METHOD="post">]+CRLF)
Response.Write([<SELECT NAME="groep" SIZE="1" onChange="this.form.submit();">]+CRLF)
SELECT mw_sets
SCAN  && mw_sets
 Response.Write( [<OPTION ]+ ;
                  IIF(mw_sets.id=lcgroep,[SELECTED],[])+ ;
                  [ VALUE="]+mw_sets.id+[">]+ ;
                  ALLTRIM(mw_sets.description)+ ;
                  [</OPTION>] + CRLF)
ENDSCAN
Response.Write([</SELECT>]+CRLF)
Response.Write([</FORM>]+CRLF)
 
Sent by MB Reyes on 11/24/2005 10:26:21 PM:
Hi all!
Can anyone help? I'd like to populate a dropdown listbox with records from a VFP table. How's this done in a foxweb script?
 
Thanks in advance to anyone who can help out!
 
Regards