Alternative To <select> For Large Number Of Values?
My users have to select an value from a fixed selection of values. The
obvious choice of control for such a requirement is to use a <select> (i.e.
a combo box).
My problem is that sometimes, these combo boxes will have a *large* number
of values. There could be any number of values in them from 5 to 5 million
(unlikely it would be this large but possible).
Obviously 5 million is far too much to populate a <select> control with.
Does anyone have any suggestion as to how a user could select a value from a
*potentially* very large selection of values (i.e a suitable alternative to
the <select> control)?
I would like to know if there is alterntiave to using Select Case?I have over 80 files that a user can select from a drop down list and 'read'. Rather than writing out 80+ lines with INC files, what is the other less code option?
I'm looking for a way to create over 100 Excel *charts* programmatically. We've just run a large online survey and the data is being fed back to us in a single spreadsheet - each respondent on a row and their dimensions (division, department, etc) and each of their responses in columns.
This data has to be sliced by a number of dimensions - this will require that just over 100 separate charts will have to be created. I'm looking for a way to create these charts in the most efficient way. I'm happy to normalise the data and load it into SQL Server, and can then easily extract each required subset. The output of the extract process will probably be spreadsheets in TSV format.
Last time I had to graphically report this sort of data I loaded it into a mart and used PivotCharts. The owners of they survey don't need the flexibility of Analysis Services so I'm happy to pre-define the charting requirements if it'll mean I'm able to create these charts automatically. Manipulating 100 PivotCharts was too much for them. Each chart will ultimately be fed back to users in a Word document or Powerpoint presentation with the appropriate analyses. Code:
I know that MS have limited the form data size which about 100k however, I need submit a data that may be less or more than 100k, such as 500k.
I have found a code that using x-www-form-urlencoded read the form data as binary code than using ADODB.stream to convert back to string and display it out
but, that solution cannot handle chinese word, any idea on it?
I have this SELECT box which allows users to select multiple items to delete... however if they select 2 or more items... the values get passed over as 'one, two'
So the sql looks like Delete From Table Where Field='one, two';
How do i do it in such a way that it becomes:
Delete From Table Where Field='one'; Delete From Table Where Field='two';?
I am creating an application in ASP (old school ASP not .NET) and VBSCRIPT connecting to a SQL Server 2000 back end. There is a form on my webpage that has a select box in which <option> tags allow users choose a document type.
Once the document type is determined it is sent off as a parameter in a stored procedure on the databse. The recordset returned holds the values that are required to go in another set of options boxes.
(the next set of option box values depend on the query results). I know it sounds easy...I mean I know how to do it if it where on 2 seperate pages (thats easy) where it passes on the info...but this is for ONE asp page.
I'm having trouble getting a certain value out of my database. Code:
reportID = Request("reportID") sql = "SELECT * FROM reports WHERE reportID =" & reportID set rs=Server.CreateObject("ADODB.recordset") set rs=conn.execute(sql)
I can get every value I want out except for one, rs("courses"), which is a text field that is filled from a multiple select form that enters the ID numbers of courses. The thing is, when I check the actual Access db file, I can see the value there (e.g: 1, 2, 3), but when I try to print it to my page (e.g: <% = rs("courses") %>),
I get nothing. I can't figure out why it won't work especially as I have an identical field in another table which I can get the value for using exactly the same method. Anyone have any idea what could possibly going wrong?
[Number of query values and destination fields are not the same.]
This file has worked with another project of mine but can't understand why it doesn't work with my current project. I've look at the fields being queried and the fields being inserted and they are exactly the same. I basically made a copy of the main table and called it an archive table. So this is just taking out of the main table and inserting into an archive table. Code:
I first retrieve the values stored in a session variable (where I have stored an array). Then I assign the session variable to a local array called "myarray".
Assume that "myarray" now contains 5 records. What would the code look like if I want to create a loop that transfers the 5 values from "myarray" into a select box/dropdown list?
I use a multi-select menu in an ASP so the user can pick several values.
<select multiple name="lbErrorType" size="12">
However, after I have saved the records to the DB, and the user comes back to edit a prior record, I re-populate the multiple select box and do a "<option selected>" for each record that is saved to the DB.
<option selected>
But only the last value is selected !?!?
How do I get the select menu to select ALL the appropriate values ?
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 am trying to learn and use good DHTML concepts and code (assuming they are needed). My current issue concerns how to handle this situation.
I have a Select List box which displays values based on what value is selected in a dropdown list. For example, my dropdown list contains a class name, and the Select list contains all of the students who are registered for that class.
So what I would like to occur, is when the user changes the class from the dropdown box, the Select List is re-created displaying the students who are enrolled in that class.
I thought I could do this without having to reload the page (with DHTML) but here is my problem. Code:
I have got the following PHP code which I am trying to convert to ASP.cant find a replace function for Unset in asp which will discard the variable if ($categoryid == "all") { $sql = "SELECT * FROM products where shopinspection=$shopinspection"; unset($HTTP_POST_VARS['categoryid']); unset($HTTP_POST_VARS['shopinspection']); } else { $sql = "SELECT * FROM products where categoryid = $categoryid"; unset($HTTP_POST_VARS['categoryid']); } unset($HTTP_POST_VARS['Submit']); while (list($key, $value) = each($HTTP_POST_VARS)) { if ($value != "" ) { $sql = $sql .=" AND $key=$value"; //$sql = $sql .=" AND solesource = $solesource"; //echo "<strong>$value</strong>";
i have read a few articles saying that you can run IIS on XP home but it does not look too reliable to me and am not too willing to try, so is there an alternative set-up i can use to test my ASP before uploading?
i say this as all ftp hosts seem to want your code pre-tested before uploading .
Looking for a way to switch between submit buttons. The default will be "start" and when the tech clicks on that, the button will start a timer, which I have already set.
The button then will switch to "stop" and when a tech has completed a job and clicks "stop" the timer will also stop and switch the button back to start.
I know how to track the time for each tech that starts and stops a job. I need a jumpstart on how to switch onclicks for two buttons.
I would like to set up an ASP page that sends an e-mail, but the server I'm working on doesn't have CDONTS installed for security reasons. I don't have any control over the server. Are there any alternatives to using CDONTS that will work or a better option?
Is there any other way or trick to include an asp file in my ASP file than the classic html #include. In fact my filename (which is to be included) will be coming from database and #include statement doesn't support any kind of variables.
I know this is not a core .asp issue, but I'll try anyway. I've used the TEXTAREA element for a while, but as you know it's limited when it comes to formating part of the text inside a TEXTAREA.Does anyone have expirience using other text cointainer objects (Java/ActiveX), which is easy to use and easy to read values from when sending a form to a procedure .asp page?
I'm using ASP and I need to generate a ZIP file that contains a list of files that I'm pulling from a database. I've determined WinZip's command line parameters so that I can use it, the problem is I'm unsure how to run WinZip on the server.
Set WshShell = Server.CreateObject("WScript.Shell")
WshShell.Run("c:winzip.exe")
Assuming this would work, how do I get the process to terminate upon completion? I can't have 20-30 WinZip applications running on the server, I need it to handle what I send to it and then close. Maybe I'm taking the entirely wrong approach here.
I have an asp file that gathers info from a form and sends to the database. im now changing the location of the database from the root path. I think that because of this i cannot use Server.MapPath method of sending data.
Coudl someone please help me out and let me know how i would change the code? Im quite new to this as you could probably see. Code:
Is there an alternative for CDONTS.NewMail for sending email? according to this article , CDONTS.NewMail works only on Windows NT/2000 Operating Systems.
Is there an alternative class that works on Windows XP to send email?
i am using cookies to save a users login information which is then used again on another page to save data to a database. This works fine on certain clients' machines, but on others there is an error. Am i right in saying that it is because cookies are not enabled on their machines? If so, is there another way i can do this?
I'm trying to build a contact form using ASP. The form works properly but the code I found has "Response.write "Your email..." which appears on a white page after the form is successfully submitted. Is there a different function I can use that will redirect the use to another .html page (like a "thank you for submitting...") instead? Code:
Are you suffering from the same problem? In the past, you want to access to a secured page protected by Windows Authentication (e.g. Exchange OWA), you will make such redirection "http://usernameassword@domain/exchange/".
However, because of security and Microsoft's latest patch, it will be no longer working. I wonder what we could do now if we want to do the same.
