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 RepliesIf 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 Relatedsome 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 RelatedI'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.
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 RelatedI 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?
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?
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?
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, "'", "''")
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?
what's wrong with this string?
" WHERE InStr (" & request("Field") & ", " & chr(34) & replace(replace(request("SearchWord"),"*","%"), "'", "''") & chr(34) & ") > 0 " & _
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 RelatedI 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 RelatedDoes anyone have a snippet that will replace ALL HTML formatting BUT
leave the <p>'s and <br>'s ??
my replace is not working
Shipping News ...i don't want news word ..mean i just want
Shipping
Code:
<%=Replace(rs("name"), "news", "")%>
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
-------------------------------------------
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
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 Relatedi 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 Relatedhow can i replace all single quotes in a string to double quotes:
Replace(strLog_text, "'", """)
however, this doesn't work, as you might expect.
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?
i want to replace string.
a= "I am trying to replace a string from 1 point to another point which is
point 2. But I dont know how ? "
b = "This"
Now from string a I want to replace from 1 to 2 with string b="this"
so the final string will be like c
c= "I am trying to replace a string from this. But I dont know how ?
This should not be this tough but I may be thinking too hard about it.
Here's what I have:
thenames="charles,sam,chris,"
How do I do remove the last comma? I tried using trim and replace
together but couldn't get it.
I have to make a change to the global.asa file on a website. I've never modified this file before. Are there any special steps needed such as restarting IIS or rebooting the machine to make the changes take effect?
View Replies View Relatedhow do i replace the double quote " in a string. My string is:
<font color="#cccccc">test</font>
I wish to replace the " with something that will repvent my string being trimmed at first " Im using asp (vbscript).
I'm making an email system, except it doesn't work when the name has spaces in it. Therefore, I want to replace these with "%20"s. Code:
View Replies View RelatedI have this code i would like to replace some html in a file with nothing before i insert into db. I am getting this error
Microsoft VBScript compilation error '800a0409'
Unterminated string constant Code:
i have the content of a db field output as 'GUEST' on a asp page, i would like to replace it with 'Guest' using the replace function, but im getting kinda lost with the syntax..can anyone help with an example?
View Replies View RelatedI am creating the following random number including date and time !
Now it creates fine but leaves an annoying space and the I want to get rid of AM / PM
as follows
822200753131 PMNXM7EMT3VY2817656XK1
id like
822200753131NXM7EMT3VY2817656XK1
here is the method Code:
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??
The string contains the text " this is "test" message"
when I pass the string the function , it gives the problem/
I tried this method:
replace(st,""","""")
it doesnot work
what is the solution to this problem?
I have an access db with a table in it that has a memo field that has blank lines and when displaying page I want to interpret these as <p> so page displays properly. Have tried the code below but not working?
<script language = "JavaScript">
{
document.write(Replace(<%=(rsNews.Fields.Item("Article").Value)%>,".","<p><p>< hr>"))
}
</script>
I have a lil text box,or I guess you can call it an upload form. I just want it to get the text and not the actual file and insert it into a column in the database.This is a local server. When i click on browse and select an item I get for example:
W:origac55640.jpg
When this inserts into the database I want it to change to
/images/orig/ac/55640.jpg
So what I plan to have in my insert statement is '"&REPLACE(imglink,"W:/","/images/")&"'... I don't know how to get the other "" to change to "/".How would I do this? Also, would that particular replace statement work correctly?