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 have data in multiple access databases (not multiple tables within one database file) and was wondering if there is a way with ASP to display selected data on one webpage from these different databases?
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 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 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 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 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:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews headline content
tblDatabank filename description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
response.write("<p>") 'I NEED TO INSERT THE FIRST PERSON'S NAME HERE response.write("<br>") 'I NEED TO INSERT THE FIRST PERSON'S JOB HERE response.write("</p>")
response.write("<p>") 'I NEED TO INSERT THE SECOND PERSON'S NAME HERE response.write("<br>") 'I NEED TO INSERT THE SECOND PERSON'S JOB HERE response.write("</p>") %> </body> </html>
That's all I have in the ASP page because I am having trouble with it. Could somebody please help with it real quick? I'm sure it's very simple, but I am having trouble learning the XMLDOM thingy.
I got a little piece of ASP code to read from a remote url, which is expected to be an xml, like a RSS feed, and echo the content out to be processed by downstream xml processor. The code is like this:
<%response.ContentType="text/xml"%><% Response.Buffer = false Dim objXMLHTTP, xml, url, text Set xml = Server.CreateObject ("Microsoft.XMLHTTP") url = Request.QueryString("url") xml.Open "GET", url, false xml.Send text = xml.ResponseText Response.write(text) Set xml = Nothing %>
Using firefox, I get the request.responseXML object back from the code above, works fine. But in IE, the request.responseXML is returned null, but request.responseText did show the entire xml file.
My question is how should I make change to the above code to let IE honor the request.responseXML object? I gues the xml is somewhat ill formatted and IE can not recognize it as an xml.
I have an ASP classic site that needs to add the option of reading an XML file send back from another web site and parsing it into a multi-column HTML table. The server is Windows Server 2003. Can anyone direct me to where I might find more info on this?
I have just created a cd based demo web with FP2000 under XP pro. The disc plays back fine on the XP machine, but when tried on a WIN 98 machine it doesnt play, and I get " G: is not accessible Device not ready" when I try to read it in Win Explorer. The disc is a 48x speed 700mb CD-R. Is it too fast for the older machine?
am trying to create a login page for the first time, I have a login page, validate login page and if the password is correct it takes me to the first page.
I have customized this code someone else created,but what I have a problem with now is I need to log who submitted that data and that is why I am trying to read UserName cookie so I can later match that data.
This is the error I get which is telling me that it is reading the cookie since this is the UserName I am logging in with Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'boxhill'.
but I can't see what is wrong, and there is not much out there for this kind of error.
So I can login successfully but now i need to read and dispaly that cookie and then insert the value of the cookie but,but don't worry about that now, just trying to give you the full picture.
What is a good method to read a file that is hosted on another server. I really want to echo the code found between a "<PRE>" and "</PRE>" tag found in the source of an externally hosted file. How should I go about this? I am somewhat new to ASP, but am confident there is a way.
I have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.