ASP :: Dynamic Triple Linked Dropdowns

Dynamic Dropdowns Problem
I'm creating a form to update a series of records. For four of the fields, I want the options available to the user to be limited by dropdowns. One dropdown is generated from a table in the database, the other two are generated by arrays I've written.

The problem is the dropdowns aren't picking up the value stored in the database for each record. The text fields are picking up the correct values, but not the dropdowns. For one set of records the dropdowns are only picking up the first (default) option; with another set of records, the first record's dropdowns are correct, but then the subsequent records' dropdowns repeat the values of the first one. Code:

Dynamic Populated Dropdowns
I don't want to try and reinvent the wheel so I'm looking for an ASP 3 script that will dynamicaly populate a nubmer or dropdown boxes from an access database, read a price from the the database and write both the selection and the price to a form and total all the prices too.

Two Linked Dynamic Drop Downs
I want to make a form where m using two drop down menus.

Where in based on selection in first drop down the second drop down should populate itself with relevant data based on first drop down. Like first can be COUNTRY name and second can be STATE name where based oon country selected the STATES are displayed in second drop down for selection.

Triple Insert Problem
I've got an issue when using an INSERT into MS SQL 2000. The problem is that when I do any insert using the code below, the insert happens 3 times. The query reads something like this...

SET NOCOUNT ON; INSERT INTO xx (xx, xx) VALUES ('xx', 'xx'); SELECT @@IDENTITY AS newID;

I then use the following code to run it and do an update to the new record. One thing to note is that the update is only completed on the last insert that is done, so this doesn't seem to be a problem of the function running multiple times. Code:

Triple Nested Quotes
Can someone tell me how to write this line so I don't get an error - I've tried various ways to nest the quotes,but I still get an error saying that an ")" is expected.

Code:

response.write("document.write('<form method="post" action="message_send.asp?subject=" & _
Request.QueryString("subject") & "" onsubmit="return preValidate(this);">);")

Is there any other way to feed the result of an ASP function into Javascript other than by getting ASP to write out the JS as above?

Problem With My Dropdowns!
I have an ASP page. On that ASP page I have three columns. Each column contains one dropdown box. I wanted to make them dependant of each other and I think I did it.

When the user clicks on the submit button after making his selection in the first dropdown, I have an sql for the second dropdown which will automaticly not show the first selection as a option in the second dropdown. So far, it's allright.

When the user makes his second selection and hits the second submit button below the second dropdown, same thing should happen with the third dropdown box and its SQL query. I use SQL to extract records from an MS Access database.

However, in the third dropdown I don't get the value selected already in the second dropdown, but the value already selected in the first dropdown now shows up????

Too Many Dropdowns On An ASP Page
My ASP page contains around 35 dropdown controls. If I try to open this page
from a Win98 OS , the dropdowns appear jumbled up. They overlap on each
other. However, this problem is not reported on any other Windows OS.

Dependent Dropdowns
i have a form and i need the selection from the first dropdown to influence the results on the second dropdown.The first dropdown will have a list of guesthouses and based on the guesthouse chosen, the second dropdown will give the rooms available in that chosen guesthouse.

Javascript Date Dropdowns
I'm using a piece of javascript in my asp page that splits the date into 3 dropdown boxes, one for day, month and year.

This works fine. The problem I'm having is that when a user first enters the system there is no date selected, therefore I want the current date to be selected in these dropdowns based on the system dates Day(Now), Month(Now), Year(Now).

I can't seem to get the correct month selected, I can only get it to write the current month at the end of the dropdown which is no good cos then it's in there twice. Code:

MULTIPLE DROPDOWNS, ASP, VBSCRIPT
I''ve 3 to 4 or more combo boxes. On the change event of the combo boxes I want to fill the values.

Suppose I change the value in combobox1 the second combo box should get filled basing on the first combo box, in the same way the third combo should get filled basing on the second combo criteria and the fourth combo should get the values basing the selection made in the 3rd combo.

All the combo boxes are fired in the change event of the combo box. And please no Javascript only VBSCRIPT.

Linked Tables
I have a database that has 2 tables linked into it from another database. I am having problems trying to pull in values from those 2 linked databases. One of the tables is tblClient. Code:

