ListBox Values From Database
I want to populate a listbox from a database. This listBox will contain the value of the Table PK. Whenever i chose an ID the input fields in the form below will change corresponding to the PK.
View Replies
ADVERTISEMENT
Changing Values In 1 Listbox When Selecting Records In Another Listbox
I was wondering if you could help me with the following problem. I have 2 listboxes in my
webpage, 1 has cities, and the other lists the streets of the city from the first listbox.
When I click on a city, I want the 2nd listbox to populate with all streets in the city. The city and streets are saved in a database, so when the user selects the city, I will run a query on the database and populate the 2nd listbox with all streets.
How can I do this with normal ASP? I know how to do this with ASP.NET, but don't know how to activate this with normal ASP?
Change ListBox Values On Selection
I would like to be able to setup a link on my page that will change in value depending on the index # in the listbox that is selected. Here is the code i have for the link:
<a href="editproduct.asp?Action=Edit&id=<%=Request("id")%>&cat=??????"> List It </a>
I would like it to be - cat=(list index that is selected)
Insert Multiple Selection From Listbox To Database
after a lot of searches to see if i can get such a code on the net, i've finally come to ask my questions here bcoz i can see bits of code here n there on net but not what i really want.
i have a form with a listbox(lstduty) on it. i have been able to populate it with data(dutyName)from table 'duty' from a sql server 2000 database.
now when a user makes multiple selection and click the 'add' button, i want to be able to add it to another table in the database as below: Code:
Writing Values To Database.
I'm a newb - so if this is a stupid question, my apologies.
I have a simple form that users fill out and then that info is written to a database. What I'd like to do is perform a calcution on a number and then write those numbers to other records in the database.
So for instance, if someone enters 12 in one field1, it would multiply that by 3 and that would be saved as field2, then mulitply it by 45 and that would be field3, then add field2 and field3 and save that as field4.
I was thiking of passing the form variables to a second page instead of writing them to the database, then using variables in the second page to perform the calculations and then have the second page write all the info to the database, but I thought there had to be a better solution.
Update Values In Database
We have a fairly large datbase containing thousands of part numbers, product names and pricing. We used to update new pricing changes individually by hand. However, now that our database has grown substantially, I'm wondering what the best method would be to keep the pricing current on our database?
We can obtain new price lists in excel format, however, the part numbers the mfgs use may not necessarily coincide with the part numbers we have. Should I just write some SQL script? Look into using XML? What would be the most efficient way to tackle this problem?
Grabbing Values From Database
I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")
View Replies View RelatedRandom Values From Database
Suppose I have a table named as tblfriends and there are 3 columns with several row. Column names are: name, email, phone
I want to pick 5 names randomly from the table each time my asp page refreshes. How can this be coded in classic asp?
Adding Up Values From A Database
I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.
I am really struggling with this last bit and would be really appreciative if someone has some code examples.
Getting Values From Access Database
This is my error in ASP. In my database i am having one field called title which contains some string including spaces . when i get this value into textbox in my web page
value is displaying but after space is not displaying .
Show All Values From My Database
I have a problem with show all values from my database into my html page! Code:
View Replies View RelatedGet Database Values And Change Them To A Letter
I have a dynamic table asp/vb that is returning records as expected. There are 7 fields that are returning boolean values based on whether there is or is not a meeting on those given days.
My table is returning TRUE and FALSE and all I want to do is create an if or select statement that will detect the values in these fields and change them as follows:
If true, then field = "R" (Wingdings2 R is a checked box)
If false, then field = "T"(Wingdings2 returns a x'd out box)
How To Retreive Nonrepeatable Values From Database
I have a problem with retreiving non repeatable values from database.(this is a shopping cart application)I wrote the query as below,but it didn't work
sql="SET ROWCOUNT 10 select distinct(product_name),pdate from addcart order by pdate desc".
Actually iwant to see recently viewed produts name (max 10)
for this iam retrieving values from addcart table.
By executing above query iam getting 10 products name but they are repeatable.
Retreive Checkboxes Values From Database
I have a form that users use to register with the site. On this form there are checkboxes all with the same name but different values. I am creating another page that will allow users to login and edit their information.
Since all the data from the checkboxes are stored on the database under the same field name and separated by commas; how do I dynamically create a set of the checked checkboxes that the user originally entered along with the other checkboxes the user did not click?
Problems With Inserting Form Values In Database
I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.
I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is
.Fields ("fieldname") = Request.value ("name of text box")
.update
Any suggestions? If someones willing to help me out quick, I will post my code.
Getting The Count From Database Where All Initial Values Are Empty
I have a registration form that I'm making and I need to get the count of available spots for each class session. I can't get the array to return something like "0,0,0,0,0,0". Is there a way to do this? There are 6 total classes and they are named 1, 2, 3, 4, 5, and 6.
When you start out, each count will be 0 (meaning no one signed up yet) which makes the openSpots variable equal to 35 (maximum # allowed). Code:
Is It Possible To Insert All Checkbox Values Into 1 Field In The SQL Database?
Is it possible to insert more than 2 checkbox values into 1 field in the SQL database?
I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.
Building Dynamic Strings From Database Values
We use an ASP application in which we send out emails using cdo for various
events.
At present the email text is hard coded into the code. for example
strMessage = "Dear " & rs("firstname")
strMessage = strMessage & "Your request has been approved with reference id
" & rs("id")
This causes an administration overhead as everytime the text of the message
needs to be changed we need to alter the code to incorporate text or
database values.
What we want is to store the message text into a table so it can be altered
by the application administrators through GUI by adding the text through
freetext entry and field names though a dropdown. Code:
Have To Create Hyperlinks Dynamically Based On The Values From Database.
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies View RelatedMatching Array Index To Values Retrieved From Database
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
ASP _ Listbox
Is it possible to change the selected default option in a listbox on the 2nd page to the option selected in a listbox on the 1st page which ..i.e preventing the selected option from changing to the default option on the 2nd page (both the list boxes have the same value)...i am having a listbox which gets populated from a database using ASP.
View Replies View RelatedListbox With Two Columns?
I want to make a listbox which will show the results of two fields (the ID and the Name) of one table , but the one field (ID) will be the one to pass.
View Replies View RelatedValue From Listbox In Hyperlink
Rather than doing this:
<A HREF="editpatient.asp?ID=1>View</A>
Can i do something like this instead? - and make it work
<A href="EDITPATIENT.asp?ID=" & LISTBOXPATIENT & ">View</A>
where LISTBOXPATIENT refers to a database populated listbox
The idea being that when the user is completing a form they can look up additional data on a patient by clicking the hyperlink next to the listbox.
Listbox Size
I have a drop-down with 40 option values and only one option should be selected of the 40 options. The list size should be 1.
When I click on the list, it drops down 30 options (a very long list) with a scrollbar for the last 10 options.
Is there any way, when I click on the list it drops down only 5 options (as if the list is of size 5) and allow a scrollbar to browse the remaining 35 options.
Code is:
<select name="deplist" id="deplist"
<option value="Commerce">Commerce</option>
<option value="Instru">Instrumentation</option>
... similar such 38 options
</select>
Listbox Width
I have 6 list boxes and it may or may not have data from db to get fill in.
so what happens is whatever has data that comes to the size of the maximum length of the data in that list box and others comes as very small width as there are no data.
but what i want is all list boxes width should be of moderate size.
how can i make those empty list boxes appear as moderate size.
I dont have an option to put an default item in the db to load with that
Listbox Selections
Does anyone know how to make a form take you to different pages depending on what is selected from a list box ? im using asp /sql / and dreamweaver ..
View Replies View RelatedPopulate Listbox
Im new to asp and I'm having trouble with listboxes.
I have two listboxes, the first is populated from a database and I need to fill a second listbox with items from the database that are dependant on what was selected in the first list box.
Figure Out Listbox
I want to select a value from a ListBox, and depending on that value, if it is the right one, it disables a textbox? Can this be done with Javascript?
View Replies View RelatedListBox Problems
the listbox on the left contains the names of employees
the listbox on the right contains the names of employees selected from the listbox on the left (ie by hitting the buttons they move across)
when I submit the form which those two list boxes sit on - I want to access the list on the right
currently on use valus=request.form("RListBox") - then I split the returned value from valus etc - however this ONLY works if I select each item in the listbox (making each entry highlighted)
what I would like to do is itinerate through each item in the listbox and get its (option) value. Code:
ListBox Control
I would like to create a listbox control in asp.net that has the capability of multiple columns like the Windows.Forms.ListBox control.
I have searched high and low and have only found advice such as concatenating the strings into one or using a ListView which do not seem ideal to me.
Would it be possible(and fairly easy) to create a Custom User Control, fill it with multiple listboxes and then programatically change the selected indexes of all of the ListBoxes when the selectedindex of one is changed?Custom Web Controls is another option but its apparently more complex to implement.
Updating A Listbox
I wanna update a listbox via another listbox and sending new values into database.How can i do it in asp vbscipt?
View Replies View RelatedListbox Item
if it is possible to narrow in on an item within a listbox of states. For example, right now if I type "W", I will immediately drop down to those states beggining with "W".
However if I type "WI", I go to the top of the list with those states beginning with "I". I would like to continue to zero in on the state by dropping down to those that begin with "WI". Is this possible and if so, how do I go about doing it?
'Autocompleting' Listbox
I would like to be able to use an autocompleting listbox - that is, one where you can select an item in the list by typing the first few characters; the standard IE listbox only responds to the first character.
I'm happy to pay a few quid for a 3rd-party component/activex control if necessary but I imagine something equally good could be done with client-side code.