I have a dropdown that I want the user to see information side by side. I
have created that. When the user selects the appropriate information ID is
passed. Can the dropdown pass 2 values with a single selection? The
dropdown is populated from database records.

<select NAME="ClassID" SIZE="1"><option
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
ieldHTML(fp_rs,"Date")%></option></select>

Thanks

Dave

In general no, however to do so you would have to combine the value into one, then on the page
receiving the value you would have to split the value back into individual values. But in order to
split the values, both values must always be a set number of characters.


<select NAME="ClassID" SIZE="1"><option
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_FieldHTML(fp_rs,"Class")%
><%=FP_FieldHTML(fp_rs,"Date")%></option></select>


Next page

Dim ClassID1
ClassID1 = Request.Form("ClassID")

ID = Left(ClassID1,6)
Date = Right(ClassID,8)

Note: Date is a reserved word, rename your field.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I have a dropdown that I want the user to see information side by side. I
> have created that. When the user selects the appropriate information ID is
> passed. Can the dropdown pass 2 values with a single selection? The
> dropdown is populated from database records.
>
> <select NAME="ClassID" SIZE="1"><option
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> ieldHTML(fp_rs,"Date")%></option></select>
>
> Thanks
>
> Dave
>
>

I'd use some character to seperate the 2 values so you might have

<option value="some value|some other value">
and then split them

<%
aTemp = split(request("dropdown"), "|")
strvalue1 = aTemp(0)
strvalue1 = aTemp(1)
%>

--
Cheers,
Jon
Microsoft MVP - FP

Thomas A. Rowe wrote:
> In general no, however to do so you would have to combine the value
> into one, then on the page receiving the value you would have to
> split the value back into individual values. But in order to split
> the values, both values must always be a set number of characters.
>
>
> <select NAME="ClassID" SIZE="1"><option
>
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
ieldHTML(fp_rs,"Class")%
>> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
>
>
> Next page
>
> Dim ClassID1
> ClassID1 = Request.Form("ClassID")
>
> ID = Left(ClassID1,6)
> Date = Right(ClassID,8)
>
> Note: Date is a reserved word, rename your field.
>
> "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have a dropdown that I want the user to see information side by
>> side. I have created that. When the user selects the appropriate
>> information ID is passed. Can the dropdown pass 2 values with a
>> single selection? The dropdown is populated from database records.
>>
>> <select NAME="ClassID" SIZE="1"><option
>>
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
>> ieldHTML(fp_rs,"Date")%></option></select>
>>
>> Thanks
>>
>> Dave

Jon,

Great alternative, for what Dave want to do.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jon Spivey" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I'd use some character to seperate the 2 values so you might have
>
> <option value="some value|some other value">
> and then split them
>
> <%
> aTemp = split(request("dropdown"), "|")
> strvalue1 = aTemp(0)
> strvalue1 = aTemp(1)
> %>
>
> --
> Cheers,
> Jon
> Microsoft MVP - FP
>
> Thomas A. Rowe wrote:
> > In general no, however to do so you would have to combine the value
> > into one, then on the page receiving the value you would have to
> > split the value back into individual values. But in order to split
> > the values, both values must always be a set number of characters.
> >
> >
> > <select NAME="ClassID" SIZE="1"><option
> >
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> ieldHTML(fp_rs,"Class")%
> >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> >
> >
> > Next page
> >
> > Dim ClassID1
> > ClassID1 = Request.Form("ClassID")
> >
> > ID = Left(ClassID1,6)
> > Date = Right(ClassID,8)
> >
> > Note: Date is a reserved word, rename your field.
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> I have a dropdown that I want the user to see information side by
> >> side. I have created that. When the user selects the appropriate
> >> information ID is passed. Can the dropdown pass 2 values with a
> >> single selection? The dropdown is populated from database records.
> >>
> >> <select NAME="ClassID" SIZE="1"><option
> >>
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> >> ieldHTML(fp_rs,"Date")%></option></select>
> >>
> >> Thanks
> >>
> >> Dave
>
>

Thanks! I am off typing away with new ideas.

Dave

"Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a dropdown that I want the user to see information side by side. I
> have created that. When the user selects the appropriate information ID
is
> passed. Can the dropdown pass 2 values with a single selection? The
> dropdown is populated from database records.
>
> <select NAME="ClassID" SIZE="1"><option
>
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> ieldHTML(fp_rs,"Date")%></option></select>
>
> Thanks
>
> Dave
>
>