Linked Tables
Ithe goalposts have been moved (yet again!) and the database that was one, may have to become many, being used on subdomains of the same server sharing some information but not all from a 'global' database.The solution I initially found was to used linked tables and developing it on pws - this was perfect. I linked local databases to the external table data in the 'global' database hey presto the application ran smoothly. There was only 1 connection to each local database and I could retrieve all the information I needed from the global one. However on uploading I have no idea how to set this via asp or sql as online the path of the linked tables is what was on my local machine and I have found no way of being able to edit this or indeed know if this is possible.

Linked Combobox
I am using one combo box and populating it with the values . i have another combo box on the page. I want to display the related values in this second combo box based on the selection in the first combo box.

I am trying to reload this page on the change event of the combo box but the values are not coming in the 2nd combo box . Please send me a solution to this or if possible a sample code for the same.

Show If Linked With Sessions In ASP
I have a "booking" section on my intranet.

2 questions.

1. Can I, say by session, determine if a user logged in can amend/delete data they have entered? But no one else.
Say they book a conference room, but only they can delete it

2. I want to prevent cross bookings (in terms) of time.

Opening Linked Tables
I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however,

I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB.

The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.

Resizing Linked Images
I've been tasked with the challenge of re-sizing images linked via BBcode on the fly. I have compiled a list of functions that do individual components of this task, but stringing them together has proved, well, a challenge.

I discovered this code that will re-size the images, however this will need to be added on an ad-hoc basis, and the fact that the image name appears twice complicates the usual system I used to add the code.

Usual way of replacing the code (inside a function):

Code:

vText = Replace(vText,"[ img ]","<div align='center'><img align='middle' src='")
vText = Replace(vText,"[/ img ]","'></div>")

Image resize code:

Three Linked List Boxs
if you have seen an example floating around on the internet of three linked list boxs using asp code and a database connection. I have managed to get it to work for the first 2 list boxs, but I am unable to get it to populate the third list box, this is how it is:-

Tables:-
Main_cat
Sub_cat
Subsub_cat.

Not all Sub_cats will have subsub_cats, hope this makes sense. I have attached the code.

Linked Drop Downs
how can i change the options of a combo box when selecting an option of another combo box?

Linked Form Menus
I currently have a page with car manufacturers in a dynamic form menu. Users can select one and click submit to find available cars by that manufacturer. What i now need is a second menu on the page where when a manufacturer is selected, the models associated with that manufacturer display for a user to choose. For example if Ford is selected:

Menu One Menu Two
------------------ -----------------
Ford Focus
Fiesta
Ka....

Can i do this with ASP to say "if menu one is ford, menu two contains...."? Or is there a much easier way which i am somehow missing?

Dynamically Linked List Boxes
I want to link 2 list boxes on the same page without reloading it. The list boxes are dynamic and when one selects an item in the first one, the second one get's populated accordingly. So far I've been stuck with Javascript Object Expected Error and I cant find a way to make it work. Code:

Images Won't Show Linked From Access DB
I am unable to show and image or flash i have in an access database that is linked to an images subfolder, below is what i am using to show text on my ASP page but i want to ad a couple of images to the database to show in different locations on the page or pages, so i guess i needed a call function but ive used the one i have on my database image rotator scipt and a few others i have dowloaded and still the call scripts wont work, i'm sure im doing alot wrong can someone please edit this code and show me what to do... if its no bother

This works fine for showing the text on a page:

<%
Dim rs
Set rs = Server.CreateObject ("ADODB.Recordset")

rs.Open "introtext", "DSN=introTXT.mdb"

While Not rs.EOF
Response.Write "<br>" & rs("Content") & "<br>"
Response.Write "" & rs("URL") & ""
rs.MoveNext
Wend

rs.Close
Set rs = Nothing
%>

Drop Down List With Linked Fields
I want to create an asp page from these forms in my database:

Database:
Table 1 =>
1.1) ID:
1.2) Product Name
1.3) Description

Table 2 => For the ASP Form
2.1) ID:
2.2) Text field 1 (Normal input field)
2.3) Product (Dropdown Menu, Data Source Table 1, Field 1.2)
2.4) Description (Text Field, Data Source Table 1, Field 1.3)

The Description value should be in correlation with the Dropdown Menu value in Table 1

Form With Linked Drop-down Lists
I have an ASP-page where I want to be able to select a fabric and color of that fabric. Since different fabrics comes with different colors I want to have a form with two drop-down lists where selection of fabric in the first list populates the second list with the right set of colors. I need to have the lists in the same form so it only require one submit.

Exporting To Word Using ASP - Need Linked Images To Be Embedded
I have an application in ASP that exports to Word using the Response.ContentType method.

