Re: using DBI oracle to make scrolling lists(drop down menus)

Is there a good way out there to do this same thing with different tables. I mean if you have a form with several list box's like this what would be a good way to fetch data from more than one table in the same database database.

thanks

Comment on Re: using DBI oracle to make scrolling lists(drop down menus)

Replies are listed 'Best First'.
Re: Re: using DBI oracle to make scrolling lists(drop down menus) by thunders (Priest) on Jan 22, 2002 at 17:23 UTC
yes, if your tables are related you would do it in the same statement. `#this part might be different depending on how your db does SQL my $people_query = $dbh->prepare("SELECT ss_number, f_name, l_name, st +ate FROM people, states WHERE people.stID = states.stID");` [download] If your tables are not related you would use multiple statement handles like the one above. As long as they have different names you can manipulate them indepedently.	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: using DBI oracle to make scrolling lists(drop down menus)
by thunders (Priest) on Jan 22, 2002 at 17:23 UTC

#this part might be different depending on how your db does SQL
my $people_query = $dbh->prepare("SELECT ss_number, f_name, l_name, st
+ate FROM people, states WHERE people.stID = states.stID");
[download]

[reply]
[d/l]