I am half way there. I passed 2 values as your option line suggested.

But I can't split them I get a page error.

The dropdown is called CLASSID I assume that goes where "dropdown" is below.

Where does the code go on the confirm page? I have tried the Body, Head,
above the Head all return error messages.

Thanks


"Jon Spivey" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'd use some character to seperate the 2 values so you might have
>
> <option value="some value|some other value">
> and then split them
>
> <%
> aTemp = split(request("dropdown"), "|")
> strvalue1 = aTemp(0)
> strvalue1 = aTemp(1)
> %>
>
> --
> Cheers,
> Jon
> Microsoft MVP - FP
>
> Thomas A. Rowe wrote:
> > In general no, however to do so you would have to combine the value
> > into one, then on the page receiving the value you would have to
> > split the value back into individual values. But in order to split
> > the values, both values must always be a set number of characters.
> >
> >
> > <select NAME="ClassID" SIZE="1"><option
> >
>
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> ieldHTML(fp_rs,"Class")%
> >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> >
> >
> > Next page
> >
> > Dim ClassID1
> > ClassID1 = Request.Form("ClassID")
> >
> > ID = Left(ClassID1,6)
> > Date = Right(ClassID,8)
> >
> > Note: Date is a reserved word, rename your field.
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> I have a dropdown that I want the user to see information side by
> >> side. I have created that. When the user selects the appropriate
> >> information ID is passed. Can the dropdown pass 2 values with a
> >> single selection? The dropdown is populated from database records.
> >>
> >> <select NAME="ClassID" SIZE="1"><option
> >>
>
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> >> ieldHTML(fp_rs,"Date")%></option></select>
> >>
> >> Thanks
> >>
> >> Dave
>
>

Slight mod to Jon code, place above the opening <html> tag:

<%
aTemp = split(request.form("CLASSID"), "|")
ClassID = aTemp(0)
ClassDate = aTemp(1)
%>


The to display in the body of the page:

<%=ClassID%>

<%=ClassDate%>



--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I am half way there. I passed 2 values as your option line suggested.
>
> But I can't split them I get a page error.
>
> The dropdown is called CLASSID I assume that goes where "dropdown" is below.
>
> Where does the code go on the confirm page? I have tried the Body, Head,
> above the Head all return error messages.
>
> Thanks
>
>
> "Jon Spivey" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I'd use some character to seperate the 2 values so you might have
> >
> > <option value="some value|some other value">
> > and then split them
> >
> > <%
> > aTemp = split(request("dropdown"), "|")
> > strvalue1 = aTemp(0)
> > strvalue1 = aTemp(1)
> > %>
> >
> > --
> > Cheers,
> > Jon
> > Microsoft MVP - FP
> >
> > Thomas A. Rowe wrote:
> > > In general no, however to do so you would have to combine the value
> > > into one, then on the page receiving the value you would have to
> > > split the value back into individual values. But in order to split
> > > the values, both values must always be a set number of characters.
> > >
> > >
> > > <select NAME="ClassID" SIZE="1"><option
> > >
> >
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> > ieldHTML(fp_rs,"Class")%
> > >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> > >
> > >
> > > Next page
> > >
> > > Dim ClassID1
> > > ClassID1 = Request.Form("ClassID")
> > >
> > > ID = Left(ClassID1,6)
> > > Date = Right(ClassID,8)
> > >
> > > Note: Date is a reserved word, rename your field.
> > >
> > > "Dave" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > >> I have a dropdown that I want the user to see information side by
> > >> side. I have created that. When the user selects the appropriate
> > >> information ID is passed. Can the dropdown pass 2 values with a
> > >> single selection? The dropdown is populated from database records.
> > >>
> > >> <select NAME="ClassID" SIZE="1"><option
> > >>
> >
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> > >> ieldHTML(fp_rs,"Date")%></option></select>
> > >>
> > >> Thanks
> > >>
> > >> Dave
> >
> >
>
>

It is so close I can feel it! See below starts ClassID

