🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: bit.databases.mssql-l
Article #129

Re: databases and drop-down menus

#129
From: Mike Plagge
Date: Wed, 20 Sep 2000 00:00
40 lines
2395 bytes
Not a problem.  Do your search page as normal (just use equals and not
contains as it's much faster).  Then, delete the search field.  Start the
DRW.  Be sure to choose just the field(s) to display.  In step 5 of the
wizard, choose drop down list one record per item.  Set your fields to
display (can have it show one field and send the value for another). Then,
finish.  It will make a combo box within a drw.  Make sure to change the
combo box's name to match the first query (should match if they are looking
in the same field).

--
Mike Plagge
Web Master
Cedar Rapids Community Schools
www.cr.k12.ia.us
--
Bob Bawden <bob@aquatext.com> wrote in message news:8qanei$d2s$1@gxsn.com...
> Hi
>
> I am looking for a link or help with databases using drop-down menus
rather
> than search boxes as the query. I can only see how to use search boxes in
> frontpage, which for the small database I am using will result in lots of
> "not found" results. I therefore want to limit the queries to a choice of
> eight or nine values from a dropdown menu...
>
> I use Frontpage 2000 and Dreamweaver 3.
>
> Any ideas?....
>
> Bob
>
> Bob Bawden
> bob@aquatext.com
> http://www.aquatext.com - The Free Online Aquaculture Dictionary
>
>
>
>
>
>
Technical Details
Message-ID: <eEBztbyIAHA.248@cppssbbsa05>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <8qanei$d2s$1@gxsn.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 143382,cc368ab5998e5314
X-Google-Attributes: gid143382,public
X-Google-Thread: 107d46,cc368ab5998e5314
X-Google-Attributes: gid107d46,public
X-Google-Thread: 11355a,cc368ab5998e5314
X-Google-Attributes: gid11355a,public
X-Google-Thread: f6611,cc368ab5998e5314
X-Google-Attributes: gidf6611,public
X-Google-Thread: 105b2f,cc368ab5998e5314
X-Google-Attributes: gid105b2f,public
X-Google-Thread: 109779,cc368ab5998e5314
X-Google-Attributes: gid109779,public
From: "Mike Plagge" <mwplagge@hotmail.com>
Subject: Re: databases and drop-down menus
Date: 2000/09/20
Message-ID: <eEBztbyIAHA.248@cppssbbsa05>
X-Deja-AN: 672112981
References: <8qanei$d2s$1@gxsn.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: Cedar Rapids Community Schools
X-MSMail-Priority: Normal
Reply-To: "Mike Plagge" <mplagge@esc.cr.k12.ia.us>
Newsgroups: bit.databases.mssql-l,bit.listserv.sqlinfo,comp.lang.java.databases,mailing.database.mysql,microsoft.public.frontpage.client,symantec.support.devtools.windows.vcafe4java.Database