Replacing 1 Set Of Double Quotes With 2 Sets
How can I replace 1 set of double quotes (") with 2 sets ("")
I tried this but it didn't work: myText = replace(myText,""","""")
How can I replace 1 set of double quotes (") with 2 sets ("")
I tried this but it didn't work: myText = replace(myText,""","""")
I am pulling data from a table to create a <select> list. I need to wrap the value= in double quotes. Code:
View Replies View RelatedI have an asp page.I have all the form tags, javascripts etc in that. For e.g In my asp page I have mentioned my form tag as
<form name=frmupdateskill method=post>
and javascript as
<script language=javascript>
some code...
</script>
I send this asp page to my onsite person. When he replaces the old asp page with the one I sent the following are the things I come across. Code:
I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.
When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.
confirmation page
Code:
<input type="hidden" name="results" value="<%=results%>" />
final page
Code:
results = request.form("results")
results = replace(results,""","""")
results = replace(results,vbcrlf,"<br />")
Got a stubborn problem with double quotes
i can replace two single quotes but how do i replace a quotation mark e.g. (") and not ('')
Replace(rstSimple3.Fields("Description"), "''", " ") works
Replace(rstSimple3.Fields("Description"), """, " ") cuases error!
i want to know how to include double quotes in " "
such as
somevariable=" "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("kb.mdb")" "
note this is example given by me.
i only want to know that
how to include double quotes within double quotes.
I got to place a loop to create a call to javascript with different ID' s generated by asp like in the following code ...
View Replies View RelatedI have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.
View Replies View RelatedWhen you want to put double quotes inside a string, how do you verify that the double quotes are not the end to a string? For example, what if you want to write this. Code:
"Response.Write("The words "DEV SHED FORUMS" are in double quotes")
Could someone explain when to use double and single quotes? I'm having a problem with an insert statement and I think it may be the quotes. The error I get is a sql syntax error.
Here is the sql statement:
strSQL = "INSERT INTO [Members] (Website, email, category, phone_no, fax) " _
& "VALUES ('" & web & "','" & mail & "','" & cat & "','" & phone & "','" & fax & "')"
The values are variables. I checked the input statements first then assigned to variables. I hoped it would make the sql statement easier for me too read. Also does Access accept null?
I'm trying to solve three minor problems with vbscript REGEXP.
1) I want to find any occurences of and|or|not in a string and capitalize them.
regEx.Pattern = "(s)(and|or|not)(s)"
KW = trim(regEx.Replace(KW, "$1" & ucase("$2") & "$3"))
how come this is not working?
2) when highlighting words (in a search results page for example), I want to match the word ignoring case. however, when wrapping the word in highlighting code and replacing the substring, I want to keep the original capitalization.
regEx.Pattern = "(^|s|[^a-z0-9])" & highlitetemp(iTemp) & "(s|$|[^a-z0-9])"
Body = trim(regEx.Replace(Body, "$1<span class=highlite>" & highlitetemp(iTemp) & "</span>$2"))
for example, if the word to match is marvelous, but the word is stored uppercase in the db, the above code will replace the word with a lowercase version. how do I get around this?
3) I want to remove any and|or that are not inside double quotes in a string. for example,
test = """The dog and the cat""" & " and fox or mouse " & """the cat and the dog"""
resulting in "The dog and the cat" and fox or mouse "the cat and the dog"
I would like to remove only the AND OR linking fox and mouse in the middle of the string. how would I do that?
I have the following regular expression:
re.Pattern = "style[^=]*=[^""]*""[^""]*"""
It will grab any style attribute within HTML that uses double quotes, and put it in the re.Matches collection.Now, I want to include single quotes into this regular expression. Here's what I have so far:
re.Pattern = "style[^=]*=[^""']*(""|')[^1]*1"
but it does not work.
Is there a way for me to determing if a column exists in the table? ex. I
have RS("var"), where RS is a recordset. My code is dynamic but some tables
will have "var" while some won't.
Is it possible to have an ASP form where there are 2 form fields, each mapped to a separate Access Table? Say for example
Dim rsOne
Dim rsTwo
rsOne mapped to tblOne in Access File Mydb.mdb
rsTwo mapped to tblTwo in Access File Mydb.mdb
i want to left join result sets together coming from two different databases based on a common field storenumber. They are separate databases as per management design.
Basically it should match rows based on the store number, those who don't have matches should display only the storenumber and no other info like: Code:
Store Q1 Q2 Q3 Q4
1 x x x x
2 x x x x
3 <--No data in 3, just display storenumber
4 x x x x
how can i compare 2 record sets. In one RS i have excel file and other RS i have SQL server and when i get the results from both i want to compare them as one of you guys suggested me to write a loop that cycles through the record sets Comparing any fields.
View Replies View RelatedWhat would be the most efficient way to check to see if a cookie matches a record in a DB table?
If the user's cookie matches a record in a table of executives, then I want to display a breadcrumb menu item just for that executive.
This does not have to be super-secure or anything, I just want to keep honest people honest.
If the information they submit in a cookie is also present in a table of executives, then I want them to see a comprehensive menu set. If they are not in the table, then I want them to see a reduced menu set.
How to go about comparing a cookie with multiple values or keys with a record in a table?
im a passing 3 fields from a form to use a search criteria against an access database table, i have set the fields a numeric values, what should i use to allow all records to be shown for a invidual value rather than a selected value.
Ie the form would pass
Location_id as 22
so the result page would see Request.form("Location_id")
sql would then see
where location_id = var1
var = 22
but i want to get the sql to say
where location_id >=0
what do i need to do
Before I created this thread, I've searched Google and used the search feature of this forum numerous times on how to do this, but couldn't find much.
Basically, I'm trying to pass multiple sets of values from the search form to the ASP into an SQL statement (Access Database).
I can only make it display different prices of a certain music type, eg all prices of rock. But it doesn't output all types of music for certain prices, eg viewing Classic and Rock records with prices of 8.99 and 10.99 only.
I've used the REPLACE command I've found and got around that problem of syntax with numeric/alpha data. Code:
I'm a little perplexed. <%@Codepage="65001" %> changes how IIS/ASP will handle interpreting query string variables - i.e. it will read the querystring as being utf-8 encoded.
However, I'm finding that it *doesn't* change how Response.Cookies or
Request.Cookies get read/written.
I've been testing with a little jscript asp page with the lines
if (String (Request.QueryString ("abc")) != "undefined")
Response.Cookies("abc") = Request.QueryString ("abc");
Response.Write (Request.QueryString ("abc"));
to take a value from the query string and pass it back out as a cookie. The test value I was using was r%c3%a9sume (resume with an accented e). When the code page is set to utf-8, it will properly interpret the urlencoded query as a utf-8 string. It will output the right bytes with Response.Write.
But watching the headers produced by the request, it comes out encoded in latin-1.
Set-Cookie: abc=r%E9sume; path=/
I checked the cookie rfc on w3c.org, and oddly it doesn't say much about how to encode/interpret cookie NAME=VALUEs. The only comment on character set in the spec is that a cookie *comment* has to be utf-8 encoded.
I couldn't find anything on the MSDN documentation that addressed cookie character sets either.
I have an ASP page that displays data from a SQL database. It includes some Canadian names/address which contain the special accent characters...my ASP page doesn't display them properly. I have included the tag
<META HTTP-EQUIV="content-type" CONTENT="text/html; charset=ISO-8859-1">
but they don't show up correctly...what else do I need?
Update: Turns out the source of our data gave us the old IBM codes, not the newer codes...for example, they gave us 144 instead of 201, and using the charset of 8859-1 won't allow 144 to be displayed. When replaced with 201, the character displays just fine.
I'm working on a project, trying to create an HR hiring intranet page. Basically, here is problem. I have a table in a database called "Title Access" that lists titles, and has software, email, and user rights associated with each title. For example, Network Administrator will get Office, Dreamweaver, be part of the IT and Admin groups.
Now, here is the issue: Whenever the user types in the name, pay rate, hire date, and title on the intranet page then clicks "submit", I want the database to create a new user in the "employee" table with that name, and populate the access rights in that table with the rights associated with the title. Thus, the "employee" table will now include "John Doe", and will have Office, Dreamweaver, IT, Admin checked off. Is there any way to do this????????????
I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.
On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.
I am fimliar with asp javascript and not asp VB.
i can display the results ok, but if i return 100 records from my table i would like it to display 5 records per page. i have looked at asp recordset paging on several sites, however cannot find any scripts that work with ASP JAVASCRIPT....
I read that the "?" caracter can make you trouble with some search spiders. Although I know the Spiders are upgrading to evade this indexing problem, it is still an obstacle for some search engines.How can you refrain from using "?" in urls, for example, in a dinamically runned site?. Some CMS do it replacing that caracter with the slash bar "/", that is more spider-friendly.
In brief:
1. Is "?" still giving problems?
2. In case it's still making problems. How can I replace it?
Does Anybody Know Howto Switch All Positive Signs(+) For Negitive Signs(-) And Negitive Signs For Positives?
View Replies View Relatedthat is generated by a database that I don't have access to?
So, I use a database drived store. It is not open source, so I do not have access to adjust the HTML that is generated.
Unfortunately, the code is fairly messy, and contains un-necessary breaks, paragraphs, and other code that I don't want there! A lot of it I've been able to adjust with css, but the biggest thing that bugs me, is that there is a table and a td that are at a set width. It is set at 'width=550'. I would like to either remove that, or change it to 'width=95%'.
Is there anyway I can accomplish this? What I do is create a template .htm page that the asp uses. Is there anything I can do in the .htm to replace or remove this HTML? Javascript? A snippet of ASP code? Or should I just learn to live with it?
I need to replace some dynamical content away from a text, only static thing
is that it starts with <!-- Start dynamic --> and ends with <!-- End dynamic
-->. How do i dynamical remove these two tags and all the content between
them?
I'm sure this isn't difficult, but it's Friday afternoon (!).
I'm trying to use a regular expression to match html tags in a string
and convert them to lower case. It's the RegExp object that I'm
struggling with rather then expression syntax.
So far I have this ('HELP!' denotes where I'm stuck):
private function recoverHTML(sHtml)
dim oRegExp
set oRegExp = new RegExp
oRegExp.IgnoreCase = False
oRegExp.Global = True
oRegExp.Pattern = "<(.*?)>"
sHtml = oRegExp.Replace(sHtml, HELP!)
set oRegExp = nothing
end function
I'm thinking of something like this:
"<" & lcase($1) & ">"
What syntax do I need here?
With hosting for clans, more so then not, the clan tags contain charactures
like + { [ in front of the tag letters.
what I am having a problem with is if it starts with a +, it isn't picking
up the name correctly. If in a sql statement, it looks for a tag that starts
with a +, it won't find it. And sometimes, when it is supposed to move the
tag over in a bracket, it moves it without the +.
for example, +EcK+ is the tag, it will either not find it, or move it over
as EcK without the +'s.
is there any way around this?
i know for some strings, such as things with ' you can use
replace (request.form("var"), "'", "''")
I put in some code to keep apostrophes from being a problem. However, on the
display page, they have double quotes. What am I doing wrong?
Here is the code on the page which captures the data from the form, right
before it gets entered into the database:
------------------------------------------
strInternalDesc =
Replace(Replace(Trim(Request.Form("InternalDesc")),"'","''"),vbCrLf,"<br>")
------------------------------------------
then, on the page where it gets displayed, I get:
I want to mask part of a field upon displaying it. field name is "IP", how do I mast the first 4 characters with "*" symbols?
View Replies View RelatedI have a printer friendly page script, that outputs the text less any includes, it works well in IE, but firefox grabs the "'<%@LANGUAGE="VBSCRIPT" %>" and outputs it to the print version page. SO i get a nice printer version - but with <%@LANGUAGE="VBSCRIPT" %> at the top.
Does anyone know how to write a conditional region like:after <body> if string is "<%@LANGUAGE="VBSCRIPT" %>" replace with ""?