Thanks

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Slight mod to Jon code, place above the opening <html> tag:
>
> <%
> aTemp = split(request.form("CLASSID"), "|")
> ClassID = aTemp(0) - I get The page cannot be displayed ( Subscript out of
range number 0)
> ClassDate = aTemp(1)
> %>
>
>
> The to display in the body of the page:
>
> <%=ClassID%>
>
> <%=ClassDate%>
>
>
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > I am half way there. I passed 2 values as your option line suggested.
> >
> > But I can't split them I get a page error.
> >
> > The dropdown is called CLASSID I assume that goes where "dropdown" is
below.
> >
> > Where does the code go on the confirm page? I have tried the Body,
Head,
> > above the Head all return error messages.
> >
> > Thanks
> >
> >
> > "Jon Spivey" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I'd use some character to seperate the 2 values so you might have
> > >
> > > <option value="some value|some other value">
> > > and then split them
> > >
> > > <%
> > > aTemp = split(request("dropdown"), "|")
> > > strvalue1 = aTemp(0)
> > > strvalue1 = aTemp(1)
> > > %>
> > >
> > > --
> > > Cheers,
> > > Jon
> > > Microsoft MVP - FP
> > >
> > > Thomas A. Rowe wrote:
> > > > In general no, however to do so you would have to combine the value
> > > > into one, then on the page receiving the value you would have to
> > > > split the value back into individual values. But in order to split
> > > > the values, both values must always be a set number of characters.
> > > >
> > > >
> > > > <select NAME="ClassID" SIZE="1"><option
> > > >
> > >
> >
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> > > ieldHTML(fp_rs,"Class")%
> > > >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> > > >
> > > >
> > > > Next page
> > > >
> > > > Dim ClassID1
> > > > ClassID1 = Request.Form("ClassID")
> > > >
> > > > ID = Left(ClassID1,6)
> > > > Date = Right(ClassID,8)
> > > >
> > > > Note: Date is a reserved word, rename your field.
> > > >
> > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > >> I have a dropdown that I want the user to see information side by
> > > >> side. I have created that. When the user selects the appropriate
> > > >> information ID is passed. Can the dropdown pass 2 values with a
> > > >> single selection? The dropdown is populated from database records.
> > > >>
> > > >> <select NAME="ClassID" SIZE="1"><option
> > > >>
> > >
> >
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> > > >> ieldHTML(fp_rs,"Date")%></option></select>
> > > >>
> > > >> Thanks
> > > >>
> > > >> Dave
> > >
> > >
> >
> >
>
>

The dropdown was created using the Results wizard - does that matter?
I tried using <%=ClassID%> to show the ClassID which is the name of the
dropdown and I do not get results.

Are webbots playing into this issue? I can see the joined field names
using the Confirmation Field entry for ClassID.

Don't give up on me yet.

Dave

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Slight mod to Jon code, place above the opening <html> tag:
>
> <%
> aTemp = split(request.form("CLASSID"), "|")
> ClassID = aTemp(0)
> ClassDate = aTemp(1)
> %>
>
>
> The to display in the body of the page:
>
> <%=ClassID%>
>
> <%=ClassDate%>
>
>
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Dave" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> > I am half way there. I passed 2 values as your option line suggested.
> >
> > But I can't split them I get a page error.
> >
> > The dropdown is called CLASSID I assume that goes where "dropdown" is
below.
> >
> > Where does the code go on the confirm page? I have tried the Body,
Head,
> > above the Head all return error messages.
> >
> > Thanks
> >
> >
> > "Jon Spivey" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I'd use some character to seperate the 2 values so you might have
> > >
> > > <option value="some value|some other value">
> > > and then split them
> > >
> > > <%
> > > aTemp = split(request("dropdown"), "|")
> > > strvalue1 = aTemp(0)
> > > strvalue1 = aTemp(1)
> > > %>
> > >
> > > --
> > > Cheers,
> > > Jon
> > > Microsoft MVP - FP
> > >
> > > Thomas A. Rowe wrote:
> > > > In general no, however to do so you would have to combine the value
> > > > into one, then on the page receiving the value you would have to
> > > > split the value back into individual values. But in order to split
> > > > the values, both values must always be a set number of characters.
> > > >
> > > >
> > > > <select NAME="ClassID" SIZE="1"><option
> > > >
> > >
> >
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> > > ieldHTML(fp_rs,"Class")%
> > > >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> > > >
> > > >
> > > > Next page
> > > >
> > > > Dim ClassID1
> > > > ClassID1 = Request.Form("ClassID")
> > > >
> > > > ID = Left(ClassID1,6)
> > > > Date = Right(ClassID,8)
> > > >
> > > > Note: Date is a reserved word, rename your field.
> > > >
> > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > >> I have a dropdown that I want the user to see information side by
> > > >> side. I have created that. When the user selects the appropriate
> > > >> information ID is passed. Can the dropdown pass 2 values with a
> > > >> single selection? The dropdown is populated from database records.
> > > >>
> > > >> <select NAME="ClassID" SIZE="1"><option
> > > >>
> > >
> >
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> > > >> ieldHTML(fp_rs,"Date")%></option></select>
> > > >>
> > > >> Thanks
> > > >>
> > > >> Dave
> > >
> > >
> >
> >
>
>

