473,881 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

drop down population help needed - thanks


In my data base I have a list of componet types e.g. type A - I have 8 off
- type B I have 12 off etc.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

to populate a drop down but would like to use several drop downs
restricting the contents of each drop down to the records pertaining to one
particular componet type eg a drop down only for type A, only for type B
etc.

can this be done if so how?

The other thing I like to do is add the price field to the drop down list
(two fields in one drop down) is this done just by seperating the fields by
a ","?
Jul 19 '05 #1
46 5158
You have two choices.
1) Do it server-side. Display just the first drop down box, then when a
selection is made, post the form back to itself, and prepare/present the
second form.
2) Do it client-side. This is the most common approach, and you'll see tons
of examples on the web.

Tom B

"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...

In my data base I have a list of componet types e.g. type A - I have 8 off
- type B I have 12 off etc.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

to populate a drop down but would like to use several drop downs
restricting the contents of each drop down to the records pertaining to one particular componet type eg a drop down only for type A, only for type B
etc.

can this be done if so how?

The other thing I like to do is add the price field to the drop down list
(two fields in one drop down) is this done just by seperating the fields by a ","?

Jul 19 '05 #2
"Tom B" <sh*****@hotmai l.com> wrote in
news:Oc******** ******@TK2MSFTN GP09.phx.gbl:
You have two choices.
1) Do it server-side. Display just the first drop down box, then when
a selection is made, post the form back to itself, and prepare/present
the second form.
2) Do it client-side. This is the most common approach, and you'll
see tons of examples on the web.

Tom B

"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...

In my data base I have a list of componet types e.g. type A - I have
8 off - type B I have 12 off etc.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

to populate a drop down but would like to use several drop downs
restricting the contents of each drop down to the records pertaining
to

one
particular componet type eg a drop down only for type A, only for
type B etc.

can this be done if so how?

The other thing I like to do is add the price field to the drop down
list (two fields in one drop down) is this done just by seperating
the fields

by
a ","?


Don't want to do it serverside, don't want to refresh the page untill I
get all the selections.

Telling me that I can find it on the web is a bit like telling me search
engines find things, I know there will be millions of people doing this
but I asked here because here I can communicate with a person rather than
look at some unrelated webpage.

--
We are all in the gutter, but some of us are looking at the stars.

=============== =============== =============== =============== =============
Walrus Home alt.binaries.pi ctures.wallpape r <=vote here every weekend.
weekly entries posted on
http://web.newsguy.com/evilsideshowbob/entries.html
FAQ found at http://members.rogers.com/heretic54/
(The most up to date version is posted in alt.binaries.pi ctures.wallpape r
on Mondays and Thursdays. PLEASE READ BEFORE POSTING)
Walrus websites: http://web.newsguy.com/evilsideshowbob/
For Contest Archives & Artists http://www.weeklywalrus.com
For contestants map http://members.shaw.ca/weeklywalrus/home.html
Jul 19 '05 #3
Then you need to refer to a client side newsgroup.

Or, find a website that does what you like, and look at the source.


"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...
"Tom B" <sh*****@hotmai l.com> wrote in
news:Oc******** ******@TK2MSFTN GP09.phx.gbl:
You have two choices.
1) Do it server-side. Display just the first drop down box, then when
a selection is made, post the form back to itself, and prepare/present
the second form.
2) Do it client-side. This is the most common approach, and you'll
see tons of examples on the web.

Tom B

"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...

In my data base I have a list of componet types e.g. type A - I have
8 off - type B I have 12 off etc.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

to populate a drop down but would like to use several drop downs
restricting the contents of each drop down to the records pertaining
to

one
particular componet type eg a drop down only for type A, only for
type B etc.

can this be done if so how?

The other thing I like to do is add the price field to the drop down
list (two fields in one drop down) is this done just by seperating
the fields

by
a ","?


Don't want to do it serverside, don't want to refresh the page untill I
get all the selections.

Telling me that I can find it on the web is a bit like telling me search
engines find things, I know there will be millions of people doing this
but I asked here because here I can communicate with a person rather than
look at some unrelated webpage.

