Re: Drop Down Selection From Database

You should be able to use DBI::CSV to parse that file and select the lines you want. Then, you can use the handy-dandy select method from CGI to create a properly formatted select form item.

Multiple examples of the use of each of these are scattered about the site.

--
$you = new YOU;
honk() if $you->love(perl)

Comment on Re: Drop Down Selection From Database

Replies are listed 'Best First'.
Re: Re: Drop Down Selection From Database by ok (Beadle) on Jan 26, 2001 at 03:26 UTC
Hope I'm not telling you what you already know, but if you need to pull the column names out of the table, you could go with opening up a filehandle and splitting. But I agree with the above: using DBD::CSV will scale nicely if you expect your app and data to grow beyond the usefulness of a flat text db.	[reply]
Re: Re: Re: Drop Down Selection From Database by extremely (Priest) on Jan 26, 2001 at 04:09 UTC
Yeah, I got all kinds of split-fu =) DBD::CSV get's you SQL-style syntax with the files. That is a nice thing to have. -- $you = new YOU; honk() if $you->love(perl)	[reply]