Somewhere on your page after the code below, add:

<%=aTemp%>

so that you can see if aTemp actually has a value.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Dave" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> It is so close I can feel it! See below starts ClassID
>
> Thanks
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Slight mod to Jon code, place above the opening <html> tag:
> >
> > <%
> > aTemp = split(request.form("CLASSID"), "|")
> > ClassID = aTemp(0) - I get The page cannot be displayed ( Subscript out of
> range number 0)
> > ClassDate = aTemp(1)
> > %>
> >
> >
> > The to display in the body of the page:
> >
> > <%=ClassID%>
> >
> > <%=ClassDate%>
> >
> >
> >
> > --
> > ==============================================
> > Thomas A. Rowe (Microsoft MVP - FrontPage)
> > WEBMASTER Resources(tm)
> > http://www.ycoln-resources.com
> > FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> > ==============================================
> > To assist you in getting the best answers for FrontPage support see:
> > http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> > "Dave" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > > I am half way there. I passed 2 values as your option line suggested.
> > >
> > > But I can't split them I get a page error.
> > >
> > > The dropdown is called CLASSID I assume that goes where "dropdown" is
> below.
> > >
> > > Where does the code go on the confirm page? I have tried the Body,
> Head,
> > > above the Head all return error messages.
> > >
> > > Thanks
> > >
> > >
> > > "Jon Spivey" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > I'd use some character to seperate the 2 values so you might have
> > > >
> > > > <option value="some value|some other value">
> > > > and then split them
> > > >
> > > > <%
> > > > aTemp = split(request("dropdown"), "|")
> > > > strvalue1 = aTemp(0)
> > > > strvalue1 = aTemp(1)
> > > > %>
> > > >
> > > > --
> > > > Cheers,
> > > > Jon
> > > > Microsoft MVP - FP
> > > >
> > > > Thomas A. Rowe wrote:
> > > > > In general no, however to do so you would have to combine the value
> > > > > into one, then on the page receiving the value you would have to
> > > > > split the value back into individual values. But in order to split
> > > > > the values, both values must always be a set number of characters.
> > > > >
> > > > >
> > > > > <select NAME="ClassID" SIZE="1"><option
> > > > >
> > > >
> > >
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%><%=FP_FieldHTML(fp_rs,"Date")%>"><%=FP_F
> > > > ieldHTML(fp_rs,"Class")%
> > > > >> <%=FP_FieldHTML(fp_rs,"Date")%></option></select>
> > > > >
> > > > >
> > > > > Next page
> > > > >
> > > > > Dim ClassID1
> > > > > ClassID1 = Request.Form("ClassID")
> > > > >
> > > > > ID = Left(ClassID1,6)
> > > > > Date = Right(ClassID,8)
> > > > >
> > > > > Note: Date is a reserved word, rename your field.
> > > > >
> > > > > "Dave" <(E-Mail Removed)> wrote in message
> > > > > news:(E-Mail Removed)...
> > > > >> I have a dropdown that I want the user to see information side by
> > > > >> side. I have created that. When the user selects the appropriate
> > > > >> information ID is passed. Can the dropdown pass 2 values with a
> > > > >> single selection? The dropdown is populated from database records.
> > > > >>
> > > > >> <select NAME="ClassID" SIZE="1"><option
> > > > >>
> > > >
> > >
> VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%<%=FP_F
> > > > >> ieldHTML(fp_rs,"Date")%></option></select>
> > > > >>
> > > > >> Thanks
> > > > >>
> > > > >> Dave
> > > >
> > > >
> > >
> > >
> >
> >
>
>