--
We are all in the gutter, but some of us are looking at the stars.

=============== =============== =============== =============== =============
Walrus Home alt.binaries.pi ctures.wallpape r <=vote here every weekend.
weekly entries posted on
http://web.newsguy.com/evilsideshowbob/entries.html
FAQ found at http://members.rogers.com/heretic54/
(The most up to date version is posted in alt.binaries.pi ctures.wallpape r
on Mondays and Thursdays. PLEASE READ BEFORE POSTING)
Walrus websites: http://web.newsguy.com/evilsideshowbob/
For Contest Archives & Artists http://www.weeklywalrus.com
For contestants map http://members.shaw.ca/weeklywalrus/home.html

Jul 19 '05 #4
"Tom B" <sh*****@hotmai l.com> wrote in
news:#v******** ******@TK2MSFTN GP10.phx.gbl:
Then you need to refer to a client side newsgroup.

Or, find a website that does what you like, and look at the source.


"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...
"Tom B" <sh*****@hotmai l.com> wrote in
news:Oc******** ******@TK2MSFTN GP09.phx.gbl:
> You have two choices.
> 1) Do it server-side. Display just the first drop down box, then
> when a selection is made, post the form back to itself, and
> prepare/present the second form.
> 2) Do it client-side. This is the most common approach, and you'll
> see tons of examples on the web.
>
> Tom B
>
> "Kingdom" <ki*******@remo vehotmail.com> wrote in message
> news:Xn******** *************** ******@194.117. 133.134...
>>
>> In my data base I have a list of componet types e.g. type A - I
>> have 8 off - type B I have 12 off etc.
>>
>> I'm using
>>
>> Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
>> Parts_Table")
>>
>> to populate a drop down but would like to use several drop downs
>> restricting the contents of each drop down to the records
>> pertaining to
> one
>> particular componet type eg a drop down only for type A, only for
>> type B etc.
>>
>> can this be done if so how?
>>
>> The other thing I like to do is add the price field to the drop
>> down list (two fields in one drop down) is this done just by
>> seperating the fields
> by
>> a ","?
>
>
>

Don't want to do it serverside, don't want to refresh the page untill
I get all the selections.

Telling me that I can find it on the web is a bit like telling me
search engines find things, I know there will be millions of people
doing this but I asked here because here I can communicate with a
person rather than look at some unrelated webpage.

--
We are all in the gutter, but some of us are looking at the stars.

=============== =============== =============== =============== ==========
=== Walrus Home alt.binaries.pi ctures.wallpape r <=vote here every
weekend. weekly entries posted on
http://web.newsguy.com/evilsideshowbob/entries.html
FAQ found at http://members.rogers.com/heretic54/
(The most up to date version is posted in
alt.binaries.pi ctures.wallpape r on Mondays and Thursdays. PLEASE READ
BEFORE POSTING) Walrus websites:
http://web.newsguy.com/evilsideshowbob/ For Contest Archives &
Artists http://www.weeklywalrus.com For contestants map
http://members.shaw.ca/weeklywalrus/home.html



So what your saying is that if I'm working with ASP and require help with
some aspect that's client based I should'nt seek help here?

And to be halpfull you have gone to the great trouble of pointing out
that other websites have solved this problem and if I look elsewhere I
should find the answer to that which I seek?

Why did you bother to respond at all? you have told me nothing and
explained nothing

--
We are all in the gutter, but some of us are looking at the stars.

=============== =============== =============== =============== =============
Walrus Home alt.binaries.pi ctures.wallpape r <=vote here every weekend.
weekly entries posted on
http://web.newsguy.com/evilsideshowbob/entries.html
FAQ found at http://members.rogers.com/heretic54/
(The most up to date version is posted in alt.binaries.pi ctures.wallpape r
on Mondays and Thursdays. PLEASE READ BEFORE POSTING)
Walrus websites: http://web.newsguy.com/evilsideshowbob/
For Contest Archives & Artists http://www.weeklywalrus.com
For contestants map http://members.shaw.ca/weeklywalrus/home.html
Jul 19 '05 #5
Kingdom wrote:

