Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [olivers] How do I get exact Search Results

Quote Reply
Re: [olivers] How do I get exact Search Results In reply to
Thankx for the help but i now find myself in another mess.

I now have two fields for each record - ShortRegion and Long Region. I want to use a select box that is automatically generated on my search page and only shows the values that appear in the DBASE. I want the box to show Long Region but carry out the search on short region i am using the code below but it doesnt wanna work. Any ideas much appreciated. I am using MS Access and ODBC My SQl Drive to update the database from my local PC so the use of the Short and Long Region fields is not too complex.

sub {
my $tags = shift;
my $table = $DB->table('JOBS_MASTER');
my $sth = $table->select (['DISTINCT SHORTREGION']);
my $output = '<select name=SHORTREGION><OPTION>';
while (my $row = $sth->fetchrow_hashref) {
$output .= '<option value='.$row->{SHORTREGION}.'>'.$row->{LONGREGION}.'</option>';
}
$output .= '</select>';
return $output;
}

Cheers
Subject Author Views Date
Thread How do I get exact Search Results jamesamorris 4535 Aug 18, 2004, 5:51 AM
Thread Re: [jamesamorris] How do I get exact Search Results
olivers 4377 Aug 18, 2004, 8:57 AM
Thread Re: [olivers] How do I get exact Search Results
jamesamorris 4374 Aug 19, 2004, 3:30 AM
Post Re: [jamesamorris] How do I get exact Search Results
olivers 4365 Aug 19, 2004, 4:09 AM
Post Re: [jamesamorris] How do I get exact Search Results
604 4348 Aug 31, 2004, 12:18 PM