Re: multiple fields from SQL query

Mark Haney wrote:
> I've got a query in my perl code to pull 2 fields from a database
> (abbreviation, factory_id), one of which is used to populate a
> dropdown box (abbreviation).  However, I will need to pass /both/
> fields to the CGI script that I'm calling from the form that has the
> dropdown box. How do I do that?  Here's what I have so far:

I think what you want to do is print two input elements in your form.
One dropdown box for abbreviation and one for factory_id. The one for
factory_id might well be a text input and might well be hidden. YMMV