Kathleen
Sat Mar 12 07:29:44 CST 2005
You're welcome :-)
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
"Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
news:490CD99B-3E81-4C0B-9AF4-C6BF67824294@microsoft.com...
> Hi Kathleen - me again!!!
>
> Scratch that last reply, I have just got the gist - I have copied the
> field
> form a dummy result based on the fields in the table I wanted and then
> added
> the field to the innput form and it work!
>
> Hurrah - thank you!
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> How to filter a database query by using a drop-down list in FrontPage
>>
http://support.microsoft.com/kb/235554
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web:
http://www.spiderwebwoman.com/resources/
>> blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
>>
>>
>>
>> "Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
>> news:A5403052-2316-4EC5-B27B-6ADBBA9D19D2@microsoft.com...
>> > Thanks for this Stefan,
>> >
>> > Can I be really stupid - cos I use the database wizard most of the time
>> > or
>> > create a form from sctratch and just select the database from my site
>> > list
>> > I
>> > am not sure how to use two database sources.
>> >
>> > You say "opened as a DB connection to objRS", is there a KB article on
>> > this?
>> >
>> > Cheers
>> >
>> > Jonathan
>> >
>> > "Stefan B Rusynko" wrote:
>> >
>> >> To display all values from a table (opened as a DB connection to
>> >> objRS)
>> >>
>> >> <%
>> >> objRS.MoveFirst
>> >> Do While Not objRS.EOF
>> >> %>
>> >> <option value="<%= objRS.Fields("FieldName")%>">
>> >> <%=objRS.Fields("FieldName")%></option>
>> >> <%
>> >> objRS.MoveNext
>> >> Loop
>> >> %>
>> >>
>> >> --
>> >>
>> >> _____________________________________________
>> >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
>> >> "Warning - Using the F1 Key will not break anything!" (-;
>> >> To find the best Newsgroup for FrontPage support see:
>> >>
http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >> _____________________________________________
>> >>
>> >>
>> >> "Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
>> >> news:37C161C3-B049-492F-A56E-32AAFD9EE066@microsoft.com...
>> >> | Hi Everyone!
>> >> |
>> >> | TGIF!!!!!!
>> >> |
>> >> | I have been trying to find a way to make the contents of a list box
>> >> on
>> >> an
>> >> | input form use the values from a db table. I know how to do this
>> >> for a
>> >> | results page but how do I do it for a form?
>> >> |
>> >> | Tia
>> >> |
>> >> |
>> >> | Jonathan
>> >>
>> >>
>> >>
>>
>>
>>