I have a page pulling some data from an MS Access DB, one of my columns is a "Application" column.
I have a dynamic dropdown pulling various Application names from a separate "Application" table in my DB. What I'd like to do now is to be able to select one specific Application from that dropdown and click the GO button to have it only show records with that Application name in them. Code:
I've been farting around with trying to make some dropdown boxes populate based on the value selected from the first drop down box..
I have 3 DropDowns..
1)PumpType
2)PumpMfg
3)PumpModel
the first one takes all the pump types from a database table called pumptypes and populates it
the second dropdown gets its values from an sql query to a second database table called pumpdata that puts all the manufacturers that have that have a pump that matches the type selected in the first dropdown.
the third box does essentially the same thing but looks for all the models based on the values of the first 2 dropdowns..
whats happening is when I select the pump type it goes to the next page without allowing me to select the other 2 boxes.
heres the code I have .....
I'm dividing two variables and on some instances the results going to be a long decimal. I want the decimal to round up to only one pace tho. How could I do something like that? My coding looks like this.. Code:
readscore=rsgameinfo("readerscore")/rsgameinfo("readervotes")
how do i create a array rs, not sure if the terminology is correct. but i don't want a obj rs i want a array.
View Replies View RelatedI have a random script I got online, and now I am trying to integrate it with a database, except I can only allow certain records to be random. Here is what i have so far, but I don't think it likes the RecordCount ...
<%
dim limit, random, rs
Call ReturnRecordset(killChars("SELECT * from quote where quotetype = Finance"), rs)
' Sets the upper limit for the random number
limit = rs.RecordCount
' Redim allows for arrays to be setup by passing a numeric value
' rather than hardcoding the numeric value for the limit multiple times
redim image (limit)
redim text (limit)
' List of images and links
Dim i
i = i + 1
While Not rs.EOF
image(i)="images/randomimage/testimonial-3.jpg"
text(i)= rs("quote") & " - " & rs("company")
rs.Movenext
Wend
' produces the randome number from 1 to the value of limit
randomize
random=int(rnd*limit)+1
'Writes the randomly selected hyperlink and image to the browser
%>
<p class="testimonial"><img src="<%= image(random) %>" border="0"></a><br />
<b style="font-size: 14px">What our Clients Say:</b><br /><br />
<%= text(random)%><br /><br />
<a href="finance-testimonials.asp?quoteID=<%=rsquote("quoteID")%>">Read Full Testimonial</a></p>
<%
rs.Close
set rs = Nothing
%>
What do you think?
I am getting this error message
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
How do you guys make listings such as product listings and their detail pages more crawler friendly, if they are genrated using dynamic asp pages.
If your ASP uses a format like this: www.mysite.com/products.asp?idnum=3444 to display detail pages, how can I apply SEO to this format??
I know unix hosts use the mod rewrite, but I do not have access to the server settings etc. BUt I can access a database etc.
I have a table called tblParts. The are 3 fields: PartID, PartNumber and Price. I have a dropdown box on my ASP page that is dynamically populated with PartNumbers from the database.
I have a text field for the price. I want it when the user selects a part number from the dropdown to display the correct price in the textbox for that part. I "DO NOT" want the page to reload.
I want to create a system of dynamic dropdowns for a site I'm working on.To add an entry a user first has to select a Category which then populates the Subcategory dropdown which inturn populates the Subsubcategory dropdown.
An example can be viewed on the Nvidia and ATI sites when you download drivers.
is hard or easy to create a dynamic dropdown?I have sorted my previous query with the array and now i want to perform a dynamic dropdown from one of the options given in the first?
View Replies View Relatedi want to make two dynamic dropdown lists that get data from sql server database using classic asp.when user select a value from dropdown list1 (country) the values in dropdown list2 (city) should automatically be changed.in the database the relation is one to many (country table with city table).
View Replies View Relatedi have form on asp page that recalls data from the recordset and populates all fields except the dynamic dropdown box that doesn't, just shows default value. How do I make it populate based on the entry in the db?
I'm trying to build a asp dynamic list were you can select a option in the first list and depeding on that value the second list will change to match. For instance I choose a customer in the first list, the second list then has to give all the codes from that customer. The list is variabel, as the value;s are from a database.
If tried some stuff with ASP and Javascript, but the page reloads after selecting one option, but because it reloads, it delete's the text that is written in the rest of the form.
Does anyone have a snippet to hand where i can create a dynamic dropdown for a credit card page, basically i need to dynamically create a drop-down populated with this year as 2006 and go back 4 years?
View Replies View Relatedjust a quick question that I need to now the answer to before I try is it possible to create a dynamic dropdown menu containing values that are not stored in your database.
Ok so I'm working on a schedualer that searches for time slots that are not free and displays these vaues if they are not contained in the database Quick example:
1st sept 10:00 taken
1st sept 11:00 free
but 1st sept 11:00 free will not be stored in the database therefore the dynamic dropdown will not be populated from a recordset.
I have found in the forum examples or 2 dropdown lists and 3 dropdown list. Does anyone have any idea how to do 4 or more dropdown list? I tried to modify it from an example script found here but failed. Code:
View Replies View RelatedI have a dropdown that is dynamically populated. The value = a numeric code which I save in the DB. The text = the description. I know how to get the value of the selected item but I need the text of the selected item. I know how to do this in javascript but where I need to gather the text is during an ASP routine.
How do you get the text portion of a dropdown? I saw one post where you can add the numeric code and description together and then use split() to seperate them. I'd rather not do it this way. Is there another way?
I want to have dependent dynamic dropdown lists where the person can select the state, then county, then zip code, and all 3 of these menus will be populated by a database. I have a page that Ive been working on but I just cant get it. The page I am working on also refreshes when you select the state, then when you select the county it refreshes again but instead of populating the zipcode list it just takes the state name and inserts it into the city menu. Code:
View Replies View RelatedI have a dynamic drop down menu created from an Access 97 database. The munu contains numbered indexes. Is there a way to have Index 10 displayed after Index 9 instead of after Index 1.
View Replies View RelatedI have a dynamic dropdown list that has info brought in from my SQL database. Based on the user's selection, I want to create a message box that informs a user that an additional step must be taken first before the form can be submitted. For instance:
Drop down list contents -
Estimate
Repair
Maintenance
Renovation
New Build
If a user selects "New Build" from the dynamic drop down, a messgae box would appear to let the user know that they need to have a permission form filled out before they can submit the work order. Something to that affect. Can this be done based on a selection in the list or do I need to use check boxes instead.
i have three dependent dropdown list.when select city in first box then 2nd list will show all company for selected city. 3rd will show all jobs of co. any suggestion?
View Replies View RelatedI've been pulling my hair out over this. I've been looking at it so long I'm probably just not seeing it. I'm trying to populate a dropdown list based on a user's leagueID contained in a Access database. Here's my code:
View Replies View RelatedI 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).
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:
View Replies View RelatedHow can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?
View Replies View RelatedHi does anybody know if you can make a form
have two actions and how?
how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.
View Replies View Relatedwhen you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?
'script block
<%
dim myObject
set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)
%>
'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies View RelatedWhen you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
how to make the session timeout. and where should i put the session timeout.
View Replies View RelatedI have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP.
In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?