When modifying a record, the results from the select box doesn't display.

<select NAME="br" VALUE="$rec{'br'}" size="1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
</select>

It automatically shows "1" when modifying. I have the VALUE="$rec{'br'}" but it doesn't show up.

Thanks
Fred

Unfortunately, the select lists don't work that way. In order to have a select list indicate the correct value on the modify form, you have to

1) Define the options for the select list in %db_select_fields in .cfg file

2) Use the following in your form:

|;
print &build_select_field("FieldName","$rec{'FieldName'}");
print qq|





------------------
JPD

Doesn't make sense to me.
Here is the example:

# Select fields. Field name => 'comma seperated list of drop down options'.
%db_select_fields = (
Category => 'General,Configuration Management,Project Management,Process Improvement,Standards,Testing & Quality Assurance',
Type => 'Web,Newsgroup,Mailing List,FTP,Gopher'
);

and here is my drop downbox

<select NAME="garsize" VALUE="$rec{'garsize'}" size="1">
<option value="1 ">1 Car</option>
<option value="2">2 Car</option>
<option value="3">3 Car</option>
<option value="4">4 Car</option>
</select>

another question is it the same for Radio Boxes also?


Thanks
Fred

You need to change your %db_select_fields definition:


If you have more than one select field that you're using, say, bedrooms, it would be:


It goes like this
-- field name
-- =>
-- '
-- your list of options, all on one line, separated by commas, with no spaces before or after the commas
-- '
-- if you have more to define, add a comma at the end. If that's the last one, don't add a comma.

Yes, radio buttons work the same way.


------------------
JPD

That works really great... Can't thankyou enough.....

Fred

Everything was going well until I got to a <textarea>.

How would I handle that?

Fred

A textarea is set up a little differently from the other types of fields.

<textarea rows="4 columns=40 name="FieldName">$rec{'FieldName'}</textarea>



------------------
JPD

I have a way around all of this.


This works fine for me and lets you use your own forms. You can do the same for checkboxes and such using "checked" or the appropriate attribute.

Chris


------------------
webmaster@racedaze.com

[This message has been edited by ChrisE (edited May 18, 1999).]