So what your saying is that if I'm working with ASP and require help
with some aspect that's client based I should'nt seek help here?
Give the man a cigar!

Client-side questions are off-topic in an asp newsgroup. If you take a look
at the other threads in this newsgroup, you will see that we are happy to
help with asp questions.

There are many reasons to keep the newsgroups focussed on specific topics.
If you're not interested in conforming to basic netiquette then you're not
likely to receive much sympathy.

And to be halpfull you have gone to the great trouble of pointing out
that other websites have solved this problem and if I look elsewhere I
should find the answer to that which I seek?

Why did you bother to respond at all? you have told me nothing and
explained nothing


Would you rather we all just ignore this message leaving you wondering why
nobody has responded? Is that what you consider being helpful?

Tom took time out of his day to try and help you by offering suggestions
about where to find your answer, and you respond by telling him to shut up?
I suppose you're going to tell me to shut up now. Don't bother.

--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #6
So what your saying is that if I'm working with ASP and require help with
some aspect that's client based I should'nt seek help here?

And to be halpfull you have gone to the great trouble of pointing out
that other websites have solved this problem and if I look elsewhere I
should find the answer to that which I seek?

Why did you bother to respond at all? you have told me nothing and
explained nothing


Actually...

He has explained
1. You are looking for a client side script.
2. You are asking people who are interested in server side script.
3. What you ask can be done.
4. There are people who are better / more ready to help in another
location.

You have explained
1. You are not willing to do any research to find a good answer.
2. You do not understand newsgroups.
3. You are probably not the best person to write the application you
are working on :)

Jul 19 '05 #7

Yes it may be I need a client based script but my original question was
asp server based.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

and simply wished to know if this line can include a statement to limit
the records displayed in the drop down to a specific group. Now that
might not be possible, iI don't know but it's not java script and I might
have to look at a million webpages to find one that had the statement I'm
looking for, if it is at all possible.

Hence my post.

I'm sorry if my question was not up to the quality you guys require but
this did seem to be the logical place to ask but rather than someone say
yes do this or no there is no way to do that with this statement I end up
geting a lecture on maners and anything but the statement I seek, put
through the third degree, tried, judged and hanged, and book written
about my impertanence for asking.

Thanks a bunch guys no doubt you were all born with your coding skills!
Jul 19 '05 #8
This thread is ammusing. Thanks y'all.

Kingdom, thicken your skin. If this is how you react to a post in a
newsgroup, I'd hate to see how you handle real life. Step back and realize
that you received help.

Ray at work
"Kingdom" <ki*******@remo vehotmail.com> wrote in message
news:Xn******** *************** ******@194.117. 133.134...

Yes it may be I need a client based script but my original question was
asp server based.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table")

and simply wished to know if this line can include a statement to limit
the records displayed in the drop down to a specific group. Now that
might not be possible, iI don't know but it's not java script and I might
have to look at a million webpages to find one that had the statement I'm
looking for, if it is at all possible.

Hence my post.

I'm sorry if my question was not up to the quality you guys require but
this did seem to be the logical place to ask but rather than someone say
yes do this or no there is no way to do that with this statement I end up
geting a lecture on maners and anything but the statement I seek, put
through the third degree, tried, judged and hanged, and book written
about my impertanence for asking.

Thanks a bunch guys no doubt you were all born with your coding skills!

Jul 19 '05 #9
On Tue, 14 Oct 2003 15:58:46 GMT, Kingdom
<ki*******@remo vehotmail.com> wrote:

Yes it may be I need a client based script but my original question was
asp server based.

I'm using

