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


ADVERTISEMENT

Using Vbscript "SPLIT" Function On Multi-select Field

I am trying to split a mgrgroup field to extract the MD codes. It correctly grabs the MD codes if all records in a mass update are updated, but if only one record in the loop is updated then it puts the last 5 digits of the mgr name in the MD field.

THIS IS THE CODE: ....

View Replies View Related

Using Vbscript "SPLIT" Function On Multi-select Field

I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset.

Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb

When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset. Instead it should be putting Alan Smir, Jeff Karl into the 1st record
and Keith Robb into the 2nd record in the recordset.

Does anyone see what is wrong with the code ....

View Replies View Related

Split Function To Split First Letters

I have a variable which holds college names

strcollege="University of California"

i want a variable to save UoC

what i meant was there are 3 words University of California

so i want the first letter in each word to be stored in a variable ....

View Replies View Related

Split Function

I want to take a server variable and split it. It would look something like this:

varServerVariable = fistname.lastname

I want it to look something like:

first = firstname
last = lastname

I know that I need to use the Split Function, but I'm not sure of the syntax.

View Replies View Related

Split A Function

I have a textbox that will have this kind of value.
eg. 1+1, 1+2, 1 +2, 1 + 2.....

So now i need to get the 1 and 2 to add it up. This textbox is for add function.

Before this i using the Mid Function. But this is only work if they entered btwn 1 - 9. If 10 then unable to find it.

I remember there is a function where it will find the value then stop at there. then i only grab the bfore the value. I try to lookup but i can't find the function. I need to get the value bfore + and after + to add it up.

View Replies View Related

How To Split Tables By Using Sub Function?

What I am doing is:

If Term = Spring2005 then display everything belongs to Spring2005

If Term = Fall2005 then display everything belongs to Fall2005

And so on.

I used Sub function to do that, but it doesn’t split it? How can we do that?

Code:

View Replies View Related

Split Function Problem

User enters a string of words and it's stored in txtHAR.

I then do this,
txtArray = split(txtHAR," ")

After this step i'm lost. Because user can enter as many words as they want how am i to track the number of words txtHAR has split into?

View Replies View Related

Split And Ubound Function

this code gives me one short of the ubound function, what is wrong?

e.g if i have 353425432,325423,2542354
it gives me 2 instead of 3

jumvar = request.QueryString("one")
jumvarsplt = split(jumvar,",")
valnum = CInt(ubound(jumvarsplt))

View Replies View Related

Split Function & Loop

I am trying to loop around a split and the code I have is below:

response.Write("<tr>")
    response.Write("<td class=""tableHeader"" valign=""top"">Keywords</td>")
    keywordsSplits = Split (keywords, ", ")
    For each keywordsSplit in keywordsSplits
        response.Write("<td>")
        response.Write(keywordsSplit)
        response.Write("</td>")
    Next
response.Write("</tr>")

