Do you have a link or anything that you can post?
To populate your 10 listboxes, you can execute 10 queries, if each of them
contains different data. You could do it all in one and then use your ASP
code to determine when one starts and the other ends, but that would be a
bit of a headache. I can't tell if today is a day that I have a low
comprehension level and I'm not understanding where you're stuck, or if
you're not explaining where you're stuck. :]
Ray at work
"Guy Hocking" <guy@ANTIbradflack.SPAMcom> wrote in message
news:%23eSrk$E4DHA.2132@TK2MSFTNGP10.phx.gbl...[color=blue]
> I am displaying the whole form at the same time but i havnt yet de-limited
> the list boxes in accordance to each other - that will be later.....
>
> if i use the WHERE claus, will it be conditional (i like that word ;-) ?[/color]
as[color=blue]
> the data needs to be displyed on the same page according to what was
> selected in the form on the previous page.
>
> So they will vary, but not all of the WHERE claus will be relevant.....[/color]
and[color=blue]
> thats one hell of a statement with 10 list boxes and 20 values in each!?
> what you reckon?
>
>
> --
> Guy
>
>
www.bradflack.com
>
> Please remove ANTI and SPAM from my
> email address before sending me an email.
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:eKslc3E4DHA.1700@TK2MSFTNGP11.phx.gbl...[color=green]
> > You can have multiple conditions in your WHERE clause. Typically what[/color][/color]
you[color=blue][color=green]
> > do is present the user with the first option he has to specify, like the
> > continent. And then, based on the continent selected, you display a[/color][/color]
list[color=blue]
> of[color=green]
> > countries. Then, based on what country the user selects, you display a[/color]
> list[color=green]
> > of cities. This is a one-step-at-a-time thing if you're doing it all in[/color]
> ASP[color=green]
> > (as opposed to client side arrays or something).
> >
> > Are you displaying a form that has areas and regions both listed at the[/color]
> same[color=green]
> > time? Or are you just displaying one part at a time?
> >
> > You can have multiple conditions in your WHERE clause.
> >
> > sSQL = "SELECT vchrSolution_Name, vchrChannel,intTotalSols FROM
> > vw_SOLS_NationalCount_u ORDER BY vchrSolution_name, vchrchannel WHERE
> > YourColumnName='" & sWhereValue & "' AND YourOtherColumnName='" &
> > sOtherValue & "'"
> >
> > Ray at work
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "Guy Hocking" <guy@ANTIbradflack.SPAMcom> wrote in message
> > news:ubI2twE4DHA.1596@TK2MSFTNGP10.phx.gbl...[color=darkred]
> > > Thanks for the response....
> > >
> > > The only prob with that is that there are many list boxes and many[/color][/color]
> option[color=green]
> > in[color=darkred]
> > > each -
> > >
> > > So if lstRegion = SouthEast and lstArea = London then data for london[/color][/color]
> will[color=green][color=darkred]
> > > need selecting
> > > But if if lstRegion = SouthEast and lstArea = Essex then different[/color][/color][/color]
data[color=blue]
> is[color=green][color=darkred]
> > > selected.
> > >
> > > or if lstRegion = SouthWest and lstArea = Exeter......
> > >
> > > And so on.... + loads more conditions and dates and stuff....
> > > Any ideas?
> > >
> > > not sure if iv helped explain the prob
> > >
> > > --
> > > Guy
> > >
> > >
www.bradflack.com
> > >
> > > Please remove ANTI and SPAM from my
> > > email address before sending me an email.
> > > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in[/color][/color][/color]
message[color=blue][color=green][color=darkred]
> > > news:uJU56mE4DHA.3576@TK2MSFTNGP11.phx.gbl...
> > > > What you're looking for is a WHERE clause.
> > > >
> > > > <%
> > > > sWhereValue = Session("something")
> > > > ''Do you need to use a session variable as opposed to request.form?
> > > >
> > > > sSQL = "SELECT vchrSolution_Name, vchrChannel,intTotalSols FROM
> > > > vw_SOLS_NationalCount_u ORDER BY vchrSolution_name, vchrchannel[/color][/color][/color]
WHERE[color=blue][color=green][color=darkred]
> > > > YourColumnName='" & sWhereValue & "'"
> > > >
> > > > '''If your column that you use in your WHERE clause is numeric, do[/color][/color][/color]
not[color=blue][color=green][color=darkred]
> > > > delimit the value with '.
> > > >
> > > > Set RS = DataConnection.Execute(sSQL)
> > > > %>
> > > >
> > > > Ray at work
> > > >
> > > >
> > > > "Guy Hocking" <guy@ANTIbradflack.SPAMcom> wrote in message
> > > > news:eOUTliE4DHA.2380@TK2MSFTNGP09.phx.gbl...
> > > >
> > > > >
> > > > > ****
> > > > > Set RS = DataConnection.Execute("SELECT vchrSolution_Name,[/color]
> > vchrChannel,[color=darkred]
> > > > > intTotalSols FROM vw_SOLS_NationalCount_u ORDER BY[/color][/color]
> vchrSolution_name,[color=green][color=darkred]
> > > > > vchrchannel")
> > > > > ****
> > > > >
> > > > > Basically i need to know how to filter a SELECT statement in[/color][/color]
> relation[color=green]
> > to[color=darkred]
> > > > > what is in the session variable list boxes, ideally a conditional[/color]
> > SELECT[color=darkred]
> > > > > statement to minimise the data in the RecordSet.
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
