Create Drop-down With Categories From ID's???
I've got a products table and a productCategories table related by a categoryID field. The categories table uses autonumber for the categoryID and I've got about 4 or 5 different categories in there right now.
I'm creating an Add Product page now and I'd like to create a drop down menu with which to select the correct category. How do I make it so that my drop down menu actually shows the category names and then populates my tables accordingly?
I won't need to ever add a new category here, simply use the current categories in a drop down so I don't have to guess/remember which number is which category.
View Replies
ADVERTISEMENT
I have created a dropdown menu that allows users to navigate and load other pages into a different frame (detail) than the one in which the dropdown is sited. All menu items and urls are stored in an access db.
Now I would like to try and make 2 improvements but I don't know how:
1. I would like to use the [Category] field in my data set to produce (non-clickable) headings in the drop down list. Code:
View Replies
View Related
I have to create a drop down, thats easy, my dilema is :
how do I create a drop down that allows the user to be able to select more than 1 field in that drop down? Is this at all possible? How would I go about doing this?
View Replies
View Related
i want to have a search program that has multiple categories.
anybody can give a sample?
View Replies
View Related
I am using MS Access & open 3 table, 1 for Product 1 for Genre, 1 more for Product_Genre (because one product maybe have many categories)
But when I have tried many ways to delete one of categories, also fail to do it.
What I want to do is : When delete a category,
1) it must delete the Product which is under the Category (to be delete)
2) at the same time it must also delete the records from table 'Product_Genre' which is related with the Category (to be deleted)Code:
View Replies
View Related
I have a list in a database that I have categorised using a category field. I now want to retrieve all records but grouped by categories. how do i get my asp to loop through each category creating a recordset for each one rather than hard code a new recordset for each category i would rather it did it dynamically if thats possible ??? Code:
View Replies
View Related
i am working on ecommerce site and would like to display the categories (and sub categories) from the db recursively,
i did it but i also want to add the level of each category like :
main_cat_1 (level 1)
--------sub_1 (level 1_1)
--------sub_2 (level 1_2)
------------sub_sub_2 (level 1_2_1)
------------sub_sub_2 (level 1_2_2)
------------sub_sub_2 (level 1_2_3)
--------sub_3 (level 1_3)
main_cat_2 (level 2)
main_cat_3 (level 3)
--------sub_3 (level 3_1)
and so on ... how can i do that ?
View Replies
View Related
im developing a Product configurator (just like alienware use) where in my database i have
(systems table) a list of PC systems
systemID
(categories table) a list of PC product categories (ie. CPU, RAM...)
categoryID
(products table) a list of all products
productID, catID
(link table)
sysID and prodID
Now before i put the code ive done so far, let me explain that the first page lists all systems wich then gives the systemID for the link table. Once this page loads it needs to go through each category then list the products available to that category where sysID = systemID. Now a query i put together to list all products for that sysID is:
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=systemID
Now this query works great and lists all of the products for that systemID, but what im unable to do is (using GetRows()) have the category name listed as a title then have each product under the respected category. Code:
View Replies
View Related
I want to put my existing review books webpage in Asp/Database because I have more than 5000 of them and its now too complicated to keep tracks of it all in HTML only. My database is ready, I know how to connect to it, how to list records and how to select in them, I know how to pass a variable from a page to another, I know how to add, modify and delete records... yeah its about that so far.
Here is how I want my website to look like. I want to have physical pages categories, like all the science fiction books should be listed in sf pages separated alphabetically Ex reviews of Lord of the ring will be in sciencefictionT.asp and so on for each categories. I want too that a page with all the reviews listed linking to the right place. In my database I have already categories for each books.So is it possible to do or I complicate my life too much?
I know that it would be much more easier just to make a review.asp and have the review one at the time there, but I like the way my website is already is, that make it different from others.
View Replies
View Related
I have a default catalogue/product page (code shown below list_item.asp) which list all the products from the database. But since I have lots of category in the catalog/product page, i want to separate them according to their respective categories like writing instruments, desktops, pantry etc.
This will enable the user to go to a respective page and choose the individual product from the respective categories. If I adjust the SQL statement to be "SELECT * from Product " WHERE category LIKE 'DESKTOPS', this page will lists all the items from that category selection. But if i were to make another page such as pen.asp and adjust the SQL statement to category LIKE 'PEN'.
The first page lists the products from the pen category and the following page unfortunately shows category from Desktops. how to segragate these categories so that it will only show the products from the individual categories.
View Replies
View Related
I'm trying to create a site map that will display links to all pages including links to bring the visitor to different categories. See below:
Home:
About us:
Products:
-Category 1:
-Category 2:
-Category 3:
-Category 4:
Contact us:
When the visitor clicks on 'Category 3' they should be sent to a page that displays all the products in Category 3. Code:
View Replies
View Related
im looking for an asp (not .net) script based on a user forum
where as the admin i can set up different users to only see related
forum topics (i want to use it for project management) uploading files
to the forum would also be a massive advantage!!!
View Replies
View Related
The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:
View Replies
View Related
Here's what my code looks like...
View Replies
View Related
I have 3 drop down boxes on an asp page Dynamically populated fron the db, I need the drop bown boxes to be refreshed when you have picked the first eg I select "Midlands" from the Region drop down and only the "Locations" that are in the Midlands are entered into the Locations drop down.....
View Replies
View Related
On one of my client's sites, we set up a subdirectory off the
app's root directory that doesn't allow the Anonymous IUSR_
account in. When we (the system admins) follow a link to
that directory, it presents the standard NT Challenge login
screen. We need to know proper Windows credentials to get
in -- and once we do, we have access to higher-order functions
(to change the read/write bit on files, to delete files,
etc. through the web interface). All that works fine.
View Replies
View Related
I'm want to have a drop down box, for which each item in it have its own URL. I want it to be forwarded to the URL only when the button "go!" is pressed.
Here is my code, not working
<form name="addNewItem" method="" action="">
<td>Add new
<select name="url" onsubmit="">
<option value="publication.asp">Publication</option>
<option value="newsRoom.asp">News Room</option>
<option value="general.asp">General</option>
</select>
item</td>
<td>
<input type="submit" value="Go!">
</td>
</form>
View Replies
View Related
I created a drop down box, I want to do like when a user select one of the options, it automatically run a query and displays the result.
I hope there is a way to do this
View Replies
View Related
In one of my ASP pages, I have a Combo box that gets the information from a sql database,
the number of records that is shown in the combo box is too much (around 6000 records),
the user has to select from these records (let say the user is looking for "George", by clicking
"G" the list goes directly to the first records starting with "G", so far everything is ok, now he/she
enters "e" (the second letter of "George"),this time the list goes to the first record starting with
"e", which is not the way that I want the user to find his/hers record.
I hope that I have explained it correctly, what I need is, after entering the second letter of
"George", the list moves to the records starts with "Ge", and by entering the third letter, list
moves to those records starting with "Geo" and so on.
View Replies
View Related
1 I want if seleted list of drop down in asp is changed then its related record in table should be displayed simultaniously in a single page.
2How can access the selected value of drop down in another page.
3I want to make a search command in a Sngle page in asp.
View Replies
View Related
ive written a piece of code that selects everything from the "Departments" table in a DB and it works well. It lists everything in a drop down box. i'm not writing a page where users can edit their details.
i can make the text in the DB appear at the top, but it's listed again further down. is there any way to get rid of it? Code:
View Replies
View Related
I have made a page in which i have 2 drop down boxes
in first i have got a choice from which i can select subject area eg ( microsoft, cicso , oracle) and after selecting the particular subject area the page reloads and retrive all the courses related to the particular subject area into the other drop down box, and after that when i select the course in the 2nd drop down box and click go then i got the whole information about that course.
Now what i want is that when i select the subject area in the first drop down box, all the courses should come as they are comming now + the 2nd drop down also have the option of "ALL COURSES " and after i select the "All Courses" option and click GO then i get all the courses and details os that subject area. Code:
View Replies
View Related
I have my code like this the user enters the country in Upper case like this for example SPAIN
getcountry=Trim(Request.form("txtcountry"))
Response.write getcountry
now when i do a response.write it types the country name SPAIN
then i have a drop down which is been filled from the table and the values in it are lower case so i have to select spain which appears lower case in drop down Code:
View Replies
View Related
On my page I have 3 drop downs that are populated with static data. When my user makes a selection in either drop down I want to show my HTML table associated with that drop down selection, also the data in my tables are all static.
For example.
if the user selects CAR - New in dropdown 1 I want to show a list of my new cars
if the user selects TRUCK in dropdown 2, I want to hide my CARS and show my TRUCK list
if the user selects BOATS - Fiberglass in dropdown 3, I want to hide (if shown) CARS, and TRUCKS and show my boat list.
For now all of the data is static (don't ask) so I need to do all of this on the client. Is there a way to do this either using JavaScript, Div tags, CSS, etc.
View Replies
View Related
I have a drop down box which selects an item. I want to execute an SQL query and display the results depending on which item is selected. I need this to happen as soon as the item is selected, ie without clicking any buttons. How do I go about this?
View Replies
View Related
I have a sql query that I wish to use in a drop down box. For instance a user would pull down a drop down box and select their name from the list... that would set the name equal to a variable. I know how to do an input box. and I know how to do the sql query ... but how do I put the query in the dropdown box?
The query is roughly this, assume that I have the syntax corrrect for the query (the exact syntax is at work atm and it is working without the box) . I have done my connect statements and such also.
"Select name From Worker"
View Replies
View Related
I want to select a value (that comes from a query) in a drop down list. I have the drop down list working - but when I click the submit button it goes back to the first value instead of keeping the value that was selected in the field. I want to use this value later to select from another query.
View Replies
View Related
I have a combo box that has all the models. I would like to select more than 1 model. Can it be done? Or can i use list box instead of drop down box to do it?
View Replies
View Related
I have a database with fields like; age, hair colour, height, eye colour and more. I wanted to allow a user (on a webpage) to choose from a selection of these catagories, for example age drop down box displays; under 16, 16-21 etc.
The user then selects the one appropriate and when presses a submit button, this is then stored in the database. I want it to be accessible, so the user can edit it if necessary. I realise im going to have to use values in the drop boxes, but am not sure how to approach it.
View Replies
View Related
Can I open and populate a listing.asp page based on a selection in a drop down box? The value in the dropdown box (ie. Wednesday) needs to locate 'Wednesday' in a database field and list all items that contain 'Wednesday' Anybody know of an article or reference where I can learn about this?
View Replies
View Related
I have 2 drop down boxes on my page but I want the option in dropdown box 2 to appear automatically once dropdown box1 has been selected.
With the code I have I can get the single answer in drop down box 2 but it has a blank / select line above it. I only want the one answer and no other option or blank/select line to be available. Code:
View Replies
View Related
I have a dropdown box populated with a list of parents names on a page, and when you select a name, it uses the onChange method to change the names of students in a second dropdown box on the same page (this is done through stored procedures and it does not submit to a new page. this is all done on one page).
My problem is I do not want the student drop down box to appear until after the parents name is selected.
View Replies
View Related
when we select a value from a drop-down box, we no need to press a button to retrieve the value that match with the value selected for another drop-down box.
example:
when we select Fish name, then no need to press a button we can retrieve the fish type that belongs to that particular fish name.
As i know, we need to press a button to pass the value to retrieve the new value from database. when there are few drop-down box that using same method, this will waste a lot of time to retrieve the data. cant it be shown automatically?
View Replies
View Related