Set objRS = objDC.Execute(" Select DISTINCT Component_Type FROM
Parts_Table" )

and simply wished to know if this line can include a statement to limit
the records displayed in the drop down to a specific group. Now that
might not be possible, iI don't know but it's not java script and I might
have to look at a million webpages to find one that had the statement I'm
looking for, if it is at all possible.

Hence my post.

I'm sorry if my question was not up to the quality you guys require but
this did seem to be the logical place to ask but rather than someone say
yes do this or no there is no way to do that with this statement I end up
geting a lecture on maners and anything but the statement I seek, put
through the third degree, tried, judged and hanged, and book written
about my impertanence for asking.

Thanks a bunch guys no doubt you were all born with your coding skills!


I think your original request has been munged entirely. The way I
understood it, you wanted to be able to dynamically populate a
dropdown based on a selected value from a list. It was stated that
this could be done server side or client side and you said that you
wanted it done client side so that it would not have to go back to the
server each time the user chose a different group. Good idea, and I
agree with it - but that means that the rest of your application will
need to be done client side... no? Once you know how that will be
done, you MAY need to redo your SQL, but you need to know what you
want client side before anyone can help you get it... no?

Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
9331
by: Filiz Duman | last post by:
I was just wondering, is it possible to write into the drop down box in order to jump to a specific item. The reason why I am asking is my drop down box has many items and additionally to the scrolling down, it would be good if the user can write into the box in order to get the specific entry the list selected. Is this possible ? Thanks.
2
2001
by: jagdishl | last post by:
hi I have to populate the second drop down list based on the selection made in the previous drop down list.I have to chose between two values in the first dropdown list i.e city and county.This is the code that I have added to the indexch Private Sub ddlprogtype_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlprogtype.SelectedIndexChanged
3
2999
by: John Walker | last post by:
Hi, On an ASP.NET page I have a drop down list control. When the user pulls down the list and makes a selection, I perform validation, and if the validation fails I want the selected item in the drop down box to go back to what the value was before the user tried to change it, but at that point I will not know what the original value was. Or is there a drop down control "revert" method, or is there any way of knowing what the original...
7
2446
by: callawayglfr | last post by:
I am building a database in access where I have a drop down box that relates to a text box, that part I have working but when someone selects information from the first drop down I need it to limit the second drop down to just the related information. Explaining this is obviously challeging. So I'll try to draw a picture: (drop down 1) Select number --- once selected description is populated in text box (drop down 2) based on first...
6
8318
by: mcgrew.michael | last post by:
I hope this is the right group. I am very new to ASP so this is probably a stupid question. I have some vbscript that query's AD and populates a recordset. I know the recorset contains the information I want by doing a Response.write. I am having problems dynamically creating a drop down list from the data in the recordset. The drop down is created but it is empty. Any help would be greatly appreciated. A sample of the code: <% 'On...
1
3598
by: Jeff Gardner | last post by:
Greetings: I have a table with 3 pieces of data that I would like to use to dynamically populate 3 drop downs using javascript. The fields are state, orgname, office. If it's not already obvious, I'd like orgname drop down to change when a state is selected and I would like office drop down to change when an orgname is selected. I can do this with multiple tables but am having difficulty getting it to work when the data is in the...
3
1937
by: TC | last post by:
Hey All, I have some classes that I recently built for a website which uses the HttpWebRequest & HttpWebResponse objects from the System.Net namespace. Basically, the classes rap submitted data up, connect to external websites on external servers and post / remove the data from these other sites. It works fine locally but when uploaded to the BCentral production server, the outgoing requests get shutdown.
2
1938
by: comerica1 | last post by:
I have the basic structure as follows: 2 drop downs A & B. A is populated using (datasource methods - from database). B is poulated using A's selected value as input and retrieve the list into B. for this I use iframe & dynamic population. so far so good. now there is a 3rd variable based on which I need to make the B's drop down selected.
3
1240
by: mark.norgate | last post by:
Hi Another problem... My drop down is always defaulting to selecting the first item in the drop down, even though I've got code specifically to change it to a different item: Dim adapter As SqlDataAdapter = New SqlDataAdapter("SELECT appId, appName FROM application WHERE segmentID
0
9926
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9776
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10812
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9552
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7952
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7108
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5780
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4194
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.