Create SQL String With Multiple Select Boxes

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


ADVERTISEMENT

Select Boxes

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

Several Select Boxes

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

Select One Of The List Boxes

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

Select Boxes And Asp JMail

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

Two Select Input Boxes

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

Create As Much As U Want Of Dropdown And Tect Boxes

i want to create a textbox and when i enter a number on it ,for example 3 ,and send submit , i will have 3 dropdownlist(all of them is the same) , and choose different things from these 3 dropdownlist , so ican sumit 3 stuff everyone is separte than the other , and to the same userid

so how this could be?!? cause i dont knowe how it will be send to the same table , and they have also the same Name.

View Replies View Related

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 View Related

Multiple Check Boxes

I have this form which the user will fill online.Now the form has 3 checkboxes giving a user the option of selecting which person/persons out of the three listed should get the form email when he hits submits.

So the form has three checkboxes and each checkbox will have a name of a person next to it.The user just needs to check it (one name or all names out of three) and after he hits enters a mail shud go to the respective selected people.I was thinking of using CDONTS to send mail..but i cant figure out how i shud do it with this mutliple checkbox scenrio?

View Replies View Related

Multiple List Boxes Dependent

I am working on a survey form. I need to create multiple-multiple dependent istboxes...I need to allow the user to make multiple selection from a categoryListbox and as the user select from categoryListbox must display and add available subcategories into the subCategoryListbox and allow to select multiple subcategoris.

View Replies View Related

Multiple Dynamic Drop Down Boxes

I have a form with 2 drop down menus. the first is populated via a database query and the second gets populated based on the selection made in the first box. (Category/Sub Category)

I am having a difficult time keeping the initial item selected after the page reloads. I thought that this statement would work: Code:

View Replies View Related

Multiple Drop Down Boxes Querying A Database

This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:

View Replies View Related

Searching Database With Multiple Text Boxes?

The user can search the database when they put in a date, that works fine, but when i put in another text box to search the database for a certain date range Code:

View Replies View Related

Multiple Drop Down Boxes Retrieving Data From DB

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

Create.Object(SQLActions.Select)

I am trying to migrate some websites to IIS 6 and this code does not work in IIS apparently, at least I have not found a way to make it work after 10 business days of trying. In ASP is there another way to accomplish this that may be more suitable: Code:

View Replies View Related

Multiple Select After Validation

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:

View Replies View Related

Repopuate A Multiple Select

I am trying to repopulate a multiple select box in a webpage from a recordset.

Say I have the following recordset.

sSQL = "select geoID from table1 where srID = 3"
set adoRS = adoConn.Execute(sSQL)

Lets assume that it returns three records with geoID = 1, 2, 5

Lets say I am building a multiple select as follows: Code:

View Replies View Related

Select Multiple Distincts

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'.

View Replies View Related

Select Multiple Data

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

Reading Multiple Select

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?

<form method="post" action="compare1.asp" name="Compare">

<select name="motorcycle" multiple size="20">

<%While not RSItems.eof%>
<option
value="<%=RSItems("ID")%>"><%=RSItems("Brand")%>&nbsp;<%=RSItems("Type")%>
<%
RSItems.movenext
wend
%>

</select>
</form>

How can I read out the items selected?

View Replies View Related

Create A Recordset With Multiple Tables?

My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables.

How do I create a recordset that can handle the relationships and bring in all data?

View Replies View Related

How To Create Multiple Text Fields

How to create multiple text fields and will be submit when press a "enter key" ...

View Replies View Related

Select Multiple Option Not Working

I have a form search page with many field options but this one field I would like to select multiple options.

I have this on the search screen for my multiple field where I pull the list of options from my database: Code:

View Replies View Related

Submit Items From Select Multiple

I want to submit items from <select multiple> list into database.Should I use arrays?

View Replies View Related

Select Multiple Items From A Dropdown

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.

View Replies View Related

Select Different Fields In Multiple Tables

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

View Replies View Related

Multiple Select In Dropdown List Box

How to make multiple select in dropdown list box using asp and access.

View Replies View Related

ResultSet For Multiple Select Lists

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:

<select name="options" size=10 multiple="multiple">
<% while (!rs.EOF) { %>
<option value="<%=(rs.Fields.Item("FIELD1").Value)%>">
<%=(rs.Fields.Item("FIELD1").Value)%>
</option>
<% rs.MoveNext(); }
if (rs.CursorType > 0) {
if (!rs.BOF) rs.MoveFirst();
} else {
rs.Requery();
}
%>
</select>

View Replies View Related

Multiple Select Options At The Same 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:

View Replies View Related

How To Submit All Items From A Multiple Select Control

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:

View Replies View Related

Split Function And Multiple Select Drop Down

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?

View Replies View Related

Select Database Then Multiple Tables For Updates

What I want to do I select one database and the set the Rs1, rs2 etc.. like in Vb6 I would set DB then:

Set rs1 = db1.OpenRecordSet("Table1")
Set rs2 = db1.OpenRecordSet("Table2")

etc...

However how do I do this in asp3? Code:

View Replies View Related

Selecting Multiple Tables Using SELECT Statment Problem

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?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved