Split() Using Database
I have a section where users can add their 'favourite venues' to a list. This is stored in a column in the users table, for example:
10,8,1,18,26
On the user area I can do a select drop-down with all their favourite venues easy.
When I try to use the same (slightly modified) code on the venue detail page to determine whether the user has the venue in their favourite to link either to ADD venue (not currently a fave) or REMOVE venue (already on the faves list) it only recognises the last added venue, i.e. (working on the list above) venue #26.
Here is the code I'm using: Code:
View Replies
ADVERTISEMENT
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
I have a string
212334||327362737||437437||47347837||8347834||
etc
but i want to enter them into a databse
but it must be as 1356235 then field 2 is 125662
dont know if this makes sense
each number is a team in a match so team 1 plays team 2, enters into databse
then move on to the next 2, in that array.
i cant seem to get it to do 2 at a time, without ending up with an endless loop or team 2 being team 1 on the second entry.
View Replies
View Related
One of my fields is the customer's social security number, all originally
entered as a 9-character string. How can I split and display that into 3-2-4
format?
View Replies
View Related
As I can split a string that contains char " "
split(string, " ") it is not correct
View Replies
View Related
What I need to do is get the content of a text file, one line at a time, and break it up using , as a delimiter.
So far I can open the file and print out all the content, but all I am getting is a million ???????'s on the screen, and not the file. Here is what I am using: Code:
View Replies
View Related
How can I calculate the number of the substrings below?
Code:
Dim txt
do until rs.EOF
txt=Split(rs("diastima"), ",")
For i=1 to number_of_substrings
Response.Write txt(i)&"<br>"
next
rs.MoveNext
loop
View Replies
View Related
I have value sSearch = Lastname Firstname
I need to split it into two separate field:
sLast = Lastname
sFirst = Firstname
I tried
arrSearch = split(sSearch, " " )
but how do I actually get the values?
View Replies
View Related
I need to send a mail for each address I found in one var. The var is as follows:
emails = "onemail@onedomain.com , other@othermail.com , another@another.com "
How Can I make a "do while var not end"?
View Replies
View Related
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
Plz guide me on the follwoing..
database=storedb
table=product
for e.g i m having 50 records in databse i would like to display the 10 records
on one page and other on second page and so on.. using asp.
View Replies
View Related
What I'm trying to do is to split up a value into two images.
For example: Rs("num") displays "12". How do i display the 12 as "1.gif" and "2.gif"?
View Replies
View Related
how can I double split this string and pu the values into an array?
string = 2_3, 4_5, 6_8;6_9, 4_6; 3_1
I need the split after "," and ";"
View Replies
View Related
I am looking for a function to split my string into subsequent parts. I am having a textbox from where user can enter more then one numbers (23, 456, 89, 394 etc), and now I want to write a function which return this sting into this fashion i.e.
23
456
89
394
View Replies
View Related
there is a method to split a string with a delimiter
checkDelete = Request("checkDelete")
arrayDelete = Split(checkDelete, ",")
my string is Trim(arrayDelete(i)), that has the format "number_number".
I want to put the two numbers in two different variables.
View Replies
View Related
i am trying to split an email address into a string.Basically, what i wanna do is take the first part of the email just before the "@" symbol and insert it into the database.
How can I do this using asp?
View Replies
View Related
I have this number
var mynum="01-12-09-908"
I want it to be saved in 4 diff variables like
mynum1=01
mynum2=12
mynum3=09
mynum4=908
Can someone tell me how I can do it ....
View Replies
View Related
The number '60' can be written as (50+10) or (25+35) or (15+45) or (7+53) etc... but I want the output as (50+10) only when 60 is typed in a textbox & the Form is submitted. How do I do this?
View Replies
View Related
I am trying to split a return value from a post by the linebreak at the end of each line in the return value ....
View Replies
View Related
How can I split an array to string?
View Replies
View Related
i have a text box, where i want to be able to enter items on a one per line basis.
i then need to insert these items into a database.
i have the functionality to insert into the db ...
View Replies
View Related
I'm pretty new at this so if someone could tell me what I need to do to the foloowing code I would really appreciate it!
strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" ...
View Replies
View Related
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 do I use the split function to break down a single word.
e.g. tree
I would like to be able to split so that:
letter(0) = t
letter(1) = r
letter(2) = e
letter(3) = e
Or is this not possible?
View Replies
View Related
I have an array which I split and then add the values into a table. In total there are 3 values in the array, two integers and one string. The integers are put smoothly but the string is not. Is it possible to add the string?
Code: ....
View Replies
View Related
how to do the following. Split a string var at each separate leter and then make an array out of it in asp(vb script). jump the cursor between textboxes automatically.
i.e tpye one letter into input field with a max length of 1 and then automatically tab to the second. The end result being able to type a whole word without looking up but still have the letters separated.
View Replies
View Related
I have the follow code
<%response.write(request.form("Select1"))%>
And when I view it the page says
Product: TShirt (27.99)
What I wanna do is to display
Product Name: TShirt
Price: £27.99
View Replies
View Related
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
I have a parameter, directory, which has value of "dir1/dir2/dir3". How can I extract the values of dir1, dir2, and dir3 from the directory="dir1/dir2/dir3". ?
View Replies
View Related
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
This code works great unless the data strValue doesnt have any new lines or no data... i get the error
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Split'
is there a way to allow it to return null or something? Code:
View Replies
View Related
I am using HTTP_Referral to track 1 out of a possible 28 URLS, and append a unique ID to that visitor. I have: Code:
View Replies
View Related
This is not really language specific but more of a source code parsing.
I have a large ASP source file that I like to split up, resulting in separate ASP files, each containing one function and the filename named after that function.
Does anyone know of a tool/script which does this?
PS: I am too lazy to learn Perl/AWK/Python to do this, hence why I believe someone has already written a tool/script to do this. Possibly in C++/etc.
View Replies
View Related
