Replace And Concatenate
I've something of this sort:
stremail="task@yahoo.com;task1@yahoo.com;task2@yahoo.com"
what I need to do is.
I need to replace and concatenate it should look like this
cdomail.Address "task@yahoo.com"
cdomail.Address "task1@yahoo.com"
cdomail.Address "task2@yahoo.com"
How to do this??
View Replies
ADVERTISEMENT
String a=Test
String b=test@test.com
How cn I concatenate this to get
String c ="""Test"" <test@test.com>"
View Replies
View Related
How do I concatenate this string value? datatype is text.Code:
chkboxvalue = RS("feild1") & RS("field2")
<%
Response.write"<tr bgcolor=silver >"
Response.write "<td><input type=""checkbox"" name="" chkboxvalue "" value=""chkboxvalue""></td>"
Response.write "<td>" & RS("field1") & "</td>"
Response.write"<td>" & RS("field2") & "</td>"
Response.write"</tr>"
%>
I am getting an error:
Microsoft VBScript runtime error '800a000d'
View Replies
View Related
String a=Test
String b=test@test.com"
How can I concatenate this to get
String c ="""Test"" <test@test.com>"
View Replies
View Related
if i've two strings like:Code:
dim pic_name=replace(Request.Form("pic_name"),"'","''")
dim pic_path="pro-details/PICs/"
how could i merge the two strings to get the complete pic-path
View Replies
View Related
I am developing a school Intranet and have an ASP page that allows students to upload files to the server for marking by teachers.
Unfortunately students often do not identify themselves correctly in the work they submit, so I am trying to find code that changes the name of the file they upload, by adding the their login name. (the the server variable AUTH_USER.)
AUTH_USER is easy to get but to perform the concatenation has me stumped.
View Replies
View Related
in the programming environment that i'm developing, i use asp code to interface Automated Voice Response on my MS Access database and any other capabilities. One requirement that i need to do is to conactenate several wav files into one so i can send all recordings as one on email. I will need to program this using vbscript/asp. Is this possible? Any ideas?
View Replies
View Related
how to set a variable to the contents of an array from a certain element on
for example..
myArray(0)="zero"
myArray(1)="one"
myArray(2)="two"
myArray(3)="three"
myArray(4)="four"
myArray(5)="five"
myArray(6)="six"
I would like to set all values after two to a string variable..separated by underscores
str="three_four_five_six"
is there convenient string method for this ..?
View Replies
View Related
How do you create variables in for loop Code:
View Replies
View Related
I have an asp page and wish to concatenate a Contact Name textbox to part of an email
address and place this concatenated text into an email textbox. I know how to concatenate
but unsure of how to implement this via the textbox event, onexit. Can this be done?
The code I'm using is:
Dim EnterName
Dim NewEmail
EnterName = Request.Form("txtContactName")
If Instr(EnterName," ") <> 0 Then
EnterName = Replace(EnterName," ",".")
NewEmail = EnterName & "@something.com"
End If
The html code for the email textbox is:
<Input type="text" Name="txtEmailAddress" value="<%=NewEmail%>>
Like I said not sure if this will not work until the txtContactName has an OnExit event, or something similar.
View Replies
View Related
I have an ASP that displays two MS Access memo fields in separate table cells just fine. However when I concatenate them with SQL as in "select fld1 & fld2 as temp...." to display them in one cell only part of the first field is displayed in the table. What is causing this?
View Replies
View Related
If I replace "a" with "b", and then I replace "b" with "a", shouldn't I get the same result? That is what I am trying to encode and decode with Replace() function, but it is giving me different things when I replace and replace again. Here is what I am talking about: Code:
View Replies
View Related
I want to set up a simple database for my mom to enter her recipes into. I am going to use Access and ASP. In the database, I will have five fields (Recipe_ID, Recipe_Title, Recipe_Ingredients, Recipe_Instructions, and Recipe_Image). When my mom goes to enter a recipe, I want to ask the form to ask my mom how many Ingredients?
She will then specify "n" number of ingredients which will cause the page to display "n" number of text boxes. I can figure this part out myself. When the form is submitted, I want a script that will read and concatenate the ingredients, wrapping <li> tags around each one. The challenge for me is the reading of an undetermined number of form elements?
View Replies
View Related
some text is coming out of the DB with different urls in it, i want to delink it (like href="#" or something), how do i do that when i don't know what url is coming out?
View Replies
View Related
I've got a function that I use to replace ' marks so the page will insert properly into a database - typically I use .Code:
whatever= request.form("whatever")
whatever = replace(whatever,"'", "''")
However, I've got some code that I unfortunately inherited from someone else that I can't get the replace to work:Code:
call buildquery (colq,valq,retq,"whatever")
colq = "(" & colq & ")"
valq = "(" & valq & ")"
ssql = "insert into table_name " & colq & " values " & valq
I was trying to do something in the call buildquery line to add a replace, but that doesn't seem to work.
View Replies
View Related
How do I take out double quotes before writing to database? As doing ,""",""e;" created an error.Is it something like ,chr(34),""e;" which I sort of stumbled accross when I did soem google searching... But what and where do these chr(34) etc coem from?
View Replies
View Related
I have lots of textbox that needs to have data entry. Is it possible for me to replace the tab key to return key that transfers the focus from one textbox to another? And also, how to submit the form after all textbox have values?
View Replies
View Related
I come across this often
PHP Code:
Replace(rs.fields("Headline_f"),"''","'")
Where rs.fields("Headline_f") is actually empty.
I usually use
PHP Code:
IF NOT isNull(rs.fields("Headline_f")) or rs.fields("Headline_f") = "" THEN
Headline_f=Replace(rs.fields("Headline_f"),"''","'")
END IF
Is there a better way to handle this?
View Replies
View Related
Even though I ask customers to enter there phone number like xxx-xxx-xxxx they some times don't. go figure:
I create a text file thats used by the factories EDI system and the number needs to be xxxxxxxxxx. I'm using the code below but what if they enter their number xxx.xxx.xxxx OR (xxx) xxx-xxxx etc. You get the idea.
strPhone = Replace(objRS("DayTimePhoneNbr"),"-","")
Does some one have a small chunk of code to help me replace additional chars?
View Replies
View Related
My form gets populated from an access database. Now in the database there are fields containg <br>. While in a normal page everything works as it's supposed to, in my listbox the <br> shows as it is. What I would like to do is replace it with a space so I've used this:
<option value="<%=(rsProducts.Fields.Item("CatNum").Value)%>"><%=replace(rsProducts.Fi elds.Item("NotesR").Value),"<BR>"," "%></option>
but it doesn't seem to work.
What exactly am I doing wrong here?
View Replies
View Related
I've tried EVERY way i can think of to do this replace function, basically when i go to insert "Do's and Dont's into the database it cuts it off at "Do" because of the ' now ill show you my section of code that i have it in currently:
curdescription = trim(replace(arrTemp(4), "'", "''"))
I have it this way and it doesnt work, and i even had it
curdescription = trim(arrTemp(4))
curdescription = replace(curdescription, "'", "''")
View Replies
View Related
i use the URLencode function and it changes my form text to: this+is+it%21
ok, this is good, but when I use it in a URL, it includes "this" but then the link dies and the rest is just text, the user must then copy and paste the whole address in the browser. Anyway to get around this?
View Replies
View Related
what's wrong with this string?
" WHERE InStr (" & request("Field") & ", " & chr(34) & replace(replace(request("SearchWord"),"*","%"), "'", "''") & chr(34) & ") > 0 " & _
View Replies
View Related
i have some sql data that has " and ' in it. can someone tell me how to do a replace on those so they display correctly?
View Replies
View Related
I am not sure if this is a question for this forum or the IIS forum but here goes. I have a dedicated server on which I am hosting about 80 websites at the moment, all of which have been created by copying a template site. All of these sites have an identical structure and are located in the same directory on the server, C:Inetpubvhosts. Several times when I have needed to make an adjustment to the sites I have to go into the remote desktop connection to the server and go site by site, copying and pasting files. For example, as each site has the same pages, ie., map.asp, sometimes I make a change to that page and have to copy it to every site. Could I write some sort of script using the FSO and execute it from one site and have it loop through each site on the server making the neccessary change(s)?
View Replies
View Related
Does anyone have a snippet that will replace ALL HTML formatting BUT
leave the <p>'s and <br>'s ??
View Replies
View Related
my replace is not working
Shipping News ...i don't want news word ..mean i just want
Shipping
Code:
<%=Replace(rs("name"), "news", "")%>
View Replies
View Related
Can someone help with an error? It's a StoreFront store. right after the credit card screen is gives me the error. I get the following:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'replace' /ssl/SFLib/incGeneral.asp, line 85
--------------------------------------------
84 Function makeInputSafe(str)
85 makeInputSafe=replace(str, "'", "''")
86 End Function
-------------------------------------------
View Replies
View Related
I'm trying to use the replace function to change a variable ie like this:-
replace folder_old, txtOldFoldername,folder_rename
folder_old = c:DocumentsRoot_Testob
txtOldFoldername = bob
folder_rename = newfoldername
all i want to do is to beable to change the name bob to the new folder, is there a easier way to do this or am I on the right track. if i do the replace like this replace(folder_old, " & txtOldFoldername & "," & folder_rename & ")
i get this error:-
Cannot use parentheses when calling a Sub
View Replies
View Related
I been trying to figure out the following. I have a string of 9 numeric characters such as 000982675 and 001000510. The problem I have is in the following code:
View Replies
View Related
i can get the replace function to work in rs return but i'm returning a qs value and it's not working can someone tell what code will work with a qs.
View Replies
View Related
how can i replace all single quotes in a string to double quotes:
Replace(strLog_text, "'", """)
however, this doesn't work, as you might expect.
View Replies
View Related
I'm trying to replace the pipe character with a null value? Is that possible?I'm trying the following:
Replace(Request("strategyA"), "|", "")
I can't get it to work.Is my syntax incorrect?
View Replies
View Related