The problem is that it does actually put the seperate keywords into seperate cells (td's)
I get the following:

<tr>
    <td class="tableHeader" valign="top">Keywords</td>
    <td>test test1 test2 test3</td>
</tr>

I actually want

<tr>
    <td class="tableHeader" valign="top">Keywords</td>
    <td>test</td>
    <td>test 1</td>
    <td>test 2</td>
    <td>test 3</td>
</tr>

Can anyone help?

View Replies View Related

How To Use Split Function In SQL Line?

i want to use split function in sql line ....

View Replies View Related

Split Function, Check If There Is A Space

I'm using the split function to split forename and surname, but sometimes there is no second name, is there any way of doing a check to see if there is a second part in the array?

this is the split:-
WordArray = Split(strUsername, " ")

View Replies View Related

How Do I Highlight A Split Function Text?

How do I highlight a split function text?

code ....

View Replies View Related

Split Function To Use XMLHTTP To HTML

Basically I am using XMLHTTP to pull a file ( template ) then I am using replace to replace tags i.e. [code] with a HTML equiv.

So now I need to know how I can split [Menu|http://localhost/root3/cgi-bin/templates/menu.asp?Top] so that I can use XMLHTTP to pull that file and output it as HTML.

I know how to split a string, but I can't call this [Menu|http://localhost/root3/cgi-bin/templates/menu.asp?Top] as a variable as it can change at any time.

p.s I mean how Sitepoint does the url replacement, it will have a replace function that will first search for URL and then convert what ever is after the = into a url, then what ever is after that as the name.

[-URL=http://]test[/-URL] ( I put -'s in to stop the replacement )

View Replies View Related

Multiple Split Functions And Looping Through Them

I have the following code:

that requests both products, quantity and price from the previous page and sends to the next. Now i would want to be able to iterate through them all and run some code based on the values.

Now it works well only for the first items, then throws an error ...

View Replies View Related

Array Not Created Properly With Split Function

I am having trouble loading the result of a VBscript split function into an array. The script is supposed to take the user's login name (the form for this is name separated by underscores such as john_foo or lisa_wilson), split it at the underscores, and load first, middle and last name into an array. The problem I keep getting though, is that I am getting a type mismatch error. Here is the code:

<%dim LogName, NameArray(), FirstName, LastName, MiddleName, LastPage
'Get NT authorized login info
LogName = request.servervariables("logon_user")
NameArray = Split(LogName, "_")
for x = 0 to UBound(NameArray)
response.write NameArray(x) & "<br>"
next
%>

The FirstName, MiddleName, LastName vars are supposed to take the array values later.

View Replies View Related

Split Single Variable To Get Multiple Variables

This is a simple question, but is been a while since I program in ASP and I forgot.

I have a variable like this: 01-00005-03

I need to have 3 variables from that single one... Something like this, from that variable, let for example that is called fullvariable, split it and get the following variable values from it.

variable1 = 01
variable2 = 00005
variable3 = 03

View Replies View Related

Split String To Perform Multiple Insert

I have the belwo code which i mean to do an multiple checkbox insert. I have managed to get it so i puts all the checkbox values into a string seperated by a comma, and it insert into a database, however just not how i need it to.

Curently inserst like :-

View Replies View Related

Drop Event On Tag SELECT

Is there a drag & drop even on tag SELECT, like maybe something like <SELECT
ondragdrop={go to function drag & drop}>) ?

View Replies View Related

Drop Down Menu Select An Option

Is there a way to have a drop down menu where u can select an option from the menu or type in ur own??? I am using ASP and SQL

View Replies View Related

Select Item In Drop Down Menu

I am trying to find out how to select an item from a drop down menu after a query is executed. My drop down has 4 options, and what I am trying to do is if the record stored in the database is "option2" I need the drop down menu to have option2 is selected.

View Replies View Related

Drop Down Menu Redirect To New File On Select

What would be the easiest way (JavaScript?) to have the attached form redirect a user to a sample business card on select from the drop down menu and response.write to the new file, carrying over the info the user inputs into the form? I want to change the response.write to the sample1.asp, sample2.asp etc.

View Replies View Related

Drop Down Menu Function

i have one table called PAGES . in pages i have the following columns: page_Url, title, image etc... i would like to write a function/subroutine that is called that generates drop down list of all urls (PAGE_URL) from pages table. how can i do that?
what would the code look like?

View Replies View Related

Multiple Drop Downs

i guess it depends on the domain for that answer. If it's a box with hundreds of webpages serving thousands of customers you'd want to conserve network bandwidth you'd probably want to do javascript, but i wouldn't consider reloading a page a big hit since if you just open the connection and runing two queries. But if you need the bandwidth you could do it with javascript.

I try to keep things out of javascripts and out of the hands of the client. Mainly because if they're running an older computer it will take longer to load and put unnessary strain on them and also if the client has scripting disabled you have no more drop down boxes and your site is pretty much disabled. With the strickly asp method you'd have at least the options to choose from and not any core functionality taken from it. That's my 2 cents on javascript to asp.

View Replies View Related

Creating Multiple Drop-Down

I'm either way too tired or this is a bit above my head. I have a database (access) with four fields. One field is a unique id (rs("id")), one is a category (rs("category")), the third is type (rs("type)), and finally a title (rs("title")). There are and will always be seven types, numbered 1 - 7, with each type identifying a category. To be more specific, 1 = appetizer, 2 = soup, 3 = main dish, etc.

What I am trying to do is to create seven seperate drop down list, one for each type. The options in the drop down list will each be identified with the id (rs("id") and the values for each option will be the rs("title") field. I am having a hard time in the Loop distinguishing when to end one select statement and begin another.

View Replies View Related

Multiple Dynamic Drop Downs

Im getting the functionality of it down first, thats what It looks a little bland. Anyway, the basic idea is that im trying to have a person select a department which brings up a list of class numbers, which brings up a table of tutoring times. Ive just started using ASP a week ago, so don't tear me apart too much. Code:

View Replies View Related

Multiple Drop Downs In A Form

basically what im trying to do is create a form to submit some data to an access db.

In the form i want to be able to have two dynamically populated drop downs (so if a user chooses cars in the first field it comes up with a bunch of car manufacturers, or if he chooses boats it comes up with boat builders etc etc.)

Ive searched high and low, and i the best i can find is javascript to make the drop dows. The java script however uses a form to repost the data back to the page to populate the second drop down. This wont work when its inside a form.

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

Select Function.

I'm probably doing something wrong here but when I try to get onlyl the records which occur after today's date, I get all of the records from the table, before and after today's date. 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

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

Select Name With Option Function

Is there a possibilty to use the function <SELECT NAME="user"><OPTION>user 1</OPTION></SELECT>
from a database. I want to get the data out from a table and store the data from that column in a dropdown box. What's the way to do this ?

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







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