Thanks. That will work perfectly. Mark
----- Original Message ----- From: "Puneet Kishor" <[EMAIL PROTECTED]> To: "Mark Fuller" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 03, 2004 2:13 PM Subject: Re: [htmltmpl] Select/option How to set "selected"? > Mark Fuller wrote: > > I am creating a select list where all the "option" content comes from a > > mySQL table. The following works fine: > > > > ==================== > > Occupation: <select name="occupation"> > > <TMPL_LOOP NAME=OCCUPATION_LOOP> > > <option value="<TMPL_VAR NAME=VAL>"><TMPL_VAR NAME=TEXT></option> > > </TMPL_LOOP> > > ==================== > > > > How can I specify a row should be "selected"? The TMPL_VAR named "VAL" is a > > numeric index. If I could use TMPL_IF and concatenate the value of "VAL", I > > think it would work. > > > > <TMPL_IF NAME="SEL"<TMPL_VAR NAME="VAL">> > > selected > > </TMPL_IF> > > > > In my program I could set "$sel5 = 1". > > > > Is there any way to do this? > > > > > there are several ways to do this. I prefer simply constructing my sql > in such a way that the selected value is identified > > SELECT val, > text, > (if then else to return 'selected' or '') AS selected > FROM table > WHERE whatever... > > then in my template... > > <tmpl_loop occupations> > <option value="<tmpl_var val>" <tmpl_var selected>> > <tmpl_var text> > </option> > </tmpl_loop> ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ Html-template-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/html-template-users