The application references another ASP page through the img tag that uses a Response.BinaryWrite (of an img content type) for its output.

In other words:

App A.ASP contains the code: [...] <%Response.ContentType =
"application/vnd-msword"%> [...] <img src="B.ASP">

Then B.ASP contains the code: [...] <%Response.ContentType = "image/png"%>
[...] <%Response.BinaryWrite BinaryObject%> [...]

When Word opens and the document is saved, it references the images as links. I need to have these images be embedded as the file will need to be emailed outside of the network.

I can go in and manually break the links and save them as embedded files, but this process needs to be automated as users will not know how to do this.

Is there a way to force these images to be embedded instead of referenced as links when the Word doc is intially created?

Reading Linked Server Stored Procedure
I've got a stored procedure which returns a select query on a linked server. This works fine if i call within SQL and Query Analyser but if i try and execue to return data to a ASP recordset i get the ridiculous

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

Am i missing something really basic like a simple setting or is it just not possible.

Heres my ASP code: ...

Creating Linked Pull Down Lists With VBscript
Trying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?

How Can I SELECT By Two Fields In A Linked Table (2 Degrees Away)?
How can I do this in a single query (or query-subquery)?

Return the Rows of all books in the CATALOG that...

- are tagged with one category

- are also tagged with a second category

CONTEXT:
This is a 3-table db
Many-to-many (each book may have many categories & v.v.)

