Moving Data Between Select Boxes
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
View Replies
ADVERTISEMENT
Does anyone know if there is a way to select an item in a select box by
typing the beginning of the word and it finds it in the list?
As an example:
Say I want to go to the item named "M1234" in the list.
When I type M it goes to the first "M" item.
When I type 1 it goes to the first "1" item.
Is there a way to make it go to the first "M1" item instead of jumping back
to the "1" item?
Is it even possible to do this in classic ASP?
View Replies
View Related
I have 4 tables in my db which represent an county split up:
1 County split into 3 Divisions split into 2 Districts split into 10 Section
I have a query which pulls all the tables together to show every Section, its district, division, and county. Obviously, each Section only appears once each District 20 times and so on.I want to have 4 select boxes on my page which represent the break down:
county > division > district > Section
This is to enable a user, from any page, to filter the content of that page by whatever breakdown they wish.The question is how best to populate the 4 select boxes (well 3, county only has one option!)? I could have 4 queries on my page (4 hits to the db!), have one query and filter for each select box etc
View Replies
View Related
I have two list boxes . User can select multiple values from the lists. Is there a way I can force that the user can select from only one of the list boxes? Can I associate the radio button with the list so that as soon as user selects the radio button the other list box turns grey(not letting the user to select anything from that list).?
View Replies
View Related
The good news is that I have a code in place that allows all form data to be submited to me, everything displays except the select boxes data. I have tried to search for this and know that it must be do able as it is used on big company sites. Code:
View Replies
View Related
I have a Stored Procedure with a Where clause for a date range, I would like to know is it possible to add onto my Classic ASP two select input boxes for filtering my date column?
For instance filtering January 15, 2008 thru February 14, 2008. If so would you be able to show me what that might look like?My where clause starts on 01-01-2005 and end on a future date, for example 12-01-2040
View Replies
View Related
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....
View Replies
View Related
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
View Replies
View Related
I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
View Replies
View Related
how's the best way to handle yes or no check boxes in a form and DB?
I am building an apllication using ASP and MS SQL 2000. The form will have a total of
34 yes and no check boxes. That is, users will have to make a choice(s) by checking either one.
So my question is, for efficiency on the SQL side, what's the best data type to use?
View Replies
View Related
I need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.
View Replies
View Related
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
View Replies
View Related
Say I want to sort the data in both db's according to similiar properties and read the results in a table.
View Replies
View Related
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.
View Replies
View Related
I am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM,
and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
View Replies
View Related
i try to get data form access with asp. The select contains 2 Subselects. If i set this SQl statement in Access it works. But if i set this in ASP it doesn't. Why??? There is no error. It's completly the same statement.
View Replies
View Related
I have a form (which is multipart/form-data) it has a file field and a select. When i submit this form i can get the file but i can't get the value of the select? any ideas?
View Replies
View Related
Is there a way to retrieve the DESCRIPTION in the following code from within the process.asp page without adding additional fields to the form?
<form name="myForm" method="post" action="process.asp">
<select name="Options">
<option value="1">DESCRIPTION</option>
</select>
</form>
View Replies
View Related
this is the code I am using for MS Access
Code:
mydb="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("database.mdb") & ";"
set conn= server.createobject("adodb.connection")
conn.open mydb
I want to know what code I can use to connect via MS SQL,
I tried this one,: but no luck
Code:
mydb="driver={SQL Server};server=YOURSERVER; UID=YOURUSERID; PWD=YOURPASSWORD; database=YOURDATABASE"
set conn= server.createobject("adodb.connection")
conn.open mydb
View Replies
View Related
Looking for the best resource (book, online article, etc) for moving from ASP 2.0 to ASP.NET. I'm ready to make the jump. What do you think?
View Replies
View Related
Does anyone know how to code a button that when hovered over moves. Then maybe on the 3rd roll over it will not move and actually allow the user to select it?????
View Replies
View Related
i have this in the database section of devshed - but noone seems to know... so i'll put it in here now
View Replies
View Related
Is it possible to moves files to and from other servers in ASP?
I'm in the process of incorporating a VBS script into ASP that used to
do this job for me. However the VBS script was setup to run through
Task Scheduler as a domain user, which allowed it to connect to remote
hidden shares.Or alternatively, could I leave the VBS script as it is and have the
ASP page execute it on demand somehow?
View Replies
View Related
How would I go about reordering records in a database? Say for example, I wanted to change the output of something, and I could just click a link which would move the record up
View Replies
View Related
I have to move a file(Excel file) to a folder that resides in
a different server using asp. how do i that. I tried using
move file method in file system object, it says
file path not found.
View Replies
View Related
i have 2 rows in the table... and i wan to do a response.write("REMARKS")
the remarks sumtimes can be longer then the width of the table...
how to i make it such tat when the max width in row 1 has been reached then it will carry on writing onto the second row of the table???
<table border="1" width="100%" id="table1">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
where to place the response.write or how to add in additional codes to achieve this function?
View Replies
View Related
I have a web site and database is on SQL server,now I need to move it from this server onto another one that is on a different location as well.This process is completely new to me,would somebody have an advice or a link where I could read some info about doing this, as I am not sure where to begin.
View Replies
View Related
I have a freind who wants to convert his ASP site (with a HUGE MSAccess database) to MySQL etc. so he can move to a Linux server.What all would be involved in the conversion? I have redone an ASP site to .xhtml and .php but there was no database to deal with.
View Replies
View Related
I don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
View Replies
View Related
I currently have the below working they are testimonials, displaying 1 every day and therefore i would like be able to page through them from clicking a next> or more> link also
if WeekDayName(weekday(now)) = "Monday" then
Response.write("")
else
if WeekDayName(weekday(now)) = "Tuesday" then
REsponse.write("")
View Replies
View Related
I need to move some SQL tables from one unresponsive ISP to our new mo bettah one. Naturally the current host is not being quick about getting a cd of our tables to us. I was going to write code to move them from one place to another but it is not so easy. If it runs on the old server it can't access the SQL on the new server and vice versa.
The alternative that I see, is to download them into text files and rebuild them on the new server but that is a lot of work. Any quicker fixes out there that anyone knows about?
View Replies
View Related
If I have a page. And I want to move this. What is the best way to do this while preserving the rankings in Google (and other search engines)? From what I've read, I want to send HTTP 301 (Moved Permanently) when the old URL is accessed. But I believe Response.Redirect sends HTTP 302 (Moved Temporarily).
View Replies
View Related
I have an asp page that has 12 tables, 3 tables per row, . Im trying to get my query to fill each table with 6 records and then move to the next table with 6 records...etc then after the 3rd table start a new row. I know I have seen an example of this before, can someone point me in the right direction?
View Replies
View Related