I am populating a SELECT list from a result set. I need the same result set to populate a second SELECT list. Only one list is being populated. How can I get this to populate both? Here is my code:
I'm developing a form in which people can choose to attach articles to numerous countries. I.E if someone was writing about the Commonwealth Games we could attach the article to all of the Nations in the Commonwelth. However, implementing this code wise is proving a headache. Code:
I have a fairly simple problem that I can't find a straightforward solution to. It is a form which is checked server side using ASP to make sure certain fields are valid and then re-outputs the form if it fails with the fields already filled in, including multiple select boxes. The solution using PHP would be: Code:
Is it possible to query a database base on 2 distinct fields
I have tried this, but it did not work My Query:
SELECT DISTINCT rDateTime, DISTINCT rSessionID FROM TBL_RESPONSES WHERE rsID=" & iSID & " AND ruID=" & iUID
the error i got is: Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'DISTINCT'.
Currently I have a combo box that shows records from a Select query using Group By. So it only shows each record type once. I can currently search for records using the combo box but I want to search for multiple records in the combo box.
For example, if in the combo box it shows records: Adam, Bob, Carl,,,etc.. Right now if I click on Adam, the search will bring up all of the Adams. What I want to be able to do is to be able to click on multiple records such as Adam and Carl and have all of the Adam and Carls show up.
I use a multiple select in a form in an asp page. When I go to the target page, I want to be able to read out the items selected on the previous page. How can I do that?
I want an ASP page with a dropdown and a simple button. Every time the user chooses an item from the dropdown and clicks on the button i want that value written below in list and allow user to select more.
Also how can these choices be saved somehow so tha when the user goes to the next page the choices he made can be written to the database. For example
The choices in the dropdown may be:
London Dublin Paris New York
When the user chooses Dublin I want ti written below the dropdown. Then when he chooses New York. I want it added to london. so that it displays
Dublin London
Then when he click next button these two choices are taken over to the next page where an insert query can be used to insert them into the db.
I have 4 tables first table category (category_id and category name in it) second table artist (artist_id, category_id, artistname in it) third table album (id, artist_id, album_title in it) forth table song (id, album_id, title in it)
I'm selecting category in first page I'm selecting artist in second page I'm selecting album in third page
I'm requesting, collecting and posting all id's to the next page.
this is the question!!
How can I read from database
1- category name when I was selected in first page 2- artist name when I was selected in second page 3- album name when I was selected in third page
I m trying to use multiple option menu using redirect function in ASP.
I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:
I have a form with two multiple select control (I named the first as cbo_source and the second as cbo_target). Once the form is loaded, the cbo_source loads all items from an MS Access database. Once i click the button >>, all the selected fields from the cbo_source should be transferred on the cbo_target control.
Well, I'm done with that using javascript, my problem is how am i going to get all the items from the cbo_target control once i submitted the form to an asp page(add_new_sched.asp)? I can only get items that are selected on the cbo_target, but what i need is to get all items from the cbo_target regardless if it's selected or not. Code:
I have a multiple select drop down. It will load into it the following information: Student ID, Last Name, First Name
There will be another drop down box that loads with classes, only this is not a multiple select.
I need the user to be able to select all students they need from the first drop down and then select the class they want to insert them into. Then, when they hit the button, it will break up the data from the first, Student ID, Last Name, First Name and insert those three things into the database under those respective column names.
Does anybody know how I can split these up properly when there will be multiple students selected, or does anybody have a better way of doing this?
I am working with an ASP app that creates reports based on data in an SQL Server 200 database. There is a web form with select boxes for the user to select their criteria, and based on that an SQL SELECT statement is generated.
One of the requirements is that some fields need to be multiple selections. The output of these fields are in CSV format (One, Two, Three). These values are all alphanumeric, NOT just numeric....
I have a stored procedure below.. When I run it with a well parameter in query analyser 3 of select statements return me. (i named select statements 1,2,3)
But in asp page when i call this procedure same as query analyser it returns me 2 select statements value? what is the problem ? Code:
I am Trying to use the SQL SELECT Statment to open records from multiple tables into one recordset.
I know the basic syntax of the Select statment but I wanted to know if its possible to recive the table name from the feild or the record that I am readinf from the recordset in any given moment.
To make things more clear, my example:
-Open a connection
SQL = "SELECT * FROM TABLE1,TABLE2 WHERE TABLE1.UserID=" & uid & " And TABLE2.UserID=" & uid
rs.open sql,conn,3,3
while not rs.EOF
-read from record
rs.movenext wend rs.close conn.close
now, in the part that I read from the record, is their any way I can know if that record is from table1 or table2?
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
I want to send the whole resultset i retrieved. now i am retrieving the resultset and able to print 15 records in one frame. if i want to print whole the dump records what i have to do.?
I am trying to make my result set print out the results in the same style as a calendar or photo album. I am actually making a photo album, and I can only print the results in list format. I would like to have 3 or 4 results per table row. Then once I have 3 or 4 results across a new row in the table will start. Code:
I have written an ASP script that connects to a database and runs a stored procedure and displays the results in text format ...using the <TABLE> tag. But I would like to have these results appear in a NEW Window in an Excel format. I used :
This opens up Excel in the same window and usually does not refresh my data ...even though the stored procedure is actually running on the database server.
Can anyone here recommend some service for opt in email lists. My problem is that most services will take the user off the site to sign them up and the forms are very basic. I have some complex quote forms and contact forms where people can input alot of information. I'd like to be able to add people to this subscription list if they want after processing the detailed information that they have entered. But at the same time I want to keep users in categories based on the industries that they are in so we can send targeted emails based on their industry. Does anyone know of a such a services? I've looked into listserv and lyris list manager, but I won't be able to install these apps on the webserver. So they are pretty much useless. Does anyone have any experience with this?
I have a SELECT element on my asp that is autopopulated from a search button. Currently, the user inputs the saecrh term, clicks the button and the drop down is populated from the DB. The user then select from the list. Everything simple thus far.Now I have been asked if I can get the drop down to open automatically (apparently to save the users the extra click of opening the list!!!), but I cannot find out how to automate this (then again, I have little momentum to do so at this stage) and I know this request will rear it's head again shortly.
Does anybody know where I can get some standard lists like
- a list of all countries in the world (with abbreviation, international prefix... - a list of common christian names (aaron, abbey, adeline... - a list of all currencie - a list of all language
iv searched the forums and kind find anything that fits what im looking for.
I have made an online store, but am having problems with displaying multiple different dropdown options for different products, that are listed in a repeat region
I have a form with two drop down list. I need the list items to vary by what I select. Ok..short and sweet. I have a list of dates in one....in the other I have a list of events. If I select a date in the first drop down I only wanna see the events for that day. Also if I select an event I only wanna see the dates for that event! What is the best way to go about doing this....and please dummy it down for me...I suck at sql to be honest.
Not sure if this is posible but how do you create a dropdown box where if you type a "c" it takes you to the start of the c's then if you type an "h" it takes you to the ch's etct .
I' m using a multiselect list but I have to press Ctrl when I want to choose more than one records. How can I select records without pressing Ctrl? Code:
help me with making a repeating "dynamic list/menu" . i use dreamweaver and when i put a "repeat region" on a "dynamic list/menu" the page just keeps loading forever. do i need to change the default coding dreamweaver makes...iv been trying to figure this out for literally weeks, and im about to give up. I know it can be done becuase iv seen it done.