- bookCatalog is the main table (with fields for each book's unique data, primary key is Ref_no)

- bookCategoriesLinkTbl is the linking table (it has two fields: category_ID and Ref_no)

- categoriesTbl has only 2 fields: category_ID and categoryName
It's an Access 97 db Code:

Linked 'tables' (access) Local - To -remote
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables. I just wanted to know how feasible a LINKED TABLE scenario would be.

If this was possible it would solve so many administration problems and save development time when it comes to building asp-admin pages to manage the backend.

Dynamic Calendar, Need To Create Dynamic Array....
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:

Dynamic Dynamic Text
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.

Dim A Dynamic Name
I want to create textboxes dynamically but with dynamic names also.

i am retrieveing a load of values from a table in SQL into a DataReader.
Then i want to create textboxes from those variables. I want to dim various
textboxes with different names depending on what I retrieve from SQL. I
tried the following:

dim dtrcondet.item("contact_detail_description") as new textbox()

but this does not work

Dynamic SSI
I am trying to create a site that has dynamic page generated based on if a value is present.

PROBLEM
I want to be able to show a certain dynamic page if a certain value equals to true. The page should be able to generate values from a db
e.g. <%=aspscript%>

And if the value equals to false, then the page should not appear at all.
I tried using SSI (Server side inlcudes) but cant append variable names to it or use them with if then statements

Dynamic IF THEN
I would like to have some text appear in a different color if it matches a result in a database. I am not sure how the syntax would work, this is what I have come up with so far. Not sure how to insert it.

If <%=(Picks.Fields.Item("Pick1").Value)%> = <%=(Results.Fields.Item("Pick1").Value)%> then class="style1"

Is this possible? and if it is does it have to be entered for each occurance of the dynamic text or can it be added to css?

Dynamic Css
i want o make the images on my website depending on who is logged in. I have all of the Images names stored into my database, which i have uploaded there using the Pure ASP upload 2.09 add on for dreamweaver, and that all works fine and my image is stored in the correct folder and the name of that image is stored into the database as imagename.gif which is exactly what i want, but i dont know how i need to declare that value from the database into my style sheet. Code:

Dynamic CSS
I need to create a bunch of sites with slightly dynamic CSS. Basically,
all the image paths in the CSS need to be dynamic, depending on the
values of certain ASP variables.
I can think of 3 ways to do this:
1. Write a script to create a semi-dynamic CSS file, which will be run
whenever we need to make changes to the ASP variables controlling the
image paths.
2. Have an ASP script generate the CSS on the fly:

<link href="dynamiccss.asp" rel="stylesheet" type="text/css">

3. Put all static CSS in a normal CSS file, and have a special dynamic
style sheet for only those rules that require variability. We could
either use method 2 above to generate a second style sheet, or place
dynamic rules directly in the actual asp pages.

Dynamic QS
I have a form element and the name is dynamic

name="<%=cnum%>"

i now need to do this but it's telling me that it needs an to be a string.

JobsToUpdate = Split(request.QueryString(cnum),",")

and what would be ideal is the value of Jobstoupdate will be
This Cnum ->cnum=Split(request.QueryString("staticcnum"),",")

Hopefully I explained it well enough.

Dynamic Dim
is there a way to make a dynamic dim, or am i looking at this all wrong

<%
Dim A & request.form("") & B

A & request.form("") & B = Request.form("")

%>

Dynamic Navigation
i want to have a dynamic navigation that will look at a database and then fill the navigation side. I want to have a category, then a sub- category also. Can this be done?

Dynamic Link
I would like to build a dynamic link based upon a value returned from a db

There is data in the db because objRS("Description") returns a value.

something like

Code:

if objRS.EOF then
%>
<a href="/somepage.asp?id="<% objRS("Id") %> "><%response.write(objRS("Description"))%></a>
<%
else
end if

I get

http://localhost/somepage.asp?id=

Nothing else at the end.

What am i doing wrong?

Dynamic Form
it's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:

Asp Dynamic Menu
I have been searching for tutorials everywhere on how I could make a menu that is multi levels but that can be updated dynamically through asp...so basically when I add a link in the database it will update the menu...now I know how to pretty much pull links from the database for a basic menu...but lets say there is a link called about us and under about us there is more options to choose from.

How would i code this so the menu would know which ones were parents and which ones where childs? And does anyone know of a good tutorial, or of an example. and basically I want this because I would like to create a content manager...but I don't understand how the menu would work when pulling data from a database.

Dynamic Includes From URL
Is there any way to dynamically generate an include file based on a variable passed to the asp page via a url ?- so for example:

Person x clicks on a url - that ur directs them to template.asp (template.asp has no code in it other than page title etc and  )

Once in template.asp the page loads the include file that is relevant to the companies website that the link was clicked from.

In that include file will be the correct form and stylesheet setting for that company.

What we are trying to do is achieve a global template file which multiple customers can direct peo[ple through and all the data is therefore stored in one central repository.

The file displayed when they reach template.asp will depend on the url they clicked. Basically how can i get the url to pass the variable which the include file will then load??

Dynamic Checkbox
I have a table in ASP page which displays records and it has a checkbox whose name is ChkBox<%= intRecID %>

<%= intRecID %> is the ID of that record. Now how should I chck whether check box is not checked.

Dynamic Content In ASP
I am having to make sites accessible where images are dynamically generated.

'Display the graphical hit count

Response.Write("<img src=""counter_images/")
Response.Write(Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & ".gif""")
Response.Write("alt=""" & Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & """>")
How do I include the width and height attributes in this code?

Dynamic Form
I currently have a form with 5 rows of textboxes (one textbox on each row). I would like when user keyed in something in the last textbox (textbox at 5th row), it will automatically create another row of texbox below it. Can someone please advise me on how I can do that?

SE-friendly Dynamic URL
For some of my pages I currently have part of the URL as being 'ourservices.asp?ID=1' (its got nothing to do with sessions) and I am currently changing part of it so its more SE-friendly - i.e. 'ourservices.asp?services=website-marketing'. However following Googles guidlines regarding dynamic URL's,. it says that some search engines don't crawl pages which have a '?' in them for fear of them being a session URL (which mine isn't).
My question is- is there any alternative that I can use to replace the '?' with another character for my dynamic URL. Or, is this the only way I can have this dynamic URL?

Dynamic Arrays
i want to create a dynamic list or array in asp as we have arraylist in asp.net. what i want is that i want to hold the values selected by the user in a list and in advance i dont know that how much values the user will select. i also tried to use array with redim but that did not work as we can create array with only constant integer parameter.

Dynamic Access
I've been writing a website for dynamic access, meaning any customer can login to their website (I run a website business) and edit pages. However I'm having a delima of how I should write this part, I'm storing everything in a Access database and accessing it using SQL. The user can create a link, and then select the page it links to using a dropdown list to create links on the navigation menu. Now they need to create the page, and I'm wondering how I should store this. Should I store ALL the code (including the ASP?) into a Memo field inside access, or should I create a 'first half' asp page and a 'second half' asp page and then have my system store all the content and stuff into the access field? So basically the page would be assembled somehow:
ASP Part 1 - Starting Code
Content grabbed from Access Field
ASP Part 2 - Closing Code
and then just store the Content inside the field? If so, should I create 2 include files and then tell my system to make a new page, include part1, store the content, then include part2?

Dynamic Triple Linked Dropdowns

Code:' then set up a query' -----------------------------------------------sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql herecould someone give an example so I could follow it?

Code:

' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here

could someone give an example so I could follow it?