Datebase Driven Dropdown
I am looking for info and maybe an example on a database driven dual drop down. I need the second drop down populated by the selection of the first drop down.
View Replies
ADVERTISEMENT
Datebase Query
i got a database with fields
name id and under
one id joines under naother id
so there are many ids and many ids joined under those many ids
dtat base table has fields
id
name
underid
pls give me a query so that
wen i click one id
the members under them displays
and
wen i click on under ids again members under them display
this should go on untill final member
Making Dropdown Menu Dependent On Another Dropdown
I have a category that I will call "company". in my access DB, there are about 6 or so companies. On another table, I have a list of locations that are related to these companies.
What I want to do, is have a drop down menu that lists all the companies. When you select the company, the second drop down menu will automatically populate with the locations of the company you selected in the first dropdown.
Anyone know any links to some examples of this? My google searches have been pretty fruitless since Im having a bit of a problem trying to explain it concisely (as you probably noticed).
Database-driven URL
I am trying to create a URL from a list of names from a database...it showing up blank. Trying to pass ID and Name as parameters too. the code I tried is below, thanks in advance.
NAMES.Open()
Names.MoveFirst
Response.Write "<TABLE Border='1'>"
Do While NOT NameS.EOF
%>
<a href="access.asp?intID=<%Response.Write(Names("ID")) %>&strName=<%Response.Write Server.URLEncode(Names("Name"))%>"> </a>
<%
Names.MoveNext
Loop
Response.Write "</TABLE>"
Template Driven Web
My client has 35 domains (web addresses) that they want to host on a Windows 2K box with IIS 5. They want one application built using ASP and SQL server, hosted somehow on the IIS so that it appears as the same application for each domain. The end user of each domain will actually be using the same application.The head of each of the 35 domain, or the jr. web master of each domain should be able to cutomize the look of the each of their domain. This customization feature would be built into the ASP application. Things that can be changed would be some text, color of text, size and color of input boxes.
This application will be similar to some of the eCommerce sites that have a web interface for their merchants to be able to modify their individual sites. Sort of selecting and modifying templates. They want 1 application so any changes and update of the application will reflect on all domains.My question is how do I start designing this?
Where can I get info on this project, any opensource stuff I can look at?
Do I incorporate XML anywhere?The domains will be accessing the same DB, how do I minimize DB trips?
DB Driven Pop Out Menus
Does anyone know where I can find any resources for dynamically creating pop out menus using a database backend for the links?
View Replies View RelatedDatabase Driven XML
I have found some code on the net and been given permission to use it. However I wish to connect this code to a SQL Server database, so what would I use? I am mainly an ASP/HTML/JS user but it will not let me use the standard VB script on a .xml page. How do I connect my XML to the database?
View Replies View RelatedASP Driven CMS For An On-line Magazine
I just got in charge of a weekly online magazine. I was wondering if there are any webmasters out there who might recommend a good ASP driven CMS for this task, better if free.
View Replies View RelatedDb Driven Site Architecture
when doing a dynamic site such as this, how does one handle the articles? is the whole article dropped into the db? or does it sit somewhere else and the db just references it?
i'm going to convert a large static site over to asp this summer and am starting to plan the architecture and i haven't really been able to find the answer.
Databased Driven Counter
I have 3 websites and make use of free counters provided by other web hosting companies to count the no of hits. Now I want to install a multiple-user databased driven asp counter (with initial value setting) in one of my sites to provide the statistics. I try to use the google search to look for a free script but to no avail. Anyone know of a free asp script that I could use for this purpose?
View Replies View RelatedDatabase Driven Search Engine
Does anyone know where I can find a free simple script to create a search engine using Access Database backend and will allow the user to type in a word (not a using drop down list) and it will search the table.
View Replies View RelatedDatabase Driven Image Gallery
what i want to do is create an image gallery, that when u click on a picture it opens in a pop up with the images caption and name there also. I've stored the captions and image names in a database - images.mdb table - Images
I just need a page now that sorts it all out to display the correct image, caption and title in the pop up. The images are stored in folder images and the database in the website root directory.
i've read a couple of articles on various websites, and played with the image gallery wizard on Frontpage but the websites dont explain my problem, and i cant adapt the gallery on frontpage. I'm a bit of a novice in ASP so I would really appreciate it if you could some how make the bits of the script I need to change standout.
Date Driven Data Display
My client has an annual calendar of events consisting of a record for each event, key field is the event date saved as a date type field. They would like the display to start with the current month, list to the end of the year then start the beginning of the year and list up to the current month.How does one retrieve data based on date? I guess I'd like something like :
SELECT * FROM EVENTS WHERE [month is greater than or equal to the current
month] ORDER BY Date
Then :
SELECT * FROM EVENTS WHERE [month is less than the current month] ORDER BY
Date
What is the syntax for the month bits between the []?
Database Driven Programming Model
I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web software's responds are based on data request from the user? Just like in Windows, we call it "event-driven programming" model because the windows program's responds based on user's responses? That's why we call "data driven programming" ?
View Replies View RelatedDevelop Database Driven ASP Site
I want to develop a site with the following features:
1. A movie library (DVD's, VCD's etc)
2. A database
3. search by category, title, actor, etc
4. membership signup
5. tracking system for lent out titles
Now am new to ASP just dived in am using Visual web developer express edition. Please point me in the right direction on the best way to do this. Am self taught kind a person and will not take me a long time to get the hang of it once in the right direction. Am not conversant with Visual basic or C#.
Securing A Database Driven Site
Firstly, apologies if this is the wrong section!
Ive created a site using ASP and an Access database. At the moment the database is unprotected, and I haven't used any usernames or passwords to access the database.
Now that development of the core site is almost complete, i want to secure the database.
ASP Plugin/Template Driven Portal Project
I'm currently in the middle of the most advanced ASP project I have ever worked on, and was wondering if I can get any feedback on what anyone thinks about it so far (or suggestions for improvement later, etc.)
Basically, it will be a single core set of ASP files, that will allow anyone to set up a webpage in minutes by simply selecting a pre-developed site template, and pre-developed site plugins (a plug-in being anything from a menu, to a CC processing tool, etc.), so that user's can simply "manage" their site look/use rather than program everything over and over again. In the end there will even be an import to instantly convert any existing site.
Developers can build templates and plug-ins at will, and will be interchangeable on the site with the click of a link or button.
This project is planned to be open source but is still months away from completion, but to check out a sample of how it basically will work, we are currently testing it at URL.
Creating A Database Driven Breadcrumb Trail
I want to create a breadcrumb trail on a site, but instead of being
generated by cookies or a directory structure, it needs to be database
driven. My website details hundreds of products, each belonging to a
category. Each category can belong to a parent category, and so on.
My site will feature master/detail pages, and both need to feature a
trail, e.g.
Books > Hobbies > Sport > Football
The master page will list all items within the current category, and the
trail will allow the user to click to any parent category for a wider
listing.
The detail page will show the item detail, along with a full trail to
the category/parent categories it belongs to.
The category structure will grow over time, and different branches will
have different number of levels so it needs to be maintainable.
Current-Date-Driven Range Of Events
I entered a whole year's worth of events. I want to display a range of events which change according to the date, so only 2 weeks later and one week earlier are displayed on the main page.
How did other people deal with similar issues? I know I can set a range mathematically speaking (date + 14 AND date -7). But did other people encounter other issues? How did you solve them?
Mssql Database Driven Spry Type Horizontal Menu
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replies View Related"image" Of A Db Driven Page
Is there a way to have an asp page displayed with all the data from a db but not truly getting the data from the data base.
I want to perform updates to the data base and not have them "publish" untill I say go. I figured one way to do this is to have two tables (one live and the other pre-production) of the page and just copy the preproduction table the live table when ready. But, I read in some search engine optimization artcle that there is a way to basically have a pure html version of an asp db driven page so the search bots do not ignore it. Does anyone know of something like this?
CSS Dropdown
Does anyone have any code to display a dynamic dropdown menu (similar to Windows Start menu)? There seems to be a browser compatability problem with most that I've seen.
View Replies View RelatedGet Value From Dropdown
I am trying to get the value of a dropdown box which is populated from a access database.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("mydb.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT DISTINCT Company FROM Customers ORDER BY Company"
rs.Open sql,conn
company=request.form("company")
%>
I need to send dthe value of this dropdown to the next page which will response.write the company name. Any ideas on how to do this?
3rd Dropdown
i had done coding for two dependent dynamic drop down boxes.taking code from http://forums.aspfree.com/t53159/s.html......it is working nice
but now select 2nd box and populate 3rd one.i m very confused how make a changes in code for 3rd one.if any of u
have time i can send my code for urs technicalful advise
Dropdown Box
I have code to present on this forum, but not with me at the moment. This is what is happening now. On my page there is a drop down box that calls on an onChange javascript function. The drop down box dynamically displays locations depending on the location of the cars.
Therefore...if Toyota Camrys are in Philadelphia and New York, the drop-down box will display: ALL, Philadelphia, and New York. Selecting one will filter out only those in that location.
What i want to do is...change it so...it displays dynamically the locations horizontally...here is an example: PREFERED LOCATION? ALL PHILADELPHIA NEW YORK (all are links to filter out those that do not match the location).
i need to do it to save space and make it more user-friendly.
Getting Dropdown Value
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page. Code:
ASP Dropdown & XML
I've got an XML file that I use to populate a treeview control and a dropdown box. That works fine, although I now want to be able to sort the list of people in the dropdown list. Someone suggested using an XML template, but I'm a bit of an XML newbie and not sure how to do this. Code:
View Replies View RelatedDropdown Box
Lets say you have a dropdown box with few options in it. Several products have such a dropdown box. is there a way to do this following stuff.
I want one of that options in the dropdown box to be 'unique'. When selected, it would dissapear, or it can't be clicked on, on another product's dropdown. 'yes or no' answer would do just fine for now.
Dropdown
Now that I can store variables from a form listbox into a session variable... say there are 4 options from the dropdown like
model
type
area
performance
and the user selects performance.. I store the string "performance". now how do I place it back into the listbox after the user hits 'submit'? that way the selected values are shown.
Dropdown Box Value
i have a web page which allows user to update Subject information. There may be several subjects in the dropdown box. However, each person will have a subject allocated to him when he is inserted into the database.
As such, now when i want to update his particulars, in the Subject dropdown box, i would like to set his Subject to the one in the database followed by the rest which he can choose.
Eg.
Originally, Subject = Literature
Update:
in Subject dropdown box, i will see Literature at default but when i click the dropdown box, i will see the other options such as History, Gepgraphy etc. How should i go about doing this?
Dropdown On Textbox Using ASP
I have seen some techniques like this on the web. Currently, I'm using Combo
box which values came from database table. One disadvantage is when the
combo box have lots of values, users are complaining since you cannot use
keyboard to search the value that is needed.
Autocomplete In Dropdown
I'm trying to put a drop-down box on an asp, which will containing a list of
names.When a user starts typing a name that is in the list I want the text to
autocomplete
e.g. when the user types 'st' I'd like the text to autocomplete to steve or
stephen, depending on which is first in the list.
Dropdown List
How to display sql database data to dropdown list in asp?
View Replies View Related